Moving sql 7.0 to to sql 2008

Can some kindly help me how to move sql 7.0 to sql 2008R2. We have 10 databases and there are 15 DTS Packages but when I script out the jobs I found that only one job is calling only two packages and seem like other are inactive. Can someone help me to find out that these DTS Package are running or idle. Also step how to move everyone with breaking anything. Thanks

April 27th, 2015 3:09pm

Follow this link for upgrading your dts packages. Check DTS packages log for the Execution history to verify they recently ran or not. It is not simple to say move everything without breaking. Better open that two packages and check whether they are calling other dts packages too. 

Migrating DTS Packages to Integration Services

https://msdn.microsoft.com/en-us/library/bb500440%28v=sql.105%29.aspx


Free Windows Admin Tool Kit Click here and download it now
April 27th, 2015 4:36pm

Lookup the job history, then you can see when the jobs where running the last time.
April 28th, 2015 3:30am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics