Moving SSIS pkgs

  • I have hundreds of ssis pkgs in MSDB database in multiple folders, is there an easy way i can move pkgs from one folder to another, other than using import/export.

  • dtutil:

    You can use the dtutil command prompt utility to manage existing packages at the command prompt. You can access packages that are stored in the SQL Server msdb database, the SSIS Package Store, and the file system, and perform tasks such as copying, deleting, moving, and signing packages. You can also verify that a specified package exists.

    The_SQL_DBA
    MCTS

    "Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."

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

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