Search code examples
visual-studiossisbusiness-intelligence

SSIS Error 0xC001000E at Package: Thrown by connection collection when the specific element is not found

I am getting the above error in a Bulk Insert Task Editor in SSIS in Microsoft Visual Studio 2008 using Business Intelligence.

SSIS Error 0xC001000E at Package: Thrown by connection collection when the specific element is not found
The connection "C:\Temp\Objects.bin" is not found. 
Error: 0xC002F304 at Bulk Insert Task, Bulk Insert Task: An error occurred   with the following error message: 
"Cannot bulk load because the file   "C:\Temp\objects.bin" could not be opened. 
Operating system error code 3(The system cannot find the path specified.).".

As you can see by the xml of the package is exists(objects.bin) and I have selected this file for the source connection. The file definitely exists and I have tried it as a different file type(.txt) as well. I do not understand why I am getting the error.

Package.dtsx(XML)

<DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
<DTS:Property DTS:Name="ObjectName">objects.bin</DTS:Property>
<DTS:Property DTS:Name="DTSID">{34E3EEA5-9B40-4B25-9DE7-48B0D14346FE}       </DTS:Property>
<DTS:Property DTS:Name="Description"></DTS:Property>
<DTS:Property DTS:Name="CreationName">FILE</DTS:Property><DTS:ObjectData>     <DTS:ConnectionManager>
<DTS:Property DTS:Name="FileUsageType">1</DTS:Property>
<DTS:Property DTS:Name="ConnectionString">C:\Temp\objects.bin</DTS:Property>  </DTS:ConnectionManager></DTS:ObjectData></DTS:ConnectionManager>
<DTS:ConnectionManager>

Bulk Insert Task Editor

Bulk Insert Task Editor Image

Solution

  • The bulk copy needs the files it is reading from to be on the same as the server in is writing to. Pretty simple. So now that sql server destination and the connection files for the source are on the same server the problem is solved.

    I should add that I also got into trouble by copying my bulk insert and then trying to change the connection file property. It was impossible to change it after that. That problem was solved after deleting and creating new Bulk Inserts.