Mmm. If the environment variable will tell SSIS where the configuration will reside, do you mean the table name and location as this will be the same wherever the...

Thanks for your response there PD. The connection string to the database that contains my SSIS Configurations table would remain the same for all environments I will be using as...

Don't seem to be getting much response on this one. Having trawled the net on package configurations this seems to be the norm. Does everyone use the xml versions only?

Thanks for your post here. I persevered in the end with the speed issue as I would have to copy variables and all sorts across packages etc, but what seems...

Wahey!!! That's worked thanks. I rather stupidly was connecting to the report$server database rather than the RSExecutionLog database! Many thanks for this code. Much obliged.

Thanks for this. I've assumed you pre-populated a user variable called connString here with the connection string, but I'm not sure with what here. I've tried but with no success....

Is it worth me reporting this to Microsoft? If so, how do I do this please as I've never contacted them in this way before?

Sob...16 views but no reply. Has no-one else encountered this?

Thanks everyone. You've been a great help here!

That function's worked a dream thanks. I added a little while loop in to take care of the multiple spaces and it looks really good now. Many thanks.

I need to do this to parse out data required by an agency we send address details too to place the contents of our address line 1 to their separate...

Thanks Matt. Having looked at those web pages there's no limitation on the number of parameters either, although I wouldn't call a 992 columned table a simple table! I can...

I'm doing something similar to that as it is. See the attached.

I don't specifically request to use sp_cursor I think SSIS uses this as a default version when your access mode is set to Table or View. I only found out...

This is the error within SSIS that I believe causes the issue:

Error: 0xC0202009 at Populate the feeSchedTbl table, Populate the feeSchedTbl table [27920]: SSIS Error Code DTS_E_OLEDBERROR. An OLE...