Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hismightiness
Posting Yak Master
164 Posts |
 Posted - 2007-08-22 : 08:42:08
|
I have a 4-task job I am creating using SSIS. I cannot get this job to not throw an error on the importing on 2 of the 6 CSV file data imports. The CSV files are on the same server as the SQL Server, and the SSIS is being run on the same machine as well. Here is the error that I am receiving:quote:
[DTS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "SQLServerConn5" (954) failed with error code 0xC0202071. 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. There may be error messages posted before this with more information about the failure.
In looking up the error code, I have found a great number of forum threads that say in order to fix this error, the SQL Server must be on the same machine as where the SSIS package is being run. It is.In fact these two CSV imports occur after 4 other imports complete successfully. However, just to be sure that it was not an issue with the size of the files or something (file 1 = 60002 records & file 2 = 27041 records), I did switch out the SQL Server Destination component with the OLE DB Destination, and it also didn't work.In addition, since this might be memory related, I tried setting the MaxInsertCommitSize property to various levels (1,10,50,100,1000, etc.) to buffer the row insertion. This also did not work, but it did cause the job to run a few seconds longer.Has anyone else experienced this? Can you lend any insight as to how to troubleshoot this further?- - - -- Will -- - - -http://www.strohlsitedesign.comhttp://blog.strohlsitedesign.com/http://skins.strohlsitedesign.com/ |
|
|
|
|
|
|
|
SSIS Import Error