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)
0 comments:
Post a Comment
I get a lot of comment spam :( - moderation may take a while.