<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
Administering
»
DTS package import
18 posts, Page 1 of 2
1
2
»»
DTS package import
Rate Topic
Display Mode
Topic Options
Author
Message
charipg
charipg
Posted Friday, December 04, 2009 11:38 AM
Old Hand
Group: General Forum Members
Last Login: Thursday, May 16, 2013 12:43 AM
Points: 378,
Visits: 897
Hi,
I need to import 150 DTS packages in sqlserver2005.Importing one by one shouls take lot of time.
how to import all these packages at a time.
can you please provide the query.
Thanks in advance.
Post #829138
SQLRNNR
SQLRNNR
Posted Friday, December 04, 2009 5:28 PM
SSCoach
Group: General Forum Members
Last Login: Yesterday @ 1:07 PM
Points: 18,733,
Visits: 12,332
Since it is not guaranteed that all of the packages will properly convert, you will need to investigate the packages at the individual level. Are you sure that you will even need all 150 packages? Are any of them deprecated?
Hunker down and just start doing it.
Jason
AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008
SQL RNNR
Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #829314
charipg
charipg
Posted Friday, December 04, 2009 6:31 PM
Old Hand
Group: General Forum Members
Last Login: Thursday, May 16, 2013 12:43 AM
Points: 378,
Visits: 897
yes i need all the packages.
Post #829323
homebrew01
homebrew01
Posted Friday, December 04, 2009 10:43 PM
SSCrazy
Group: General Forum Members
Last Login: Yesterday @ 11:39 AM
Points: 2,551,
Visits: 7,205
I think I used "DTSBackup2000" tool. Free download, and pushed 100+ DTS packages from 2000 to 2005 with just a few clicks.
Post #829348
SQLRNNR
SQLRNNR
Posted Saturday, December 05, 2009 10:22 AM
SSCoach
Group: General Forum Members
Last Login: Yesterday @ 1:07 PM
Points: 18,733,
Visits: 12,332
Yes, there are tools available. With our dts packages we see about a 50% conversion failure rate and have to manually do the conversion anyway.
One such tool that can do conversions
http://www.pragmaticworks.com/products/Business-Intelligence/dtsxchange/
ssis tutorial
http://bi-polar23.blogspot.com/2008/03/new-to-ssis-start-here.html
Conversion Article
http://www.sqlmag.com/Article/ArticleID/94095/sql_server_94095.html
Jason
AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008
SQL RNNR
Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #829422
homebrew01
homebrew01
Posted Saturday, December 05, 2009 12:12 PM
SSCrazy
Group: General Forum Members
Last Login: Yesterday @ 11:39 AM
Points: 2,551,
Visits: 7,205
Are you wanting to import and convert to SSIS at the same time ? The tool I referred to just imports them as DTS running in Legacy mode.
Post #829433
sureshdeenu
sureshdeenu
Posted Saturday, December 05, 2009 8:23 PM
SSC Rookie
Group: General Forum Members
Last Login: Sunday, April 08, 2012 10:08 PM
Points: 37,
Visits: 117
Hi I am trying to copy DTS Packages from sql 2000 to 2005? what is the process i can do it?
Post #829484
homebrew01
homebrew01
Posted Sunday, December 06, 2009 8:23 AM
SSCrazy
Group: General Forum Members
Last Login: Yesterday @ 11:39 AM
Points: 2,551,
Visits: 7,205
sureshdeenu (12/5/2009)
Hi I am trying to copy DTS Packages from sql 2000 to 2005? what is the process i can do it?
As I recall, you can export & import them one at a time, or try the tools mentioned above.
Post #829519
sureshdeenu
sureshdeenu
Posted Sunday, December 06, 2009 4:01 PM
SSC Rookie
Group: General Forum Members
Last Login: Sunday, April 08, 2012 10:08 PM
Points: 37,
Visits: 117
can u pls give me step by step to copy the packages from sql 2000 to 2005
Post #829567
sureshdeenu
sureshdeenu
Posted Sunday, December 06, 2009 4:09 PM
SSC Rookie
Group: General Forum Members
Last Login: Sunday, April 08, 2012 10:08 PM
Points: 37,
Visits: 117
I tried to move each dts package, rt. click on it-> Open -> Save as storagefile on source server(2000)
On the destination server(2005), rt click on DTS package folder-> Import -> select the dts package storage file from the shared folder. But i couldnt open the package in destination server. wht is the best sollution for me?
Post #829571
« Prev Topic
|
Next Topic »
18 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
