Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 split string value

Author  Topic 

varalakshmi
Yak Posting Veteran

98 Posts

Posted - 2010-07-19 : 05:29:19
Hi,
I'm using an SSIS variable to store column names of an insert query.
This column list is retrived dynamically.
When the number of columns increases, SSIS variables cannot hold the value if the size exceeds 4000 characters resulting in error.
Is it possible to split the column list into two and store it in 2 variables?

- Varalakshmi
   

- Advertisement -