May 27, 2010 at 2:14 pm
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.
May 31, 2010 at 5:00 am
In the following link, install SQLServer2005_BC.msi hope that will help you.
Nag.
Nag
------------------------------------------------
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537
May 31, 2010 at 6:15 am
This was removed by the editor as SPAM
June 3, 2010 at 11:52 pm
June 4, 2010 at 8:48 am
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
April 19, 2013 at 6:39 am
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
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply