Post reply

Where is SSIS stored when installed in SQL server?

  • September 15, 2008 at 3:21 pm

    #197851

    Hi all,

    I have never installed SSIS in SQL server. I have always installed them to a file system. Now I am in an environment where SSIS packages are installed to SQL server. I want to modify an SSIS package. But i donot know where it stored when we delpoy to SQL server. Where can i find them and Where are they stored? How can i copy it to the file system to make changes?

    I appreciate any help.

    Thanks,

    Kayal

  • September 15, 2008 at 3:33 pm

    #872053

    Hi,

    ON MAnagement studio, connect to Integration services.Under stored packages, look under msdb folder. IF it is saved in msdb, which is the default location for SSIS packagesare, when you saved on SQL server. You cal also run this query to see, SSIS packages on msdb: select * from sysdtspackages90.

    If it is not stored on server, file syster, then you need to know the local path.

    VG

  • September 15, 2008 at 3:35 pm

    #872054

    You will have to Export the package to file system to edit it. you can then redeploy to filesystem if you want.

  • September 15, 2008 at 3:36 pm

    #872056

    you don't need to copy packages to the file system to amend them, but if you want to copy packages use utility DTUTIL

    ---------------------------------------------------------------------

  • September 16, 2008 at 9:46 am

    #872496

    Thank you guys. I appreciate ur quick replies.

Viewing 5 posts - 1 through 4 (of 4 total)

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