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
Moving sql 7.0 to to sql 2008
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