ssis expressions

  • My code is Over 4000 characters. Help me to use my entire code in that variable.

  • Can you explain what you're doing? Maybe there's a better approach.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • You have several options:

    - split out the code in multiple expressions. (not good for maintenance)

    - create a stored procedure at the beginning of your package. This sp contains your code and accepts the variables needed in the expression as input parameters. Since you create this in the Execute SQL Task, it can contain more then 4000 characters. Then, when you need your code, just use EXEC sp_my_code variable1 variable 2 et cetera. At the end of the package, drop the stored procedure.

    Just make sure you use a unique name for your stored procedure!

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply