Viewing 4 posts - 1 through 4 (of 4 total)
Glad that helped.
I think that's a major limitation within SSIS. Row by row transformations with large amounts of data are not uncommon.
April 11, 2008 at 6:08 am
Yes, I created a variable called connString, and it contains the connection string. Be sure the connection string doesn't contain the "Provider" keyword, as the OLE DB connection will...
April 7, 2008 at 7:11 am
Ok, here's the basis of my workaround.
I created a script task to replace the Update Parameters data flow task. I also wrote a custom SQL function that parses the...
March 31, 2008 at 2:33 pm
I'm working on this exact issue right now. The issue occurs when your parameter values are too long (i.e. > ~32767 chars) and are being truncated somewhere in the...
March 31, 2008 at 11:36 am
Viewing 4 posts - 1 through 4 (of 4 total)