Forum Replies Created

Viewing 5 posts - 1 through 5 (of 5 total)

  • RE: Subqueries on SSIS Packages

    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....

  • RE: Subqueries on SSIS Packages

    Have you tried splitting your query across 2 or more variables and then concatenating them together using the Expression syntax on the SQLStatementSource property?

  • RE: Subqueries on SSIS Packages

    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...

  • RE: Subqueries on SSIS Packages

    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...

  • RE: Calling an IS package in C# ?

    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...

Viewing 5 posts - 1 through 5 (of 5 total)