ssis-2005

SSIS 2005 Error while using script component Designer: "Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".

I am trying to debug a dts package in SSIS. I have a script component designer where I pass in the input variables to increment a counter. When I try to msgbox the counter value, I get the following error. Error: 0xC0202009 at STAGING1 to STAGING2, STAGING2 Destination [1056]: An OLE DB error has occurred. Error code: 0x80040E14. An ...

For Each File Enumerator is empty in SSIS 2005, even though there are files

Hi, In an SSIS 2005 package, I have a For Each File Enumerator which iterates through all *.csv files in a folder. The Directory property (and hence Folder) is specified in the VS 2005 development environment. When I run it from VS 2005, the .csv files in the folder get processed and everything works fine. I set the configuration for t...

select data from excel spreadsheet that's read only

I've got a dtsx package that selects data from an excel spreadsheet on the network and inserts it into a sql server table twice a day. However, the process fails if someone is in the spreadsheet modifying data. Is there a way to select data from an excel spreadsheet so that it doesn't fail if someone is in the spreadsheet? ...