robert030975
MIS
- Oct 17, 2006
- 227
W2K5 SP2 A very simple SSIS package with two connections
I have an issue with a package config
If I add the config file to the package and then try to execute it the package fails.
1. D:\DTS\SSIS\deployconf.xml
2.the connection manager was ticked.
3. then saved as config
( two connections one to a Msaccess db and the other local to S2K5 db.)
the error that occurs
[DTS.Pipeline] Error: component "Task Collection" (1) failed validation and returned error code 0xC020801C.
[Connection manager "Trackit live"] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E21. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040E21 Description: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.".
Note I have already set the 64bit to false.
I have an issue with a package config
If I add the config file to the package and then try to execute it the package fails.
1. D:\DTS\SSIS\deployconf.xml
2.the connection manager was ticked.
3. then saved as config
( two connections one to a Msaccess db and the other local to S2K5 db.)
the error that occurs
[DTS.Pipeline] Error: component "Task Collection" (1) failed validation and returned error code 0xC020801C.
[Connection manager "Trackit live"] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E21. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040E21 Description: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.".
Note I have already set the 64bit to false.