I had a similar problem a while ago - a package that had been running successfully for ages suddenly began failing a a sql task very similar to this one....

Hi,

I have had to do a lot of work to upgrade DTS packages to SSIS and have had to develop a number of workarounds - especially as the Microsoft information...

Hi,

This was a valuable post and reply - I didn't know about the temp table and table variable problems and the two workarounds were both good ways to handle the...

I know my data very well and also that ADO in excel doesn't handle columns with mixed data. A cell with numeric data will be taken as numeric and...