0

Is there a way to export and import multiple dtsx packages from SQL Server 2008?

I'm trying to find a built-in way/free tool/script to automate right-clicking the package, selecting "File System" for package location, and specifying the same server and package path for about 50+ packages.

Steve
  • 113
  • 4

2 Answers2

1

Take a look at DTUTIL

Sam
  • 2,020
  • 1
  • 16
  • 22
0

Have you looked at SQLServer Powershell Extensions (SQLPSX)? There is a library of functions for doing just this kind of thing.

http://sqlpsx.codeplex.com/

Mike Shepard
  • 748
  • 3
  • 7