Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Maximum size of SQL variable in SSIS ? Expand / Collapse
Author
Message
Posted Monday, November 18, 2013 1:21 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 15, 2014 8:51 PM
Points: 183, Visits: 480
4K chars ? Thats like a full stop for me. How about 500K chars plus ? :)
Post #1515125
Posted Monday, November 18, 2013 1:26 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:52 PM
Points: 13,368, Visits: 11,148
blasto_max (11/18/2013)
4K chars ? Thats like a full stop for me. How about 500K chars plus ? :)


Use a stored procedure, like I mentioned earlier.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1515127
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse