Expression formatting

• Ells

  SSCrazy Eights

  Points: 9901

  More actions

  March 26, 2012 at 11:30 pm

  #270911

  I absolutely think using expressions for variables is great and often construct SQL as a dynamic string within a variable.

  There are two downsides to this:

  1. The length of the text is a maximum of a theoretical 4000 characters (limit of a DT_STR)

  2. The formatting never stays after a save :crazy:

  Solutions

  1. The length I am learning to live with and perhaps this is not an ideal way to store complex SQL. Maybe I need to use stored procedures and pass in the variables. In addition where these are common components I can save on re-use.

  The formatting has me stumped! Literally SSIS gets rid of any new lines and makes it one endless string. Any suggestions for trying to retain the format?

  Many thanks

• tom.wauters

  Say Hey Kid

  Points: 706

  More actions

  March 27, 2012 at 3:50 am

  #1464821

  I have been struggling with this format-issue just like you.

  I haven't found any solution (yet), but when I do, I will certainly post it here.

  One thing I have noticed though, is that the 'newlines' are not removed, they are just not visible in the expression editor.

  You can see this when you click the 'Evaluate Expression' box, certain text appears on a new line, just where you added this newline