Post reply

could not see dts packages

  • June 22, 2012 at 8:27 am

    #257852

    Hi All,

    I have a SQL Server without Integration Services and i always saved my Import/Export Projects as SSIS Packages.

    I do not installed Integration Services before, but all packages were saved.

    Now i want to display my saved ssis pakages? Bu could not see in any subtitle with SSMS.

    How do i migrate my saved ssis packages to another host?

  • June 22, 2012 at 8:43 am

    #1504528

    Did you save them to the file system or to MSDB?

    If MSDB, then the powershell script attached will loop through your MSDB and copy out the dtsx packages to a location you tell it to, then you can load them into another MSDB database via loading them into a solution then using the save copy as functionality in BIDS.

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

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