Hi!
I am creating a simple package, which I run in SQL Server 2005 (in
development mode). I want to transfer data from a flat file to an SQL
Server 2005 Database table. I get the errors listed below. I get the
same (or similar) errors when I use an OLE DB Connection or an SQL
Server Connections (The data destinations provided by SSIS).

I get this errors on my local database (running SSIS on the same
machine as SQL server) and when I connect to another database.

Is SSIS a good way to import data from flat files into a complex
database?
Would it be better to create stored procedures/SQL builk insert program
to populate the database?

SQL will not let me create a simple program to import data from a flat
file, and I cannot see what I'm doing wrong. Any help is appreciated!

Bonus question: Is there a way to create bcp (xml file definitions)
from the flat file datasource I defined in the SSIS project?

Thanks


=================================================
[OLE DB Destination [4860]] Error: An OLE DB error has occurred. Error
code: 0x80040E21. An OLE DB record is available. Source: "Microsoft
SQL Native Client" Hresult: 0x80040E21 Description: "Multiple-step
OLE DB operation generated errors. Check each OLE DB status value, if
available. No work was done.".

[OLE DB Destination [4860]] Error: The "input "OLE DB Destination
Input" (4873)" failed because error code 0xC020907B occurred, and the
error row disposition on "input "OLE DB Destination Input" (4873)"
specifies failure on error. An error occurred on the specified object
of the specified component.

[DTS.Pipeline] Error: The ProcessInput method on component "OLE DB
Destination" (4860) failed with error code 0xC0209029. The identified
component returned an error from the ProcessInput method. The error is
specific to the component, but the error is fatal and will cause the
Data Flow task to stop running.

[DTS.Pipeline] Error: Thread "WorkThread0" has exited with error code
0xC0209029.

[DTS.Pipeline] Error: Thread "WorkThread1" received a shutdown signal
and is terminating. The user requested a shutdown, or an error in
another thread is causing the pipeline to shutdown.

[DTS.Pipeline] Error: Thread "WorkThread1" has exited with error code
0xC0047039.

[finalip [8690]] Error: The attempt to add a row to the Data Flow task
buffer failed with error code 0xC0047020.

[DTS.Pipeline] Error: The PrimeOutput method on component "finalip"
(8690) returned error code 0xC02020C4. The component returned a
failure code when the pipeline engine called PrimeOutput(). The meaning
of the failure code is defined by the component, but the error is fatal
and the pipeline stopped executing.

[DTS.Pipeline] Error: The PrimeOutput method on component "finalip"
(8690) returned error code 0xC02020C4. The component returned a
failure code when the pipeline engine called PrimeOutput(). The meaning
of the failure code is defined by the component, but the error is fatal
and the pipeline stopped executing.

Hello niagara_man (AT) hotmail (DOT) com,


SSIS is an excellent way to move flat file data into SQL Server.


The error number 0xC02020C4 simply translates to DTS_E_ADDROWTOBUFFERFAILED

The first error 0x80040E21 translates to DTS_E_OLEDBDESTINATIONADAPTERSTATIC_UNAVAILABLE


Do you lose your destination adapter? Can you try throwing any data in there.

How about recreating the destination?


Allan