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)
cmdline DTS to DTSX
Related Posts:
Microsoft MVP Virtual Conference May 14-15, 2015 If you find yourself with some time over the next couple of days, be sure to check out this Virtual Conference presented by Microsoft MVPs i… Read More
I don't get UWP on IOTOn Windows 10 we'll be able to build a single app, using the Universal Windows Platform (UWP) and have it run on a wide range of device families: IOT,… Read More
How do you think about free?If it's about paying with money, then there's no such thing as free. There's only "somebody else pays". If not paying with money there are still othe… Read More
Reserve you Windows 10 upgrade today! It's free. It's easy. No worries.If you see this icon in the notification area (system tray) on your machine then you should click on it. Here's what you can expect when you do. … Read More
What's the point of (where is the value in) Project Astoria and Project Islandwood?Projects "Astoria" and "Islandwood" are "Universal Windows Platform Bridges" that allow you to reuse the code used to build Android and iOS apps to ma… Read More
0 comments:
Post a Comment
I get a lot of comment spam :( - moderation may take a while.