Viewing 5 posts - 1 through 5 (of 5 total)
Are you doing this in the Control Flow design screen or are you down in a data flow? Package variables don't have a 4k limit. That only applies to fields in a data flow....
January 27, 2006 at 8:17 am
Have you tried splitting your query across 2 or more variables and then concatenating them together using the Expression syntax on the SQLStatementSource property?
January 27, 2006 at 7:38 am
Sounds lilke you need to build your entire query in a Scripting Task and put the query in a variable. Then set the SQLSourceType property of your Execute SQL Task to...
January 27, 2006 at 7:28 am
Sounds lilke you need to build your entire query in a Scripting Task and put the query in a variable. Then set the SQLSourceType property of your Execute SQL Task to...
January 27, 2006 at 7:28 am
There is a set of C# coding examples that come with the SSIS installation. I believe that you install them from the start menu after the initial SSIS install is...
January 10, 2006 at 9:27 am
Viewing 5 posts - 1 through 5 (of 5 total)