Post reply

How to change a small change and update it

  • March 11, 2009 at 9:23 am

    #131608

    Hello All,

    i am quite new for Deployment stuff in SSIS,

    in one folder we have some(about 5) .dtsx (.dtsx only, nothing else) files, and these are the production ones,

    i have a small change needs to applied one of .dtsx package and needs to apply those changes in Sql Server Management Studio--> MSDB packages (we already have all packages here)

    please suggest me,

    so my Question is how to apply small change to one of above 5 .dtsx packages and how to update the change in SQL server Integration services packages(MSDB)

    Thanks in advance

    Best Regards

    bujji

  • March 11, 2009 at 10:57 am

    #957685

    usually you would have a solution (.sln) file in a parent folder of the the 5 .dtsx files. open the solution in visual studio (BIDS) and make your changes, then you would rebuild the solution and deploy back to sql server.

    if you just have 5 loose files without a solution, then i would create a new solution and add the existing .dtsx files to it and then build and deploy.

    hope that makes sense.

    bc

    [font="Arial Narrow"]bc[/font]

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

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