Enter variables for SSIS package when run from Bat file

  • Hi All,

    I have several strored procedures that are run by our Finance team that provide data that needs to be exported to text files, unfortunately they currently have to run the reports through SSMS and input certain parameters manually (Invoice Numbers).

    I am in the process of building SSIS packages so that the Finance Team can retrieve the data via Bat files which run the packages through SQL Server Agent Jobs. Is there any way to allow the users to input the parameters for the stored procedures when they run the Bat file so that they get inputed as variables into the package.

    Thanks in advance for any help...

    Matt

  • Yes, you can do this.

    Basically, you can have your BAT file assign the paramters to Environment Variables, that your SSIS package can then automatically load into it's own variables when the BAT file calls it.

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.
    [/font]
    [font="Verdana"] "Performance is our middle name."[/font]

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

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