&&<Data&&>Microsoft.SqlServer.Dts.Pipeline.BlobColumn&&</Data&&>
I have a custom (dataset) destination component from ms samples and it has an input holds DT_NTEXT value.
Whenever I try to retrieve data from this it returns "Microsoft.SqlServer.Dts.Pipeline.BlobColumn" as value.
I try this but didn't work:
String sValue = System.Text.Encoding.Default.GetString(Convert.FromBase64String(this.dataSet.Tables[0].Rows["Data"].ToString()));
It throws an execption "invalid character in.."
Please help how I can convert this?
Thanks in advance
View Complete Forum Thread with Replies
Related Forum Messages:
Microsoft.SqlServer.Dts.Pipeline.BlobColumn
I am using Component Script to do - Transforming Comma-delimited list row data to column and I want to use MessageBox to see the value Dim DataPnts As String DataPnts = Row.DataPnts.ToString() -- this is my input column (data type = text in Source table and I put as Unicode string [DT_WSTR] in Output column) MessageBox.Show(DataPnts, "DataPoints1", MessageBoxButtons.OK) ---and why can't I see it. It gives me some message with Microsoft.SqlServer.Dts.Pipeline.BlobColumn. Why? Values = DataPnts.Split(CChar(",")) Please point me to more info on how to do transform Comma-delimited list row data to column. Thanks.
View Replies !
Microsoft.SqlServer.Dts.Pipeline.DoesNotFitBufferException
Hi I have a SSIS project that has one parent package and three child packages. When I run the project on my development machine in debug mode it works fine. Also if i run the packages using dtexec on my development machine it still works fine. However the problem comes in when I try and run the project using dtexec on the staging server i get the following error: Microsoft.SqlServer.Dts.Pipeline.DoesNotFitBufferException: The value is too large to fit in the column data area of the buffer. does anyone have any idea how to fix this please? thanks G
View Replies !
Imports Microsoft.sqlserver.dts.pipeline Does Not Work
I have been trying to follow/implement the examples in the following help topics (thanks to Jamie for these links). Building Packages Programmatically (http://msdn2.microsoft.com/en-us/library/ms345167.aspx) Connecting Data Flow Components Programmatically (http://msdn2.microsoft.com/en-us/library/ms136086.aspx) The problem I am having is that MainPipe is not recognized as a valid type in my Script task, even though I have the imports statements that are listed in the example. I get the message "Error 30002: Type 'MainPipe' is not defined". The other and related problem is that when I type "imports microsoft.sqlserver.dts", the intellisense offers only two choices: {}Runtime and {}Tasks. I don't see any choice for Pipeline. Can anyone tell what I am missing? It seems to be some kind of configuration/installation issue, but I have no idea how to resolve it. I have tried this on 3 different machines, with both the RTM SQL 2005 standard edition, and with SP2 installed, all with the same result. Any help is appreciated Here is my code: ' Microsoft SQL Server Integration Services Script Task ' Write scripts using Microsoft Visual Basic ' The ScriptMain class is the entry point of the Script Task. Imports System Imports System.Data Imports System.Math Imports Microsoft.SqlServer.Dts.Runtime Imports Microsoft.SqlServer.Dts.Pipeline Imports Microsoft.SqlServer.Dts.Pipeline.wrapper Imports Microsoft.SqlServer.Dts. Public Class ScriptMain Public Sub Main() ' Dim package As Microsoft.SqlServer.Dts.Runtime.Package = _ New Microsoft.SqlServer.Dts.Runtime.Package() Dim e As Executable = package.Executables.Add("DTS.Pipeline.1") Dim thMainPipe As Microsoft.SqlServer.Dts.Runtime.TaskHost = _ CType(e, Microsoft.SqlServer.Dts.Runtime.TaskHost) Dim dataFlowTask As MainPipe = CType(thMainPipe.InnerObject, MainPipe) Dts.TaskResult = Dts.Results.Success End Sub End Class
View Replies !
Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer Column Ordinal From Name?
Hi, I need to access columns from a data flow by ordinal position in a script transformation (I'm parsing an excel file which has several rowsets across the page). The first problem I encountered is the generated BufferWrapper does not expose the columns collection (i.e. Input0Buffer(0) does not work) but I got around that by implementing my own ProcessInputs(InputId, Buffer) method instead of using the wrapper. My problem now is that the column ordinals are in some random order (i.e. Column "F1" is ordinal 1 but Column "F2" is 243). Where in the object model can I map between the name and the ordinal - it's not jumping out at me? Dave PS Why is the script editor modal, it's frustrating having to switch between the Visual Studio environment and the VSA one.
View Replies !
Pipeline Error-excel Source-data Reader Does Not Read In Meta Data
Hi all, i got this error: [DTS.Pipeline] Error: "component "Excel Source" (1)" failed validation and returned validation status "VS_NEEDSNEWMETADATA". and also this: [Excel Source [1]] Warning: The external metadata column collection is out of synchronization with the data source columns. The column "Fiscal Week" needs to be updated in the external metadata column collection. The column "Fiscal Year" needs to be updated in the external metadata column collection. The column "1st level" needs to be added to the external metadata column collection. The column "2nd level" needs to be added to the external metadata column collection. The column "3rd level" needs to be added to the external metadata column collection. The "external metadata column "1st Level" (16745)" needs to be removed from the external metadata column collection. The "external metadata column "3rd Level" (16609)" needs to be removed from the external metadata column collection. The "external metadata column "2nd Level" (16272)" needs to be removed from the external metadata column collection. I tried going data flow->excel connection->advanced editor for excel source-> input and output properties and tried to refresh the columns affected. It seems that somehow the 3 columns are not read in from the source file? ans alslo fiscal year, fiscal week is not set up up properly in my data destination? anyone faced such errors before? Thanks
View Replies !
Failed To Retrieve Data For This Request. (Microsoft.SqlServer.SmoEnum)
After getting an RPC error when trying to login to my server via either consol or Terminal services, then rebooting, I can no longer connect to SSIS Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476 ------------------------------ Connect to SSIS Service on machine "BG-22SQL" failed: The service did not respond to the start or control request in a timely fashion. . ------------------------------ Connect to SSIS Service on machine "BG-22SQL" failed: The service did not respond to the start or control request in a timely fashion. .
View Replies !
Failed To Retrieve Data For This Request. (Microsoft.SqlServer.SmoEnum)
hi, I´m trying to connect to a integration service hosted in a different machine, but I recive the following message: Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) : access denied I verified and the service that machine is running, maybe could be the user, I´m using windows authentication, I have no problems when I log in in the databse engine. Can somebody help me??
View Replies !
Failed To Retrieve Data For This Request. (Microsoft.SqlServer.Express.SmoEnum)
I am learning the new .Net programming. In order to do that I have SQL Express Edition, Visual Basic 2005 Express edition and Visual Web Developer Express Edition too, I have too the tools for SQL wich are SQL Server Management and SQL Server Configuration. The problem that I want report you is the following: I developed an application in Visual Basic Express Edition that access one SQL database. I have no problem if only acces it trough VB Express, but if I try to see the database via SQL Server Management or via Visual Web Developer Express Edition Or via Excell or whatever. It sends me the message error: =================================== Failed to retrieve data for this request. (Microsoft.SqlServer.Express.SmoEnum) ------------------------------ For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476 ------------------------------ Program Location: at Microsoft.SqlServer.Management.Smo.Enumerator.Process(Object connectionInfo, Request request) at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.DatabaseNavigableItem.GetChildren() at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ExplorerHierarchyNode.BuildChildren() =================================== One or more files do not match the primary file of the database. If you are attempting to attach a database, retry the operation with the correct files. If this is an existing database, the file may be corrupted and should be restored from a backup. (.Net SqlClient Data Provider) And after that any application can not read this database, and I have to restore from a backup, and continue with my developing in VB.Net. Some people said me that the problem is the oleobject in .Net, that I have to change to ODBC. Is it correct? Do you know something about this?
View Replies !
BlobColumn.GetBlobData() With Data Length &&> Integer Length (32767)
For those of you who would like to reference my exact issue, I'm dealing with the RSExecution SSIS package at the "Update Parameters" data flow task, at the Script Component. The script tries to split parameter data into name and value. Unfortunately, I have several reports that are passing parameters that are very large. One example has over 65,000 characters all in the normal "¶mname=value&parm2=value..." format. The code in the script works fine until it gets to one of these very large parameter sets. I have figured out what is causing the issue. Here's some code: Dim paramBlob as Byte() paramBlob = Row.BlobColumn.GetBlobData(0, Row.BlobColumn.Length) The second parameter of the .GetBlobData function takes an INTEGER as its count! Therefore, no matter what kind of datatype I pass to the string that the script will later split, it will be limited to 32767 characters. THIS IS A PROBLEM!!! Does anyone know a workaround for this issue? I need all of the parameter data to be reported, and I would hate to have to skip over rows like this. Also, if I'm missing something, please fill me in! Thanks for your help in advance, LOSTlover
View Replies !
Transformation Object To Filter Data In Pipeline
Hi, I have some data coming through pipeline and I wanna add some component at some point to pass on only selected rows based on conditions to the objects onwards. My opinion is I should use conditional split object, but Please suggest me something if you know better. Thanks, Fahad
View Replies !
How To Data Transfer From Excel To Microsoft SQL Server Data Base Using .Net.
Hai All, How to Data Transfer From Excel to Microsoft SQL Server Data base Using .Net. I have one Excel Sheet in that sheet 15 Fields (attributes) and 3000 records are there. In this 3000 records i want to store this (Excel) data into 5 related tables on Sql Server Database Using .Net. How to store Excel Sheet data into Sql Server database. Please help me as soon as possible. Thank You Very Much...Have a Good Day... With RegardsSridhar
View Replies !
Problem Unicode Data 0x2300 In SQLServer 2000 SQLServer 2005 Express
Hi experts; I have a problem with unicode character 0x2300 I created this table create table testunicode (Bez nchar(128)) Insert Data insert into testunicode (Bez)values('Œ€„¢') with 2 Unicode characters Œ€ = 0x2300 „¢ = 0x2122 Selecting the data select Bez from testunicode I see "?„¢" „¢ = 0x2122 is ok but instead of 0x2300 there is 0x3f When I modify the insert statement like that ( 8960 = 0x2300 ) insert into testunicode (Bez)values(NCHAR(8960)+'„¢') and select again voila i see "Œ€„¢" Does anyone have an idea? Thanks
View Replies !
Joining MS SqlServer Data With Oracle Data
OK so there is some data in an Oracle DB that I need to query and analyze. Unfortunately, the criteria for selecting/grouping the data is stored in a MS Sql Server DB. This cannot be changed. SqlServerGroup Name ID# Item ConditionAAA123 1 a 1AAA123 2 a 1AAA123 3 a 1AAA123 4 a 2AAA123 5 a 2AAA123 1 b 3AAA123 2 b 4AAA123 3 b 3AAA123 4 b 4AAA123 5 b 3BBB123 1 a 1BBB123 2 a 1BBB123 3 a 2BBB123 4 a 2BBB123 5 a 2 OracleGroup Name ID# ValueAAA123 1 50%AAA123 2 55%AAA123 3 60%AAA123 4 80%AAA123 5 70%BBB123 1 35%BBB123 2 45%BBB123 3 50%BBB123 4 50%BBB123 5 80% I need to be able to get this:Group Name Item Condition ValueAAA123 a 1 55%AAA123 a 2 75%AAA123 b 3 60%AAA123 b 4 67.5%BBB123 a 1 40%BBB123 a 2 60% Any idea how I can get the data from these two DBs to talk to each other? Thanks.
View Replies !
SqlServer 2005 &"String Or Binary Data Would Be Truncated&" When Data Is OK
When using AquaData or JDBC (inet tds driver), when doing an insert using SqlServer 2005, I get error "String or binary data would be truncated" when the data is actually OK. There are no triggers, etc. that would confuse the situation. It works fine in SqlServer 2000. The scenario is as follows: Create table: create table test3 ( name varchar (18) , tbname varchar (18) ) Create and populate table: create table maxtable ( tablename varchar (18) not null, [...] ) Try to insert into test3: insert into test3 (name, tbname) select i.name, o.name from dbo.sysindexes i, sysobjects o, maxtable m where i.indid > 0 and i.indid < 255 and i.id = o.id and i.indid = 1 and o.name = lower(m.tablename) And I get the error "String or binary data would be truncated." The values being selected for i.name and o.name have maximum length of 18. There are other rows in sysindexes and sysobjects with longer values, but they are not being selected. The error does not occur with SQL Server Management Studio, and does not occur using SqlServer 2000.
View Replies !
Microsoft.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]
Hi Everybody, On localhost this application works fine but when I put on remote server. I am getting following errors. For both localhost and server, I am using same remote sql 2000. I will appreciate any help. Thanks, Arif Server Error in '/' Application. -------------------------------------------------------------------------------- ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ')'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: Microsoft.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ')'. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ')'.] Microsoft.Data.Odbc.OdbcConnection.HandleError(IntPtr hHandle, SQL_HANDLE hType, RETCODE retcode) +27 Microsoft.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method) +838 Microsoft.Data.Odbc.OdbcCommand.ExecuteNonQuery() +80 Calgary.venues.Page_Load(Object sender, EventArgs e) in c:inetpubwwwrootCalgarySitevenuesvenues.aspx.vb:32 System.Web.UI.Control.OnLoad(EventArgs e) +67 System.Web.UI.Control.LoadRecursive() +35 System.Web.UI.Page.ProcessRequestMain() +731
View Replies !
How To Connect ADODB With Microsoft SQL Server Compact 3.5 (.NET Framework Data Provider For Microsoft SQL Server Compact 3.5)
Hi We are checking VB 9 (Orcas). we connected to database created under with sql server 7. with this code Public cn As New ADODB.Connection Public Sub OpenDB() cn.Open("Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial catalog=Reservation;Data Source=.") End Sub this code worked well. we know sql7 is not compatiable with vista. please tell us how to connect it wiith sql2005 . we downloaded orcas express edition beta. we created a database also. please let u know how to connect with Microsoft SQL Server Compact 3.5 (.NET Framework Data Provider for Microsoft SQL Server Compact 3.5). Rgds Pramod
View Replies !
Need MDX Help (in Microsoft Data Analyzer)
Hi, I'm really frustrated becuase it appears that Microsoft Data Analyzer's support/compatability with "standard" MDX is pathetic :mad: I need to calculate the following but just can't figure out the "~Aspect ... " logic which Data Analyzer uses: 1) I want to create a Year to Date total of Sales. Regardless of the selected time period (whether it's Jan or Nov), I want this YTD total to return the total sales for the selected year 2) I want to calculate the total sales in the previous time period i.e. let me try to explain in detail if the selected time period is Year, this should return the total sales of the Previous Year if the selected period is Qtr1 of a year, this should return the total sales of the previous period i.e. Qtr 4 of the previous year if the selected period is Qtr 2 it should return the total sales for Qtr 1, if the selected period is say Oct of 2004, it should return the total sales of Sep 2004. Can someone PLEASE help me with these. Many & Billions of thanks.
View Replies !
Microsoft Data Engine
MSDE Questions Installation I installed MSDE (which is from Visual Basic 6.0 product package) by using command line prompt, but I can not tell whether it is successfully installed or not except I can see the SQL Server Service Manager from STARTPROGRAMSMSDE. In this case, I already have SQL Server 7.0 desktop (Professional edition) installed on my machine. 1.What is the correct order of installing MSDE and SQL server? If I install MSDE first, how comes the installation of SQL server developer edition get rid of the MSDE installation? 2.What about the shared registry entries between MSDE and SQL server? If I clear the SQL data root and SQL path registry after MSDE but before SQL server installation, I was unable to install SQL server. Do I really need to clear the registry? Interfaces and connection 1.Can I use this SQL server 7,0 desktop (From Professional edition) as MSDE’s interface? How? 2.Which is the best user interface for MSDE? Access or VB? What if customers will use a third-party software as interface, how can they integrate their existing interface with VB or Access, or can they simply use their own user interface instead of VB or Access interface? 3.Can I use ADO, DAO, ODBC and OLEDB connection when I use VB, Access, SQL server developer or third-party application interfaces? How to do the connection when using Access and SQL server? 4.How to correctly install or include SQL.DMO and how to use it with MSDE? 5.When you install MSDE with SQL server developer, can it work on Windows9598 or only on Windows NT? Can MSDE installed with Access work both on Wind9598 and Win NT? Administration 1.As I understand it, it is possible to administer MSDE locally and remotely. How to do it respectively? 2.Is it possible to reduce the administration load to the minimum so that we can let the end-users to do the job themselves, and how (create some administration applications)? Security 1.For the MSDE that is installed on Windows 95/98, there aren’t any security advantages as with Windows NT (Win NT integrated security), are there? 2.What security issues do we need to address if we run MSDE on Windows 95/98?
View Replies !
Need MDX Help (in Microsoft Data Analyzer)
Hi, I'm really frustrated becuase it appears that Microsoft Data Analyzer's support/compatability with "standard" MDX is pathetic :mad: I need to calculate the following but just can't figure out the "~Aspect" logic which Data Analyzer uses :confused: 1) I want to create a Year to Date total of Sales. Regardless of the selected time period (whether it's Jan or Nov), I want this YTD total to return the total sales for the selected year 2) I want to calculate the total sales in the previous time period i.e. let me try to explain in detail if the selected time period is Year, this should return the total sales of the Previous Year if the selected period is Qtr1 of a year, this should return the total sales of the previous period i.e. Qtr 4 of the previous year if the selected period is Qtr 2 it should return the total sales for Qtr 1 if the selected period is say Oct of 2004, it should return the total sales of Sep 2004 Can someone PLEASE help me with these. Many & Billions of thanks.
View Replies !
How Do I Get My Data Into SqlServer?
I have a development machine that I have prototyped with access. I don't know how to get the access data into Sql Server on the Internet. Can you help me? I'm not sure where to start. Thank you for any help.
View Replies !
Asp.Net And SqlServer Data
Hi can anybody tell me that: 1)How can i retrieve a binary field (image field) that stored in SqlServer2000 with Vb.Net and save it again in my hard disk that i have again that file? 2)can SqlServer itself convert image field to file with its store procedures? 3)can sqlserver run an exe file on local computer from its storeprocedure? Best Regards
View Replies !
Microsoft.Data.Odbc On 64-Bit Server
Hi! Today we installed our ASP.NET Application on a 64-bit server for the first time. We got the error 'Unable to find entry point named 'InterlockedIncrement' in DLL 'kernel32.dll''. This error comes when we make a database query using Microsoft.Data.Odbc. I think it does not run on 64-bit machines. Does anybody know something about this? KaaN
View Replies !
Microsoft Data Link Error
Hi all, Im having problems accessing my MSDE database through server explorer in Visual Studio 2003. Last week it was working fine and I could see my databases no problem but for some reason something seems to have changed and when trying to access them i get this error: I get Microsoft Data LInk Error - [DBNetLib][ConnectionOpen (Connect()). ] SQL Server does not exist or access denied. I've had a look using Enterprise Manager and I can get in the database fine using that. Its set to windows NT authentication and I have even added ASPNET in security>logins. Any ideas what might have happened to be stopping me have access to my database??? many thanks Tom
View Replies !
Import Data From Microsoft Access
Why everytime i insert data from MS-Access, all the Memo Type will change to ntext in MS-SQL. if i have about 60 coloumn in my table, izzit i need to change it one by one?? Is there anyway to change it once? I had a another table which have same coloumn data with it. Can anyone tell me how should i do to make it easier?? Thanks
View Replies !
Data Storage In Microsoft SQL 2000
To Whom It May Concern: I am currently using Spring 1.25, Velocity 1.4, Weblogic 7 sp7 and Sql 2000. I created an ecard program which allow the user to type in the following message: Hi Frances: Testing. Yours, John But for some reason when it save in Microsoft SQL 2000 it took out the enter signs. I did press "enter" after each paragraph but when I displayed the stored text from Microsoft SQL 2000 I get the following: When I retrieve the value from the field in Microsoft SQL 2000 I get the following: Hi Frances: Testing. Yours, John I was wondering is there something I can such as in java find the hidden enter tags and replaced them with "" when storing in the database. Or is this solution not feasible or is there a better solution? Yours, Gratefull
View Replies !
Microsoft Data Link Error
A test installation script I ran on my dev rig seems to have broken the OLE DB Provider for Sql Server. The uninstall must have deleted a DLL or unregistered a lib. When I try to connect to a SQL database from this machine now get the following error: == Microsoft Data Link Error Test connection failed because of an error in initializing provider. Unspecified error. == It is not the connection string because this was working fine prior to me running the test installation script. Can you give advice on how to repair the SQL Server data provider for WinXP SP2? I have tried to re-install MDAC 2.8 with no success due SP2 diallowing this. I uninstalled SP2 and re-installed MDAC 2.8 but the problem remains. I'm all out of ideas, so any help would be appreciated. Thanks!
View Replies !
Error: The Task With The Name &&"Data Flow Task&&" And The Creation Name &&"DTS.Pipeline.1&&" Is Not Registered For Use On This Computer
Hi, I am trying to create a simple BI Application for SSIS. In Visual Studio 2005 I just get a Data Flow Task from the toolbar and add it to the project. When I double click it I get the following error: The task with the name "Data Flow Task" and the creation name "DTS.Pipeline.1" is not registered for use on this computer. Then when I try to delete it it gives this other error: Cannot remove the specified item because it was not found in the specified Collection. I am creating this application in an administrator account in this computer, so I doubt the problem is related to permissions. I am running SQL Server 2005 and Visual Studio 2005 in WinXP Tablet PC Edition. Any suggestions why this is happening and how to fix it?
View Replies !
Copying Data From Microsoft Access To SQL Server
Hello I am developing a web application that will allow users to upload a .mdb file and from that file I need to populate an SQL database. I know the table name of the .mdb file, but I am unclear how to structure my data access layer correctly. How do I pull data from the .mdb file and once I have it how do i populate the SQL database?Any advice would be greatly appreciated.thanks!
View Replies !
Microsoft.Practices.EnterpriseLibrary.Data Error
The website works perfectly when debugged or deployed, but it fails to work when NUnit is involved. It seems when NUnit is ran alongside and invokes my test function to call my DataBase Class, it does not read the app.config file where the connection string. Any solutions? Stack Trace: at Microsoft.Practices.EnterpriseLibrary.Data.DatabaseConfigurationView.ValidateConnectionStringSettings(String name, ConnectionStringSettings connectionStringSettings) at Microsoft.Practices.EnterpriseLibrary.Data.DatabaseConfigurationView.GetConnectionStringSettings(String name) at Microsoft.Practices.EnterpriseLibrary.Data.DatabaseCustomFactory.CreateObject(IBuilderContext context, String name, IConfigurationSource configurationSource, ConfigurationReflectionCache reflectionCache) at Microsoft.Practices.EnterpriseLibrary.Common.Configuration.ObjectBuilder.ConfiguredObjectStrategy.BuildUp(IBuilderContext context, Type t, Object existing, String id) at Microsoft.Practices.ObjectBuilder.BuilderStrategy.BuildUp(IBuilderContext context, Type typeToBuild, Object existing, String idToBuild) at Microsoft.Practices.ObjectBuilder.SingletonStrategy.BuildUp(IBuilderContext context, Type typeToBuild, Object existing, String idToBuild) at Microsoft.Practices.ObjectBuilder.BuilderStrategy.BuildUp(IBuilderContext context, Type typeToBuild, Object existing, String idToBuild) at Microsoft.Practices.EnterpriseLibrary.Common.Configuration.ObjectBuilder.ConfigurationNameMappingStrategy.BuildUp(IBuilderContext context, Type t, Object existing, String id) at Microsoft.Practices.ObjectBuilder.BuilderBase`1.DoBuildUp(IReadWriteLocator locator, Type typeToBuild, String idToBuild, Object existing, PolicyList[] transientPolicies) at Microsoft.Practices.ObjectBuilder.BuilderBase`1.BuildUp(IReadWriteLocator locator, Type typeToBuild, String idToBuild, Object existing, PolicyList[] transientPolicies) at Microsoft.Practices.ObjectBuilder.BuilderBase`1.BuildUp[TTypeToBuild](IReadWriteLocator locator, String idToBuild, Object existing, PolicyList[] transientPolicies) at Microsoft.Practices.EnterpriseLibrary.Common.Configuration.ObjectBuilder.EnterpriseLibraryFactory.BuildUp[T](IReadWriteLocator locator, String id, IConfigurationSource configurationSource) at Microsoft.Practices.EnterpriseLibrary.Common.Configuration.ObjectBuilder.EnterpriseLibraryFactory.BuildUp[T](String id, IConfigurationSource configurationSource) at Microsoft.Practices.EnterpriseLibrary.Common.Configuration.ObjectBuilder.NameTypeFactoryBase`1.Create(String name) at Microsoft.Practices.EnterpriseLibrary.Data.DatabaseFactory.CreateDatabase(String name) Thanks :)
View Replies !
Can't Login To Microsoft SQL Web Data Administrator With Sql Option
i have installed MSDE 2000 and Microsoft SQL Web Data Administrator. at first i login using Windows Integrated option and created an account for sql login. but when i tried to login using newly created account i get the following error. Invalid username and/or password, you are using a windows login that is not your own, or server does not exist. i am using XP SP2.
View Replies !
Microsoft.Data.SqlXml.SqlXmlCommand In Asp.net 2.0 Web Application
Hi guys, I met a problem when I use Microsoft.Data.SqlXml.SqlXmlCommand in asp.net 2.0 web application. The following is the code: using Microsoft.Data.SqlXml; public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { ConnectionStringsSection secConn = (ConnectionStringsSection)ConfigurationManager.GetSection("connectionStrings"); string strConn = secConn.ConnectionStrings["sqlXmlConn"].ToString(); try { SqlXmlCommand cmd = new SqlXmlCommand(strConn); <-- error occurs here } catch (Exception ex) { } } } If <trust level="Full" originUrl="" /> is set in web.config of machine, the code works fine. if <trust level="Medium" originUrl="" /> is set in web.config of machine, there is an exception as following: Server Error in '/' Application. Security Exception Description: The application attempted to perform an operation not allowed by the security policy. To grant this application the required permission please contact your system administrator or change the application's trust level in the configuration file. Exception Details: System.Security.SecurityException: That assembly does not allow partially trusted callers. Is there somebody met same problem?
View Replies !
Saving Data Into SQLServer
Hi, Here is a structure of my table create table events( event_id integer primary key identity(1,1), event_name varchar(200), event_date datetime,) Note: The event_id is a automacally and we don't need to insert record in this field. for example i have inserted 10 records in a table then i deleted all records manually from sql server but when again I save the record the event_id field shows started from 11 even the table was empty, although it should be start from 1?
View Replies !
About Accessing Data From Sqlserver
Hello sir,I have installed .net1.1version on windows2003 operating system.I have also installed sqlserver2000 on the same system.My problem is that when i am trying to get data from sqlserver from asp.net program i am getting error as 'access denied to user NT AUTHORITY/NETWORK USER'.I request you to kindly suggest me with an appropriate solution.Thanking you.Please email me on:-aanandkumar786@yahoo.com
View Replies !
Regarding Sqlserver Data Fetching
Hi bubies, i have the table like S.no username name parent_username 1 Jess Sajan 2 Muthu Kumar Jess 3 Ramya Test Muthu 4 Ahis Test1 Ramya 5 Vino Yuan 6 Kumar test3 Vino 7 Diyana Test87 Kumar here Jess is the parent of the Kumar and also Muthu is the parent of the Test .. i want parent name of the Test1 ...How can write the query for that..please help me.. o/p S.no username name parent_username 1 Jess Sajan 2 Muthu Kumar Jess 3 Ramya Test Muthu Thanks & Regards, S.Sajan
View Replies !
Import Data To Sqlserver
Hi, How to expor data from Filemaker to Sqlserver? From the Filemaker, I am exporting data into Tab File(values are separated by tab). How to put data from that file into Sqlserver tables? Thanks
View Replies !
How Do I Write Multiple Pipeline Buffer To Multiple Targets Based On A Calculated Value In The Pipeline Buffer
The scenario is as follows: I have a source with many rows. Each row has a column called max_qty_value. I need to perform a calculation using another column called qty. This calculation is something similar to dividing qty/(ceiling) max_qty_value. Once I have that number I need to write an additional duplicate row for each value from the prior calculation performed. For example, 15/4 = 4. I need to write 4 rows to the same target table as in line information for a purchase order. The multicast transform appears to only support fixed and/or predetermined outputs. How do I design this logic in SSIS to write out dynamic number of rows to a target table. Any ideas would be greatly appreciated. thanks John
View Replies !
|
TRACKER
