That's one reason why I never nest stored procedures within a transaction.   Too many pieces to go wrong, and too much to keep track of.  Extremely difficult to troubleshoot under...

Take a look here:  https://www.sqlskills.com/blogs/kimberly/clarifying-left-and-right-in-the-defintion-of-a-partition-function-in-sql-server-2005/

The article is old, but the concepts have probably not changed much.  If anyone knows otherwise, please correct me, as I'm not a...

A couple of problems here.   You should NOT be saving passwords in SSIS packages... major security risk in doing so.   However, while I can assume your package worked fine locally...

Well, if you at least have spaces between each element, you could use a string splitter (see Jeff Moden's article here:  http://www.sqlservercentral.com/articles/72993/ ) to get to each element, then as...

The problem here is understanding what you have to do with a cursor.   In order to get the loop to work correctly, you have to be able to do your...

It seems likely that there is some configuration element in your applications that is overridden somewhere that at the moment, you are unaware of.   Something in your connection to SQL...