Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Migrating DTS Packages from SQL 2000 to 2008 Expand / Collapse
Author
Message
Posted Thursday, May 27, 2010 2:14 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, November 21, 2014 3:12 AM
Points: 56, Visits: 194
Hi All,

I am looking to migrate the SQL 2000 applications to SQL Server 2008
and the OS will be Windows 2003 Server.
the server where we run a lot of DTS's. I understand that SQL 2008
requires some add-ons to be downloaded and installed to make DTS's
work.

Can you please let me know which type of add-ons I need to download it? and where can I get that?

Thanks in advance,
Vamsi.
Post #929289
Posted Monday, May 31, 2010 5:00 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, November 17, 2014 9:39 PM
Points: 111, Visits: 496
In the following link, install SQLServer2005_BC.msi hope that will help you.

http://www.microsoft.com/downloads/details.aspx?FamilyID=c6c3e9ef-ba29-4a43-8d69-a2bed18fe73c&displaylang=en#QuickInfoContainer

Nag.


Nag
------------------------------------------------
How to get the best help on a forum

http://www.sqlservercentral.com/articles/Best+Practices/61537
Post #930325
Posted Monday, May 31, 2010 6:15 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 10:03 AM
Points: 4,111, Visits: 5,479
It will be worth your while to upgrate the existing DTS packages to SSIS.
DTS is not natively supported in SQL2008.


____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #930341
Posted Thursday, June 3, 2010 11:52 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, September 22, 2014 4:29 PM
Points: 871, Visits: 287
Vamshi,

I had faced a similar upgrade.

Let me put it to you simply, YOU WILL NEED TO RE-WRITE ALL DTS PACKAGES IN SSIS (SQL 2008)

that is ofcotre if you want a successful migration.

Soory but there is no easy way out of this one.



Kindest Regards,



Post #932588
Posted Friday, June 4, 2010 8:48 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 11:34 AM
Points: 4,064, Visits: 5,366
You will need to convert the DTS packages to SSIS eventually, but it's perfectly acceptable to run them in SQL 2008 and convert them over time. We have plenty of DTS packages running fine in SQL 2005 and SQL 2008 while we rewrite them one at a time. Download and install the components linked in Nag's post after installing sQL 2008, then migrate the DTS packages.



Greg
Post #932871
Posted Friday, April 19, 2013 6:39 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, September 18, 2014 1:48 PM
Points: 3, Visits: 15
Able to open and migrated in sql2008 r2 - x694 thru designer 2000 but during first time when we open it gives SQLDMO.dll has not registered and when we click ok able to get thru.
Wants to make sure its something needs to conceren or fix
Post #1444354
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse