Post reply

How to automate SSIS package

  • November 11, 2009 at 12:08 am

    #212270

    Hi,

    My scenarion is : I have to send a SSIS package to different prod servers. Which have

    The SSIS package containg 8 excel files and 8 tables. The data are imported from the excel file to temporary tables.

    Every time the PROD DBA has to set the connection string and have to choose the destination tables which is a tedious task.

    Is there a way we cam automate the connectioon string, Source path and destination tables so, the DBA has only to execute the SSIS package rest of the tning will be taken care by script.

    Thanks in advance.

    Cheers,

    Got an idea..share it !!

    DBA_Vishal

  • November 11, 2009 at 6:58 am

    #1077765

    Have you checked into using Package Configurations? If not, search SSC for answers on that and you'll get a bunch of results. There are a few really good articles on SSC that cover deploying SSIS packages into multiple environments.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

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

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