August 11, 2010 at 10:35 pm
My code is Over 4000 characters. Help me to use my entire code in that variable.
August 12, 2010 at 3:00 am
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
August 12, 2010 at 3:04 am
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