I am faced with a situation where there are around 200 packages currently running in production but they all have hard-coded connection managers. Now they want to create configuration files...

Unfortunately, my requirement is to specifically build a generic stored proc which can be called by n number of stored procs who will pass the table name and the delimiter....

Can you upload the latest version of the script?

Thanks for the quick reply! However when I run the package, I am getting the following error:

[OLE DB Destination 1 [355]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE...

I am trying to use your code to get the error rows. I am not too familiar with XML but when I pasted the code inside the script editor in...