Friday, December 07, 2007

cmdline DTS to DTSX

When migrating a command line executed package from SQL Server 2000 to 2005

1. Use the migration wizard to turn the DTS file into a DTSX one

2. Change the command line.

From:

dtsrun /FC:\Scripts\GetLatestDataFromDev /NGetLatestDataFromDev /A"TargetServer:8=(local)"

To:

dtexec /FILE C:\Scripts\GetLatestDataFromDev.DTSX /Set \package.variables[TargetServer].Value;(local)

2 comments: