Post reply

How to call one SP for multiple Execute Sql tasks

  • July 6, 2010 at 7:37 am

    #157060

    I want to make my Package dynamic by using the same SP for multiple execute sql tasks. Basically, that stored procedure will have multiple if statemets for different values of a input parameter which is mapped to a variable. But I was wondering about the way I assign values to my variables i.e. How do I change the values of my variables at different stages in my package?

  • July 6, 2010 at 7:56 am

    #1189106

    Create variables....that suit your need:-D:-D:-D

    Or use markers (?)

    Raunak J

  • July 6, 2010 at 7:57 am

    #1189107

    You can use a Script Task in your Control Flow to change the value of a variable. Define your variable as ReadWrite In the script task properties dialog. Then in the .NET script you would do:

    Dts.Variables("your_variable").Value = new_value

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

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