DTS Error (connection Is Busy With Results For Another Command/Log File Is Being Used

Oct 2, 2002

Hi,

I created a DTS package to populate no of tables from text files.

I created more database connetion and spreaded among the tables to load parrelly. I have specified an exception file for logging errors.

I am getting the following errors while executing the package.

connection is busy with results for another command
Cannot open file. Log file is being used by another progroram.

Any help please?

Thanks
John Jayaseelan

View 1 Replies

Error Connection Is Busy With Results For Another Command

May 18, 2007

I have looked at other threads regarding errors similar to this, but I think mine is a bit different.

I am using SQL2005 Standard Edition and my application is coded with C# using ADO.Net. OLEDB connection is used. The error occurs when the application has only one thread accessing the database. It does not happen consistently, so it is very puzzling.

I am wondering if anyone could offer any tip to diagnose this.

Thanks in advance!

View 1 Replies View Related

Connection Is Busy With Results For Another Command

Aug 31, 2007

We are migrating our databases from MS Access to SQL Server 2005 and using the SQL Native Client ODBC driver.

We also use a reporting tool called Actuate. Some of our Actuate reports use multiple datastreams to build the report.

When I run an Actuate report having multiple datastreams I get the following error message from SQL Server:

Error generated by the connected data source. Connection is busy with results for another command.

Is there a configuration setting in SQL Server to enable processing of multiple result sets?

Thanks.

View 6 Replies View Related

Connection Busy With Results For Another Hstmt...

Jan 31, 2006

Hi mates,

I am getting this strange error while working on SQL server through JDBC.
I am using a connection-pooling mechanism. Have written my own connection pool. The pool holds a number of connections and has methods for requesting and returning connections from the clients. The issue is - when I get a connection from the pool and execute a select query, it works fine. Then I return the connection to the pool (at the top). On next request for connection, this same connection object is provided. When another select query is fired on this connection, I get an error - "connection is busy with results for another hstmt"... The error occurs at the time of executing the query and not while obtaining the statement object from the connection object.
If I don't use the connection pool and create new connection every time, everything works fine (except the performance!)...
I'll be grateful if anyone can shed some light on this.....
Cheers!

View 1 Replies View Related

Connection Is Busy With Results For Another Hstmt

Oct 11, 2007

Hi,
When i tried to retreive Datas from Sql Server continously(connection pooling), I got an Exception like "java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt". After restarting the Tomcat server, it starts to work fine.I don know what is happening behind the screen. Let me know the nature of this Exception and the Solution to this kind of Exception.. Plz as soon as possible..

View 1 Replies View Related

Connection Is Busy With Results For Another Hstmt

Sep 22, 2006

HI guys,

I'm using ODBC driver from WinXP SP2 with SQL Server 2005 Express (on my machine for test) and SQL Server 2005 Standard (on the production machine).

With SQL Server 2005 Express I've no problem, but with SQL Server 2005 Standard, in some query, I get "Connection is busy with results for another hstmt".

I'm working with VisualStudio 2003 with standard CDatabase and CRecordSet MFC classes.

I looked for an advice in the Microsoft KB but I found only Service Pack for SQL Server 2000 !

Everything could be useful !

Thanks a lot!

Bye, Domenico

View 5 Replies View Related

Connection Is Busy With Results For Another Hstmt

May 3, 2008

Hi
I am using SQL server 2000 and vb.net 2003. We have used threads in our application.
Our application is running well but Sometimes we get the error message "connection is busy with results for another hstmt"
We are using adodb connection to open recordsets.

How to resolve this problem?

View 1 Replies View Related

Connection Is Busy With Results For Another Hstmt && Win2003 SP1

Jul 23, 2005

I wrote a web app using an ASP front end (not .NET) connecting to a SQLServer 2000 (no SP) back end. Both the web server and the databaseserver are Windows 2003 boxes. The app was running fine two weeks agobefore I went on vacation. While I was gone my net admin appliedWindows 2003 SP1 to the web server. Upon my return I was informed thatthe app is no longer working, getting the following error:[Microsoft][ODBC SQL Server Driver]Connection is busy with results foranother hstmtSince that is presumably the only thing that changed in my absence Ibelieve the SP somehow messed up the way the ODBC was working. I triedmoving the SQL Server database to a different Windows 2003 box whichalso received the SP1 update and also includes SP3 for SQL Server, butget the same error.I am hitting the database like so:set GetData = CreateObject("ADODB.Command")GetData.ActiveConnection = SQLConnGetData.CommandText = "<stored procedure call>"Set DataRS= GetData.Execute (,,adCmdText)I appear to get the error when I execute the second call. I amlearning ASP as I go, so maybe this is a trivial problem.

View 2 Replies View Related

[Microsoft][ODBC SQL Server Driver]Connection Is Busy With Results For Another Hstmt.

May 10, 2007

Our program report the error like this:

[Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt.

I used VC++ and ADO.

How does this error happen?

How can I fix it?

Does this can be caused by mutil-thread?

We use the SqlServer 2005.

Thanks

View 4 Replies View Related

[Microsoft][ODBC SQL Server Driver]Connection Is Busy With Results For Another Hstmt???

May 9, 2007

Our program report the error like this:

[Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt.

How does this error happen?

How can I fix it?

We use the SqlServer 2005.

Thanks

View 6 Replies View Related

Error: Connection Is Busy

Jun 14, 2007

Error: 0xC0202009 at Load SQL Deals, Insert SQL Deals [12494]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Connection is busy with results for another command".

Why isn't the connection manager managing this?

How can I trace the cause? The data flow component (insert SQL deals) is just a simple INSERT statment.

View 1 Replies View Related

ODBC Connection Busy Error

Jul 20, 2005

I am having multiple threads in my c program to execute same procedurewith differnt parameter values every time.I have created different functions to execute the same.However when SQLExecute is run on one of the thread it returns anerror saying[Microsoft][ODBC SQL Server Driver]Connection is busy with results foranother hstmtHow do I call the same stored procedure on different threads toexecute at the same time.

View 2 Replies View Related

URGENT: The Command Failed Because The Database Mirror Is Busy!

Mar 30, 2007

Hi,

Mirroring has been working fine on 2 identical servers. We even tested failover and that worked....but today something happened (still investigating) and suddenly the Principal is disconnected and we cannot force failover with:

ALTER DATABASE [LeoCTI] SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS

Error: The command failed because the database mirror is busy! Try again later!

How can I bring the principal back online? It won't let me do anything, won't let me turn off mirroring etc. etc.

HELP PLEASE!

Thanks

Hyper aka Richard

View 2 Replies View Related

A Severe Error Occurred On The Current Command. The Results, If Any, Should Be Ignored

Feb 1, 2008

I got the above error executing a stored procedure from .Net app and I isolated the issue on the following sql statement inside the sp. I executed the statement manually inside the MSSQL Mgt Studio and got the same error as above. Here is the sql statement:
SELECT F1,F2,F3,F4,F5,F6,F7,F8,F9,F10,F11,F12,F13,F14,F15,F16,F17,F18,F19,F20,F21,F22,F23,F24,F25,F26,F27,F28,F29 from OpenRowset('MSDASQL', 'Driver={Microsoft Text Driver (*.txt; *.csv)};DefaultDir=E:\TPSDATA\az\;','select * from prohist.csv where f1 < 0 ')

the data file exists in the directory 'E: psdataazprohist.csv' . I'm running on SQL2005 version 9.00.3054.00. Any ideas what the problem is? Appreciate any feedback

View 4 Replies View Related

A Severe Error Occurred On The Current Command. The Results, If Any, Should Be Discarded.

Aug 27, 2002

Hi,

I am hosting my ASP.NET application on a Host and after some time I get this error
(Don't get it on my development machine):

A severe error occurred on the current command. The results, if any, should be discarded.

And then it says this on the same page:

Exception Details: System.Data.SqlClient.SqlException: A severe error occurred on the current command. The results, if any, should be discarded.

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.

[SqlException: A severe error occurred on the current command. The results, if any, should be discarded.]
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +643
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) +9
ASPNetPortal.PortalSettings..ctor(Int32 tabIndex, Int32 tabId)
ASPNetPortal.Global.Application_BeginRequest(Object sender, EventArgs e)
System.Web.SyncEventExecutionStep.Execute() +60
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

I thought this is a problem with max pool size and I did it max pool size = 5000, now application runs ok for some time and then produces this error but some times this comes very soon.

As a solution, I have to copy my dll in bin directory again and application restarts and works properly but then after some time this happenes again.

Please let me know whats the problem.
I checked all of my SqlDataReaders and SqlConnections are closed properly.

Any help would be appreciated.

Thanks.

Rahul.

View 8 Replies View Related

A Severe Error Occurred On The Current Command. The Results, If Any, Should Be Discarded

Feb 26, 2008

Hi all. I am running on SQL 2005 Standard eddition SP2, Also did install " KB Article Number(s): 944929, 946608, 948490, 949118". Running on 2003 server.

Error:
Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.
Msg 0, Level 20, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.

I have 2 servers. One of them is free text seach with files stored in DB. On main server there is a link back to this file DB server.

I am trying to run this script and then error from above... link_kance_doc is link to table on other server. Strange thing is when I run this same script on server 3 with same link to file DB server it works. It also works when runed on file DB server.
Also, if I dont use WHERE CONTRAINS SQL does return Dataset..

SELECT link_kance_doc.ID, link_kance_doc.DocName, link_kance_doc.DocExtension, link_kance_doc.KancelID, link_kance_doc.Comments,
link_kance_doc.CreateByUser, link_kance_doc.CreateTS, link_kance_doc.ActiveYN
FROM link_kance_doc
where Contains(*,'"murte"')

Any ideas..

Server LOG

02/26/2008 16:54:05,Server,Unknown,A user request from the session with SPID 57 generated a fatal exception. SQL Server is terminating this session. Contact Product Support Services with the dump produced in the log directory.
02/26/2008 16:54:05,Server,Unknown,Error: 17310<c/> Severity: 20<c/> State: 1.
02/26/2008 16:54:05,spid57,Unknown,External dump process return code 0x20000001.<nl/>External dump process returned no errors.
02/26/2008 16:54:04,spid57,Unknown,Stack Signature for the dump is 0x28BDEE59
02/26/2008 16:54:04,spid57,Unknown,78132A47 Module(MSVCR80+00002A47)
02/26/2008 16:54:04,spid57,Unknown,781329BB Module(MSVCR80+000029BB)
02/26/2008 16:54:04,spid57,Unknown,010B9201 Module(sqlservr+000B9201)
02/26/2008 16:54:04,spid57,Unknown,010B9064 Module(sqlservr+000B9064)
02/26/2008 16:54:04,spid57,Unknown,010B939C Module(sqlservr+000B939C)
02/26/2008 16:54:04,spid57,Unknown,010B94A5 Module(sqlservr+000B94A5)
02/26/2008 16:54:04,spid57,Unknown,010075DC Module(sqlservr+000075DC)
02/26/2008 16:54:04,spid57,Unknown,010078CC Module(sqlservr+000078CC)
02/26/2008 16:54:04,spid57,Unknown,010077A6 Module(sqlservr+000077A6)
02/26/2008 16:54:04,spid57,Unknown,0102F1F4 Module(sqlservr+0002F1F4)
02/26/2008 16:54:04,spid57,Unknown,01032A36 Module(sqlservr+00032A36)
02/26/2008 16:54:04,spid57,Unknown,01028600 Module(sqlservr+00028600)
02/26/2008 16:54:04,spid57,Unknown,0134752A Module(sqlservr+0034752A)
02/26/2008 16:54:04,spid57,Unknown,01430633 Module(sqlservr+00430633)
02/26/2008 16:54:04,spid57,Unknown,01346B6B Module(sqlservr+00346B6B)
02/26/2008 16:54:04,spid57,Unknown,013A929A Module(sqlservr+003A929A)
02/26/2008 16:54:04,spid57,Unknown,01368BB2 Module(sqlservr+00368BB2)
02/26/2008 16:54:04,spid57,Unknown,013A9BDC Module(sqlservr+003A9BDC)
02/26/2008 16:54:04,spid57,Unknown,013A9A04 Module(sqlservr+003A9A04)
02/26/2008 16:54:04,spid57,Unknown,013AFC6E Module(sqlservr+003AFC6E)
02/26/2008 16:54:04,spid57,Unknown,013A9A04 Module(sqlservr+003A9A04)
02/26/2008 16:54:04,spid57,Unknown,013AF8D0 Module(sqlservr+003AF8D0)
02/26/2008 16:54:04,spid57,Unknown,013A9A04 Module(sqlservr+003A9A04)
02/26/2008 16:54:04,spid57,Unknown,013B0CC7 Module(sqlservr+003B0CC7)
02/26/2008 16:54:04,spid57,Unknown,013A9A04 Module(sqlservr+003A9A04)
02/26/2008 16:54:04,spid57,Unknown,013A9DC5 Module(sqlservr+003A9DC5)
02/26/2008 16:54:04,spid57,Unknown,013A9F20 Module(sqlservr+003A9F20)
02/26/2008 16:54:04,spid57,Unknown,01B2E1B9 Module(sqlservr+00B2E1B9)
02/26/2008 16:54:04,spid57,Unknown,013A9A04 Module(sqlservr+003A9A04)
02/26/2008 16:54:04,spid57,Unknown,01B24372 Module(sqlservr+00B24372)
02/26/2008 16:54:04,spid57,Unknown,0136A2D8 Module(sqlservr+0036A2D8)
02/26/2008 16:54:04,spid57,Unknown,0149C867 Module(sqlservr+0049C867)
02/26/2008 16:54:04,spid57,Unknown,0170D0CD Module(sqlservr+0070D0CD)
02/26/2008 16:54:04,spid57,Unknown,0170F7E3 Module(sqlservr+0070F7E3)
02/26/2008 16:54:04,spid57,Unknown,0170FB90 Module(sqlservr+0070FB90)
02/26/2008 16:54:04,spid57,Unknown,01702514 Module(sqlservr+00702514)
02/26/2008 16:54:04,spid57,Unknown,010A0F91 Module(sqlservr+000A0F91)
02/26/2008 16:54:04,spid57,Unknown,* Short Stack Dump
02/26/2008 16:54:04,spid57,Unknown,* -------------------------------------------------------------------------------
02/26/2008 16:54:04,spid57,Unknown,* *******************************************************************************
02/26/2008 16:54:04,spid57,Unknown,* SegSs: 00000023:
02/26/2008 16:54:04,spid57,Unknown,* Esp: 6373E24C: 00000004 00000000 6373E544 01702514 00000004 01019094
02/26/2008 16:54:04,spid57,Unknown,* EFlags: 00010206: 0055004E 0042004D 00520045 004F005F 005F0046 00520050
02/26/2008 16:54:04,spid57,Unknown,* SegCs: 0000001B:
02/26/2008 16:54:04,spid57,Unknown,* Ebp: 6373E254: 6373E544 01702514 00000004 01019094 637311EB 042DAD88
02/26/2008 16:54:04,spid57,Unknown,* Eip: 010A0F91: 103B118B B60FCD74 38B60F11 840FD72B 003D5E1C 01B8D285
02/26/2008 16:54:04,spid57,Unknown,* Edx: 042DAD48: 042DAAB8 042DA278 042DAA18 042DAD70 042DAF58 00000001
02/26/2008 16:54:04,spid57,Unknown,* Ecx: 00000004:
02/26/2008 16:54:04,spid57,Unknown,* Ebx: 05E929F8: 01622A98 00000001 00000000 00000000 00000000 00000000
02/26/2008 16:54:04,spid57,Unknown,* Eax: 01019094: 00000000 00000000 00000000 00000000 90909090 55FF8B90
02/26/2008 16:54:04,spid57,Unknown,* Esi: 00000010:
02/26/2008 16:54:04,spid57,Unknown,* Edi: 00000004:
02/26/2008 16:54:04,spid57,Unknown,*
02/26/2008 16:54:04,spid57,Unknown,* dbghelp 64600000 64714FFF 00115000
02/26/2008 16:54:04,spid57,Unknown,* MSDATL3 64450000 64464FFF 00015000
02/26/2008 16:54:04,spid57,Unknown,* sqloledb 643C0000 64440FFF 00081000
02/26/2008 16:54:04,spid57,Unknown,* xpstar90 64390000 643B5FFF 00026000
02/26/2008 16:54:04,spid57,Unknown,* msadcer 64380000 64384FFF 00005000
02/26/2008 16:54:04,spid57,Unknown,* msadce 64320000 64377FFF 00058000
02/26/2008 16:54:04,spid57,Unknown,* OLEDB32R 64300000 64310FFF 00011000
02/26/2008 16:54:04,spid57,Unknown,* MSDART 64060000 64079FFF 0001a000
02/26/2008 16:54:04,spid57,Unknown,* oledb32 63FE0000 64058FFF 00079000
02/26/2008 16:54:04,spid57,Unknown,* odbcint 63FC0000 63FD6FFF 00017000
02/26/2008 16:54:04,spid57,Unknown,* ATL80 7C630000 7C64AFFF 0001b000
02/26/2008 16:54:04,spid57,Unknown,* BatchParser90 63E50000 63E6EFFF 0001f000
02/26/2008 16:54:04,spid57,Unknown,* ODBC32 63E10000 63E4CFFF 0003d000
02/26/2008 16:54:04,spid57,Unknown,* SQLSCM90 63DF0000 63DF8FFF 00009000
02/26/2008 16:54:04,spid57,Unknown,* xpstar90 63D90000 63DD8FFF 00049000
02/26/2008 16:54:04,spid57,Unknown,* msftepxy 63600000 63614FFF 00015000
02/26/2008 16:54:04,spid57,Unknown,* SQLNCLIR 00830000 00862FFF 00033000
02/26/2008 16:54:04,spid57,Unknown,* comdlg32 762B0000 762F8FFF 00049000
02/26/2008 16:54:04,spid57,Unknown,* COMCTL32 77530000 775C6FFF 00097000
02/26/2008 16:54:04,spid57,Unknown,* sqlncli 631D0000 633F3FFF 00224000
02/26/2008 16:54:04,spid57,Unknown,* CLBCatQ 777B0000 77832FFF 00083000
02/26/2008 16:54:04,spid57,Unknown,* xpsp2res 62F00000 631C4FFF 002c5000
02/26/2008 16:54:04,spid57,Unknown,* ntdsapi 766F0000 76703FFF 00014000
02/26/2008 16:54:04,spid57,Unknown,* SAMLIB 7E020000 7E02EFFF 0000f000
02/26/2008 16:54:04,spid57,Unknown,* NTMARTA 77E00000 77E20FFF 00021000
02/26/2008 16:54:04,spid57,Unknown,* wshtcpip 71AE0000 71AE7FFF 00008000
02/26/2008 16:54:04,spid57,Unknown,* hnetcfg 62E60000 62EB9FFF 0005a000
02/26/2008 16:54:04,spid57,Unknown,* dssenh 68100000 68126FFF 00027000
02/26/2008 16:54:04,spid57,Unknown,* imagehlp 76C10000 76C37FFF 00028000
02/26/2008 16:54:04,spid57,Unknown,* WINTRUST 76BB0000 76BDAFFF 0002b000
02/26/2008 16:54:04,spid57,Unknown,* dbghelp 62B00000 62C14FFF 00115000
02/26/2008 16:54:04,spid57,Unknown,* msfte 628A0000 62AF8FFF 00259000
02/26/2008 16:54:04,spid57,Unknown,* security 62210000 62213FFF 00004000
02/26/2008 16:54:04,spid57,Unknown,* rasadhlp 76F80000 76F84FFF 00005000
02/26/2008 16:54:04,spid57,Unknown,* WLDAP32 76F10000 76F3DFFF 0002e000
02/26/2008 16:54:04,spid57,Unknown,* winrnr 76F70000 76F76FFF 00007000
02/26/2008 16:54:04,spid57,Unknown,* DNSAPI 76ED0000 76EF9FFF 0002a000
02/26/2008 16:54:04,spid57,Unknown,* RESUTILS 61DC0000 61DD2FFF 00013000
02/26/2008 16:54:04,spid57,Unknown,* CLUSAPI 61DA0000 61DB1FFF 00012000
02/26/2008 16:54:04,spid57,Unknown,* WSOCK32 71BB0000 71BB8FFF 00009000
02/26/2008 16:54:04,spid57,Unknown,* VERSION 77B90000 77B97FFF 00008000
02/26/2008 16:54:04,spid57,Unknown,* MTXCLU 61D80000 61D98FFF 00019000
02/26/2008 16:54:04,spid57,Unknown,* msvcp60 61D10000 61D74FFF 00065000
02/26/2008 16:54:04,spid57,Unknown,* OLEAUT32 77D00000 77D8AFFF 0008b000
02/26/2008 16:54:04,spid57,Unknown,* MSDTCPRX 61C90000 61D08FFF 00079000
02/26/2008 16:54:04,spid57,Unknown,* XOLEHLP 61C80000 61C85FFF 00006000
02/26/2008 16:54:04,spid57,Unknown,* COMRES 77010000 770D5FFF 000c6000
02/26/2008 16:54:04,spid57,Unknown,* schannel 76750000 76776FFF 00027000
02/26/2008 16:54:04,spid57,Unknown,* cryptdll 766E0000 766EBFFF 0000c000
02/26/2008 16:54:04,spid57,Unknown,* kerberos 61BD0000 61C27FFF 00058000
02/26/2008 16:54:04,spid57,Unknown,* iphlpapi 76CF0000 76D09FFF 0001a000
02/26/2008 16:54:04,spid57,Unknown,* msv1_0 76C90000 76CB6FFF 00027000
02/26/2008 16:54:04,spid57,Unknown,* ole32 77670000 777A8FFF 00139000
02/26/2008 16:54:04,spid57,Unknown,* MSCOREE 34190000 341D4FFF 00045000
02/26/2008 16:54:04,spid57,Unknown,* AUTHZ 76C40000 76C53FFF 00014000
02/26/2008 16:54:04,spid57,Unknown,* rsaenh 68000000 68034FFF 00035000
02/26/2008 16:54:04,spid57,Unknown,* SQLOS 344D0000 344D4FFF 00005000
02/26/2008 16:54:04,spid57,Unknown,* sqlevn70 4F610000 4F7B8FFF 001a9000
02/26/2008 16:54:04,spid57,Unknown,* instapi 48060000 48069FFF 0000a000
02/26/2008 16:54:04,spid57,Unknown,* psapi 76B70000 76B7AFFF 0000b000
02/26/2008 16:54:04,spid57,Unknown,* comctl32 77420000 77522FFF 00103000
02/26/2008 16:54:04,spid57,Unknown,* IMM32 76290000 762ACFFF 0001d000
02/26/2008 16:54:04,spid57,Unknown,* SHLWAPI 77DA0000 77DF1FFF 00052000
02/26/2008 16:54:04,spid57,Unknown,* SHELL32 7C8D0000 7D0CEFFF 007ff000
02/26/2008 16:54:04,spid57,Unknown,* NETAPI32 71C40000 71C96FFF 00057000
02/26/2008 16:54:04,spid57,Unknown,* opends60 333E0000 333E6FFF 00007000
02/26/2008 16:54:04,spid57,Unknown,* USERENV 76920000 769E1FFF 000c2000
02/26/2008 16:54:04,spid57,Unknown,* WS2HELP 71BF0000 71BF7FFF 00008000
02/26/2008 16:54:04,spid57,Unknown,* WS2_32 71C00000 71C16FFF 00017000
02/26/2008 16:54:04,spid57,Unknown,* MSWSOCK 71B20000 71B60FFF 00041000
02/26/2008 16:54:04,spid57,Unknown,* MSASN1 76190000 761A1FFF 00012000
02/26/2008 16:54:04,spid57,Unknown,* CRYPT32 761B0000 76242FFF 00093000
02/26/2008 16:54:04,spid57,Unknown,* GDI32 77C00000 77C47FFF 00048000
02/26/2008 16:54:04,spid57,Unknown,* USER32 77380000 77410FFF 00091000
02/26/2008 16:54:04,spid57,Unknown,* Secur32 76F50000 76F62FFF 00013000
02/26/2008 16:54:04,spid57,Unknown,* RPCRT4 77C50000 77CEEFFF 0009f000
02/26/2008 16:54:04,spid57,Unknown,* ADVAPI32 77F50000 77FEAFFF 0009b000
02/26/2008 16:54:04,spid57,Unknown,* MSVCP80 7C420000 7C4A6FFF 00087000
02/26/2008 16:54:04,spid57,Unknown,* msvcrt 77BA0000 77BF9FFF 0005a000
02/26/2008 16:54:04,spid57,Unknown,* MSVCR80 78130000 781CAFFF 0009b000
02/26/2008 16:54:04,spid57,Unknown,* kernel32 77E40000 77F41FFF 00102000
02/26/2008 16:54:04,spid57,Unknown,* ntdll 7C800000 7C8BFFFF 000c0000
02/26/2008 16:54:04,spid57,Unknown,* sqlservr 01000000 02C09FFF 01c0a000
02/26/2008 16:54:04,spid57,Unknown,* MODULE BASE END SIZE
02/26/2008 16:54:04,spid57,Unknown,*
02/26/2008 16:54:04,spid57,Unknown,*
02/26/2008 16:54:04,spid57,Unknown,* ins(*<c/>'"murte"')
02/26/2008 16:54:04,spid57,Unknown,* teTS<c/> link_kance_doc.ActiveYN FROM link_kance_doc where Conta
02/26/2008 16:54:04,spid57,Unknown,* link_kance_doc.CreateByUser<c/> link_kance_doc.Crea
02/26/2008 16:54:04,spid57,Unknown,* nce_doc.DocExtension<c/> link_kance_doc.KancelID<c/> link_kance_doc.Comments<c/>
02/26/2008 16:54:04,spid57,Unknown,* SELECT link_kance_doc.ID<c/> link_kance_doc.DocName<c/> link_ka
02/26/2008 16:54:04,spid57,Unknown,* Input Buffer 510 bytes -
02/26/2008 16:54:04,spid57,Unknown,* Access Violation occurred reading address 00000004
02/26/2008 16:54:04,spid57,Unknown,* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
02/26/2008 16:54:04,spid57,Unknown,* Exception Address = 010A0F91 Module(sqlservr+000A0F91)
02/26/2008 16:54:04,spid57,Unknown,*
02/26/2008 16:54:04,spid57,Unknown,*
02/26/2008 16:54:04,spid57,Unknown,* 02/26/08 16:54:04 spid 57
02/26/2008 16:54:04,spid57,Unknown,* BEGIN STACK DUMP:
02/26/2008 16:54:04,spid57,Unknown,*
02/26/2008 16:54:04,spid57,Unknown,* *******************************************************************************
02/26/2008 16:54:04,spid57,Unknown,SqlDumpExceptionHandler: Process 57 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
02/26/2008 16:54:04,spid57,Unknown,***Stack Dump being sent to C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGSQLDump0063.txt
02/26/2008 16:54:04,spid57,Unknown,Using 'dbghelp.dll' version '4.0.5'
02/26/2008 16:54:03,Server,Unknown,A user request from the session with SPID 57 generated a fatal exception. SQL Server is terminating this session. Contact Product Support Services with the dump produced in the log directory.
02/26/2008 16:54:03,Server,Unknown,Error: 17310<c/> Severity: 20<c/> State: 1.
02/26/2008 16:54:03,spid57,Unknown,External dump process return code 0x20000001.<nl/>External dump process returned no errors.
02/26/2008 16:54:02,spid57,Unknown,Stack Signature for the dump is 0x28BDEE59
02/26/2008 16:54:02,spid57,Unknown,78132A47 Module(MSVCR80+00002A47)
02/26/2008 16:54:02,spid57,Unknown,781329BB Module(MSVCR80+000029BB)
02/26/2008 16:54:02,spid57,Unknown,010B9201 Module(sqlservr+000B9201)
02/26/2008 16:54:02,spid57,Unknown,010B9064 Module(sqlservr+000B9064)
02/26/2008 16:54:02,spid57,Unknown,010B939C Module(sqlservr+000B939C)
02/26/2008 16:54:02,spid57,Unknown,010B94A5 Module(sqlservr+000B94A5)
02/26/2008 16:54:02,spid57,Unknown,010075DC Module(sqlservr+000075DC)
02/26/2008 16:54:02,spid57,Unknown,010078CC Module(sqlservr+000078CC)
02/26/2008 16:54:02,spid57,Unknown,010077A6 Module(sqlservr+000077A6)
02/26/2008 16:54:02,spid57,Unknown,0102F1F4 Module(sqlservr+0002F1F4)
02/26/2008 16:54:02,spid57,Unknown,01032A36 Module(sqlservr+00032A36)
02/26/2008 16:54:02,spid57,Unknown,01028600 Module(sqlservr+00028600)
02/26/2008 16:54:02,spid57,Unknown,0134752A Module(sqlservr+0034752A)
02/26/2008 16:54:02,spid57,Unknown,01430633 Module(sqlservr+00430633)
02/26/2008 16:54:02,spid57,Unknown,01346B6B Module(sqlservr+00346B6B)
02/26/2008 16:54:02,spid57,Unknown,013A929A Module(sqlservr+003A929A)
02/26/2008 16:54:02,spid57,Unknown,01368BB2 Module(sqlservr+00368BB2)
02/26/2008 16:54:02,spid57,Unknown,013A9BDC Module(sqlservr+003A9BDC)
02/26/2008 16:54:02,spid57,Unknown,013A9A04 Module(sqlservr+003A9A04)
02/26/2008 16:54:02,spid57,Unknown,013AFC6E Module(sqlservr+003AFC6E)
02/26/2008 16:54:02,spid57,Unknown,013A9A04 Module(sqlservr+003A9A04)
02/26/2008 16:54:02,spid57,Unknown,013AF8D0 Module(sqlservr+003AF8D0)
02/26/2008 16:54:02,spid57,Unknown,013A9A04 Module(sqlservr+003A9A04)
02/26/2008 16:54:02,spid57,Unknown,013B0CC7 Module(sqlservr+003B0CC7)
02/26/2008 16:54:02,spid57,Unknown,013A9A04 Module(sqlservr+003A9A04)
02/26/2008 16:54:02,spid57,Unknown,013A9DC5 Module(sqlservr+003A9DC5)
02/26/2008 16:54:02,spid57,Unknown,013A9F20 Module(sqlservr+003A9F20)
02/26/2008 16:54:02,spid57,Unknown,01B2E1B9 Module(sqlservr+00B2E1B9)
02/26/2008 16:54:02,spid57,Unknown,013A9A04 Module(sqlservr+003A9A04)
02/26/2008 16:54:02,spid57,Unknown,01B24372 Module(sqlservr+00B24372)
02/26/2008 16:54:02,spid57,Unknown,0136A2D8 Module(sqlservr+0036A2D8)
02/26/2008 16:54:02,spid57,Unknown,0149C867 Module(sqlservr+0049C867)
02/26/2008 16:54:02,spid57,Unknown,0170D0CD Module(sqlservr+0070D0CD)
02/26/2008 16:54:02,spid57,Unknown,0170F7E3 Module(sqlservr+0070F7E3)
02/26/2008 16:54:02,spid57,Unknown,0170FB90 Module(sqlservr+0070FB90)
02/26/2008 16:54:02,spid57,Unknown,01702514 Module(sqlservr+00702514)
02/26/2008 16:54:02,spid57,Unknown,010A0F91 Module(sqlservr+000A0F91)

View 1 Replies View Related

Connection Busy With Another Hstmt In Sql Server

Sep 2, 2005

Hello,
I am having above mentioned error while inserting records in database.This arises sometimes after 10 records or 20 records.I dont have any object such as hstmt.
before this insert query ,there is another query where I get one colume value from another table.
please can anybody tell me reason of this kind of error.
Thanks in advance

View 1 Replies View Related

Rounding Error: Between Flat File Connection Manager Source && OLE DB Connection Destination (SQL Server 2005)

Jun 22, 2006

I have a Rounding error: Between flat file connection manager Source & OLE DB Connection Destination (SQL Server 2005) in my Dataflow.

File looks like this lets call column names Col A,B,C,D

70410000 RD1 1223631.92 196042.42
70329000 ICD 11025.84 3353.88
71167300 COL 104270.59 24676.96

flat file connection manager settings: first row Column names then Advanced tab Col A float , Col B float , Col C string ,Col D float ,

OLE DB Connection Destination (SQL Server 2005)

CREATE TABLE [dbo].[PT_CUST_ABR](

[PARTY_NO] [float] NULL,

[PARTY_NAME] [varchar](75) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[TELECOMABR] [float] NULL,

[GENIABR] [float] NULL,

Problem: ColA (Source) Rounding error to PARTY_NO (Destination)
I have a field of text of in a flat file that the flat file connection manager Source picks up correctly ��70000893�?
However when it gets the OLE DB Connection Destination the data has changed to 70000896. That��s before its even Written to the database.
The only clue that something is wrong in the middle is the great Data viewer shows the number as 7.000009E+07
Other clues looking at the data it appears there is a rounding error on only the number that dont end in 00
ColA (Source) PARTY_NO (Destination)
71167300 71167296
70329000 70329000
70410000 70410000
Any ideas people?
Thanks in advance
Dave

View 3 Replies View Related

Timeout Or Server Busy Error During Backup......WHY?

Mar 1, 2007

I have the standard version of SQL2005 and have a backup maintenance plan that runs every Sunday consisting of the following steps.

1. Check Database Integrity

2. Rebuild Index

3. Back Up Database (Full)

The backup itself works fine, but sometimes during the backup I am unable to insert new records into the database that I am backing up.

I believe from all the documentation and other comments I have read that the database should always be available for inserts or updates even during the backup operation. The error I receive from VB.NET application is:

System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

The problem only occurs during a full backup, not differentials or tranaction log backups. Sometimes after catching the above error I can insert into another table, but at other times I am not able to insert into the desired or backup table and simply have to write the data to a file and insert it manually at a later time.

This problem does not consistently occur since a backup may take 10 minutes and during that period maybe 5 of 6 records are inserted correctly, but one will fail.

Why doesn't the database always allow inserts during the backup? It should, shouldn't it?

Thanks for any help!

View 6 Replies View Related

SSIS Keeps Giving Me The Visual Studio Is Busy Error, Help!!!

Jun 28, 2007

I am working on a SSIS solution that has 4 packages. All 4 have run before and I have not modified any of them, however I keep getting the error message and it keeps locking up on one of my packages. Does anyone have any advice or a remedy for this?

Any help is appreciated!

View 5 Replies View Related

'Timeout Expired' Error Due To Long Query Or Busy Server?

May 2, 2008

We have been bothered with this problem for a while. Usually I happens in the early moring. Later on after the error is gone on auser, the error never happens again on any user for the day. Is this a web Server problem or an aspx.vb coding error? Thanks,Jeffrey
Server Error in '/SSSSS' Application.

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
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: System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.Source Error:

Line 270: oDBCommand.Connection.Open()
Line 271:
Line 272: Dim myReader As SqlDataReader _
Line 273: = oDBCommand.ExecuteReader(CommandBehavior.CloseConnection)
Line 274:Source File: E:SSSSSScheduling.aspx.vb Line: 272 Stack Trace:

[SqlException (0x80131904): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +862234
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +739110
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1956
System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +31
System.Data.SqlClient.SqlDataReader.get_MetaData() +62
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +297
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +903
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +132
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +122
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) +62
Soma.Scheduling.GetNextAutoAppointment() in E:SSSSSAScheduling.aspx.vb:272
Soma.Scheduling.Page_Load(Object sender, EventArgs e) in E:SSSSSScheduling.aspx.vb:61
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +47
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061

View 7 Replies View Related

Flat File Connection Manager Throws Error When A Column Gets Added To The Flat File

Dec 27, 2006

Hi,

I have a situation where a tab limited text file is used to populate a sql server table.

The tab limited text file comes from a third party vendor. There are fixed number of columns we need to export to the sql server table. However the third party may add colums in the text file. Whenenver the text file has an added column (which we dont need to import) the build fails since the flat file connection manager does not create the metadata for it again. The problem goes away where I press the button "Reset Columns" since it builds the metadata then. Since we need to build the tables everyday we cannot automate it using SSIS because the metadata does not change automatically. Is there a way out in SSIS?

View 5 Replies View Related

Flat File Connection Error

May 8, 2008

Description: The file name "\fhfgy678c$wtswts_Adjud_05082008.txt" specified in the connection was not valid. End Error Error: 2008-05-08 10:04:14.67 Code: 0xC001401D Source: ETL_wts Description: Connection "Flat File Connection Manager" failed validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 10:04:13 AM Finished: 10:04:14 AM Elapsed: 0.781 seconds. The package execution failed. The step failed.

I can run a package that has flat file connection... I can run it withoutany erros in BI studio.. but I am keep getting the above erro after I depoly the package and run as a sql agent job..
I just can not figure out why I am getting this error.. any Idea.. please help..

View 3 Replies View Related

Capturing The Results From Exec Command

Apr 21, 2006

Hi,

I'm writing a small query where I have a dynamic table name and dynamic condition for the criteria. In order to execute this, I need Exec command.

exec(select count(*) from @dynamictable where condition = @dynamiccond)

But here I want to capture the count from the select statement. Could any of you help me capture the results from exec command?

Thanks

View 6 Replies View Related

Using A Variable In SSIS - Error - Command Text Was Not Set For The Command Object..

Nov 4, 2006

Hi All,

i am using a OLE DB Source in my dataflow component and want to select rows from the source based on the Name I enter during execution time. I have created two variables,

enterName - String packageLevel (will store the name I enter)

myVar - String packageLevel. (to store the query)

I am assigning this query to the myVar variable, "Select * from db.Users where (UsrName = " + @[User::enterName] + " )"

Now in the OLE Db source, I have selected as Sql Command from Variable, and I am getting the variable, enterName,. I select that and when I click on OK am getting this error.

Error at Data Flow Task [OLE DB Source [1]]: An OLE DB error has occurred. Error code: 0x80040E0C.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E0C Description: "Command text was not set for the command object.".

Can Someone guide me whr am going wrong?

myVar variable, i have set the ExecuteAsExpression Property to true too.

Please let me know where am going wrong?

Thanks in advance.

View 12 Replies View Related

SQL 2012 :: Run Job With Dtsx File Error If Have Connection Of DB2

May 23, 2014

I create a ssis package with have connection DB2 (I install ibm_data_server_client_win32_V97 in server) in sql2008 (run ok). I deployment in SQL 2012. When i run with Visual Studio or run direct package (*.dtsx). File run OK.

But, i run with job have a error as below.

Error: 2014-05-15 14:18:08.82 Code: 0xC0202009 Source: Package Connection manager "TESTING.cardpro1"
Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80004005 Description: "Unspecified error".
End Error

Error: 2014-05-15 14:18:08.82 Code: 0xC020801C Source: Xuat Report AUDCAR Cardpro-cp_audcar [2] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.
The AcquireConnection method call to the connection manager "TESTING.cardpro1" failed with error code 0xC0202009.

There may be error messages posted before this with more information on why the AcquireConnection method call failed. End Error

I run with user full permission. I run job success with dtxs no contain DB2 connection. Do you have a this case?

View 2 Replies View Related

SSIS Connection Error When Using Config File

Dec 17, 2007

Hi

I am developing one SSIS package to migrate an Oracle Database to SQL Server 2005 DB through ODBC. My problem is with configuration. I have to use configuration file so that in production environment the end-user must be able to change the user credentials to connect both database servers. I am trying xml configuration file. When I try to use xml configuration, my odbc connection is giving error. But if I disable the configuration through "Package Configurations Organizer", it works fine. Using an XML Editor I checked the .dtsconfig file and entered both passwords for the both connections.

I tried logging and below are the few text from log file related to error.

Code Block
User:Diagnostic, Nebu, BLRDOMNebu, DestOdbcConnection,{E3535ED4-1D21-41B9-9796-E9F5B47FFD5B}, {6820E259-18FF-4FCA-B820-73EE931D2095},12/17/2007 8:16:39 PM,12/17/2007 8:16:39 PM,0,0x,ExternalRequest_pre: The object is ready to make the following external request: 'IDbConnection.Open'.

User:Diagnostic,Nebu, BLRDOMNebu, DestOdbcConnection,{E3535ED4-1D21-41B9-9796-E9F5B47FFD5B},{6820E259-18FF-4FCA-B820-73EE931D2095},12/17/2007 8:16:41 PM,12/17/2007 8:16:41 PM,0,0x,ExternalRequest_post: 'IDbConnection.Open failed'. The external request has completed.

I am using Protection level = EncryptSensitiveWithPassword for the package.

Please help me.

Thanks & Regards

Charmis

View 4 Replies View Related

Excel Flat File Connection Manager Error.

Oct 2, 2006

Hi There

I am having some issues with dts packages i have migrated using the package migration wizard.

One of the connection managers points to an execl flat file source.

I have not altered anything after the package migration, the conenction manager is using Native OLE DBMicrosoft Jet 4.0 OLE DB Provider.

When i test the connection i get the following error :

"Test connection failed becuase of an error in initializing provider. Cannot start your application. The workgroup information file is missing or opened exclusively by anotehr user."

Ok i am 99% sure this file is not being accessed by another user, the rest of the error is greek to me. Looking on the net for this error it has to do with access database security and having to sertup htm pages for IIS, i cannot findanything on this error relating to ssis connection manager.

PLEASE HELP.

Thanx

View 4 Replies View Related

SqlDataSource And SSMSE Returning Different Results For Same SELECT Command

Oct 2, 2007

Hi,
Hope you guys won't mind this rather newbie question. I'm writing a simple blog page for my website and have created a SqlDataSource which queries the database for a list of blog post titles (from the web.Blog table) and the number of comments (from the web.BlogComments table). The SqlDataSource control is:
<asp:SqlDataSource ID="sourceBlogArticles" ProviderName="System.Data.SqlClient" connectionString="<%$ ConnectionStrings:myDatabase %>" runat="server" SelectCommand="SELECT gb.blogID, gb.title, gb.description, gb.tags, gb.dateAdded, COUNT(gbc.blogID) AS noOfComments FROM web.Blog gb LEFT OUTER JOIN web.BlogComments gbc ON gb.blogID = gbc.blogID GROUP BY gb.blogID, gb.title, gb.description, gb.tags, gb.dateAdded ORDER BY gb.dateAdded"></asp:SqlDataSource>
This works perfectly well if each blog entry in the web.Blog table has associated comments in the web.BlogComments table. However, if there are no comments yet defined in the web.BlogComments table for that blogID then no row is returned in ASP.Net (as checked with a GridView control or similar linked to the data source to view what I get)
HOWEVER, I think the SELECT command IS correct: if I use the select command as a query in SQL Server Managment Studio Express, I do get the rows returned, with 0 for the number of comments which is what I would expect for that query:
blogID, title, description, tags, dateAdded, noOfComments
1, title 1, description for title 1, tag1, 2007-09-27 06:49:03.810, 32, title 2, description for title 2, tag2, 2007-09-27 06:49:37.513, 03, title 3, description for title3, tag3, 2007-10-02 18:21:30.467, 0
Can anyone help? The result from the SSMSE query is what I want, yet when I use the very same SELECT statement in my SqlDataSource I don't get any rows returned if the BlogComment count is zero (in the above example I get only the first row). Many thanks for any suggestions!

View 6 Replies View Related

Integration Services :: Error / Directory Is Not Specified In File Connection Manager

Jul 18, 2012

I have one SSIS package that has FTP task which takes files from FTP and save on my local drive but i'm getting above error.

[FTP Task] Error: Directory is not specified in the file connection manager "User::ProcessingFileLocation".

In FTP Editor setting :

User::ProcessingFileLocation used SSIS variable and values sets to this is MYSERVERRaw Data

why getting this error?

when i mention direct path it is working fine BUT why not for variable.I'm using same path for other packages too they all are working fine.

View 11 Replies View Related

Error 0xC020209C In Flat File Connection Manager In SSIS

Feb 7, 2007

Hi,
I got this error in a Flat File connection manager, it was saying that the last column caused the disk I/O Buffer overflow, whereas the last column contains 188 characters at max.

Any Idea how to deal with it ?

Thanks,
Fahad

View 1 Replies View Related

Command Text Was Not Set For The Command Object Error

Sep 19, 2006

Hi. I am writing a program in C# to migrate data from a Foxpro database to an SQL Server 2005 Express database. The package is being created programmatically. I am creating a separate data flow for each Foxpro table. It seems to be doing it ok but I am getting the following error message at the package validation stage:

Description: An OLE DB Error has occured. Error code: 0x80040E0C.

An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E0C Description: "Command text was not set for the command object".

.........

Description: "component "OLE DB Destination" (22)" failed validation and returned validation status "VS_ISBROKEN".

This is the first time I am writing such code and I there must be something I am not doing correct but can't seem to figure it out. Any help will be highly appreciated. My code is as below:

private bool BuildPackage()

{

// Create the package object

oPackage = new Package();

// Create connections for the Foxpro and SQL Server data

Connections oPkgConns = oPackage.Connections;

// Foxpro Connection

ConnectionManager oFoxConn = oPkgConns.Add("OLEDB");

oFoxConn.ConnectionString = sSourceConnString; // Created elsewhere

oFoxConn.Name = "SourceConnectionOLEDB";

oFoxConn.Description = "OLEDB Connection For Foxpro Database";

// SQL Server Connection

ConnectionManager oSQLConn = oPkgConns.Add("OLEDB");

oSQLConn.ConnectionString = sTargetConnString; // Created elsewhere

oSQLConn.Name = "DestinationConnectionOLEDB";

oSQLConn.Description = "OLEDB Connection For SQL Server Database";

// Add Prepare SQL Task

Executable exSQLTask = oPackage.Executables.Add("STOCK:SQLTask");

TaskHost thSQLTask = exSQLTask as TaskHost;

thSQLTask.Properties["Connection"].SetValue(thSQLTask, "oSQLConn");

thSQLTask.Properties["DelayValidation"].SetValue(thSQLTask, true);

thSQLTask.Properties["ResultSetType"].SetValue(thSQLTask, ResultSetType.ResultSetType_None);

thSQLTask.Properties["SqlStatementSource"].SetValue(thSQLTask, @"C:LPFMigrateLPF_Script.sql");

thSQLTask.Properties["SqlStatementSourceType"].SetValue(thSQLTask, SqlStatementSourceType.FileConnection);

thSQLTask.FailPackageOnFailure = true;

// Add Data Flow Tasks. Create a separate task for each table.

// Get a list of tables from the source folder

arFiles = Directory.GetFileSystemEntries(sLPFDataFolder, "*.DBF");

for (iCount = 0; iCount <= arFiles.GetUpperBound(0); iCount++)

{

// Get the name of the file from the array

sDataFile = Path.GetFileName(arFiles[iCount].ToString());

sDataFile = sDataFile.Substring(0, sDataFile.Length - 4);

oDataFlow = ((TaskHost)oPackage.Executables.Add("DTS.Pipeline.1")).InnerObject as MainPipe;

oDataFlow.AutoGenerateIDForNewObjects = true;

// Create the source component

IDTSComponentMetaData90 oSource = oDataFlow.ComponentMetaDataCollection.New();

oSource.Name = (sDataFile + "Src");

oSource.ComponentClassID = "DTSAdapter.OLEDBSource.1";

// Get the design time instance of the component and initialize the component

CManagedComponentWrapper srcDesignTime = oSource.Instantiate();

srcDesignTime.ProvideComponentProperties();

// Add the connection manager

if (oSource.RuntimeConnectionCollection.Count > 0)

{

oSource.RuntimeConnectionCollection[0].ConnectionManagerID = oFoxConn.ID;

oSource.RuntimeConnectionCollection[0].ConnectionManager = DtsConvert.ToConnectionManager90(oFoxConn);

}

// Set Custom Properties

srcDesignTime.SetComponentProperty("AccessMode", 0);

srcDesignTime.SetComponentProperty("AlwaysUseDefaultCodePage", true);

srcDesignTime.SetComponentProperty("OpenRowset", sDataFile);

// Re-initialize metadata

srcDesignTime.AcquireConnections(null);

srcDesignTime.ReinitializeMetaData();

srcDesignTime.ReleaseConnections();

// Create Destination component

IDTSComponentMetaData90 oDestination = oDataFlow.ComponentMetaDataCollection.New();

oDestination.Name = (sDataFile + "Dest");

oDestination.ComponentClassID = "DTSAdapter.OLEDBDestination.1";

// Get the design time instance of the component and initialize the component

CManagedComponentWrapper destDesignTime = oDestination.Instantiate();

destDesignTime.ProvideComponentProperties();

// Add the connection manager

if (oDestination.RuntimeConnectionCollection.Count > 0)

{

oDestination.RuntimeConnectionCollection[0].ConnectionManagerID = oSQLConn.ID;

oDestination.RuntimeConnectionCollection[0].ConnectionManager = DtsConvert.ToConnectionManager90(oSQLConn);

}

// Set custom properties

destDesignTime.SetComponentProperty("AccessMode", 2);

destDesignTime.SetComponentProperty("AlwaysUseDefaultCodePage", false);

destDesignTime.SetComponentProperty("OpenRowset", "[dbo].[" + sDataFile + "]");

// Create the path to link the source and destination components of the dataflow

IDTSPath90 dfPath = oDataFlow.PathCollection.New();

dfPath.AttachPathAndPropagateNotifications(oSource.OutputCollection[0], oDestination.InputCollection[0]);

// Iterate through the inputs of the component.

foreach (IDTSInput90 input in oDestination.InputCollection)

{

// Get the virtual input column collection

IDTSVirtualInput90 vInput = input.GetVirtualInput();

// Iterate through the column collection

foreach (IDTSVirtualInputColumn90 vColumn in vInput.VirtualInputColumnCollection)

{

// Call the SetUsageType method of the design time instance of the component.

destDesignTime.SetUsageType(input.ID, vInput, vColumn.LineageID, DTSUsageType.UT_READWRITE);

}

//Map external metadata to the inputcolumn

foreach (IDTSInputColumn90 inputColumn in input.InputColumnCollection)

{

IDTSExternalMetadataColumn90 externalColumn = input.ExternalMetadataColumnCollection.New();

externalColumn.Name = inputColumn.Name;

externalColumn.Precision = inputColumn.Precision;

externalColumn.Length = inputColumn.Length;

externalColumn.DataType = inputColumn.DataType;

externalColumn.Scale = inputColumn.Scale;

// Map the external column to the input column.

inputColumn.ExternalMetadataColumnID = externalColumn.ID;

}

}

}

// Add precedence constraints to the package executables

PrecedenceConstraint pcTasks = oPackage.PrecedenceConstraints.Add((Executable)thSQLTask, oPackage.Executables[0]);

pcTasks.Value = DTSExecResult.Success;

for (iCount = 1; iCount <= (oPackage.Executables.Count - 1); iCount++)

{

pcTasks = oPackage.PrecedenceConstraints.Add(oPackage.Executables[iCount - 1], oPackage.Executables[iCount]);

pcTasks.Value = DTSExecResult.Success;

}

// Validate the package

DTSExecResult eResult = oPackage.Validate(oPkgConns, null, null, null);

// Check if the package was successfully executed

if (eResult.Equals(DTSExecResult.Canceled) || eResult.Equals(DTSExecResult.Failure))

{

string sErrorMessage = "";

foreach (DtsError pkgError in oPackage.Errors)

{

sErrorMessage = sErrorMessage + "Description: " + pkgError.Description + "";

sErrorMessage = sErrorMessage + "HelpContext: " + pkgError.HelpContext + "";

sErrorMessage = sErrorMessage + "HelpFile: " + pkgError.HelpFile + "";

sErrorMessage = sErrorMessage + "IDOfInterfaceWithError: " + pkgError.IDOfInterfaceWithError + "";

sErrorMessage = sErrorMessage + "Source: " + pkgError.Source + "";

sErrorMessage = sErrorMessage + "Subcomponent: " + pkgError.SubComponent + "";

sErrorMessage = sErrorMessage + "Timestamp: " + pkgError.TimeStamp + "";

sErrorMessage = sErrorMessage + "ErrorCode: " + pkgError.ErrorCode;

}

MessageBox.Show("The DTS package was not built successfully because of the following error(s):" + sErrorMessage, "Package Builder", MessageBoxButtons.OK, MessageBoxIcon.Information);

return false;

}

// return a successful result

return true;
}

View 2 Replies View Related

File Connection Act Differently Than Flat File Connection For Expressions?

Jun 26, 2007

I am thinking I must be doing something wrong..

I have dozens of packages that work as follows (high level... not listing all the steps just those relevant to this question)

- Get list of files in directory

- Join list to list of already imported files

- Those not imported put into an ADO.Net object

- Loop through ADO.Net record (which contains the filename) and import each file.

I just set the connection string of the flat file to be the variable in the loop (expressions.. connection string). Pretty standard stuff. Now I tried to do the same with a file connection (not a flat file) becuase I have a source that is from a mainframe and I had to write a custom source script and its not working. Basically the source script uses

oRead = oFile.OpenText(Me.Connections.FileConnection.ConnectionString)

And it opens the same file over and over (not ever changing as the ConnectionString expression changes like it does for flat files) and imports it even though I have verified the loop is correctly looping through all the different files.

Any thoughts as to what I am doing wrong?

View 3 Replies View Related