SSIS variable limit

Last Post 30 Nov 2007 08:44 AM by prospec. 4 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
prospec
New Member
New Member

--
29 Nov 2007 02:26 PM
All,
Can someone tell me what the user defined variable limit is for SSIS? I am not able to find the specs for that item.
Thanks
SQLUSA
New Member
New Member

--
29 Nov 2007 06:31 PM
How many variable you can set up?
prospec
New Member
New Member

--
30 Nov 2007 08:44 AM
Correct the max number of user defined variables that can be created in SSIS.
SQLUSA
New Member
New Member

--
30 Nov 2007 11:12 AM
User variables are in the User Namespace.

I'm only aware of 4000 byte expression limit

It is possible that the limit is by available space.

Why are you worried?

Kalman Toth
http://www.sqlusa.com/ssis/
prospec
New Member
New Member

--
30 Nov 2007 12:52 PM
I inherited an SSIS application and there was a change with the source system that might have required many variables. I decided to approach it from a different angle. Since the SSIS files are XML it is just easier for me to edit the XML file instead of creating more variables. The change to the XML file is just a one-time deal and will last for at least a year before it needs to be changed again. By that time, we will just develop a new SSIS solution.


Acceptable Use Policy
---