Home » Admin »sqlserverpedia-syndication »SSC »SSIS »Tech and Learning » Currently Reading:

Hit Fast Forward: Converting and deploying DTS packages

September 18, 2013 Admin, sqlserverpedia-syndication, SSC, SSIS, Tech and Learning No Comments

This one is just a quick shout-out to Pragmatic Works, and to Sean.

Pragmatic Works made DTS xChange, which I used to convert about 40 SQL Server 2000 DTS packages to SSIS. Seriously, I just had to run the thing, and update a few data connections.  YMMV, of course, but I was really happy not to have to do all that by hand.

Sean made his Deploying SSIS Packages with Powershell session, posted the video and the code, and reminded me of it when I whined about mentioned having to deploy the 40+ new packages by hand. Because, you know, your choices are either (A) individually add each and every package in Management Studio, or (B) individually add each and every package to a BIDS project, and then deploy that as a set.  Fun, right? But, one of Sean’s Powershell scripts just loops through all the DTSX files in a directory, and deploys them to the server.

So. Freaking. Easy. And that’s what I like: things that make ridiculously tedious tasks into ridiculously easy tasks.

Happy days,
Jen McCown

http://www.MidnightDBA.com/Jen

Comment on this Article:







Release Date: Minion by MidnightDBA

Just 20 hours 24 minutes 7 seconds until we release Minion Redindex: index maintenance done right!

MidnightSQL Consulting

Need help? Got an emergency? Write us at Support@MidnightDBA.com!

We can schedule time to help with your backup/restore issues, high availability and disaster recovery setup, performance problems, and a great deal more. Very often, we're even available on the moment for downtime issues and emergencies.

For more information about MidnightSQL consulting, email us or check out www.MidnightSQL.com. Happy days!

Where are We?

November 3-7: PASS Summit, Seattle, WA

PASS Summit: Jen is presenting How to Interview a DBA: A Panel Debate on Thursday 11/6 1:30pm, room 401 (along with Adam Machanic, Sean McCown, Bob Pusateri, and Michelle Ufford).

PASS Summit: Sean is presenting Performance Tuning Your Backups on Wednesday 11/5 3:00pm, room 602-604.

December 11: Presenting "Powershell Cmdlets.." at Alaska SQL Server User Group

January 30: "Become an Enterprise DBA" precon at Austin SQL Saturday

Blog Posts by Category

DBAs@Midnight

How to Eat Pop-tarts
Watch DBAs@Midnight live on Fridays,m 11pm Central time

The best database career advice you’ve never heard!

DBARoadmap.com

The DBA Roadmap Seminar is 7 MP3 tracks (over 5 hours!) of insider guidance on your database career. We'll teach you how and what to study as a DBA, weigh in on controversial resume debates, teach you to recognize a worthy recruiter, and discuss the new professionalism of interviews. Also some bonus materials, PDF companion guides, and really spiffy intro music!

Once your $99 PayPal payment is submitted, you'll get the download link in e-mail! (Download is a 370Mb ZIP file.)

Become a DBA. Become a BETTER DBA. Use the Roadmap.

Visit www.DBARoadmap.com for info, forums, and more!

Add to Cart View Cart

Cunningham’s Law

"The best way to get the right answer on the Internet is not to ask a question, it's to post the wrong answer."
Relevant: http://xkcd.com/386/