SSIS multiline string variables in VS 2008
I need to store a large query in a string variable.
When I insert the sql query into the Value of the variable, I only see one line. I am using VS 2008, BIDS to develop a package. I think this is a bug as stated here ,
what I'm really interested in is a workaround to get around this.
source to share
We use a parameter table in a SQL database and then load long strings into variables with a simple SQL query. This has the added benefit that you can refactor your request code without opening SSIS.
It also allows multiple packages to easily share a common request code.
Edit: Of course, if you only want to do it once ...
Manually edit XML. Place the placeholder value in a variable, then open .dtsx in a text editor, find the placeholder value and replace it with the value you want.
Please back up your package before doing this.
source to share