Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 709
  • Last Modified:

DTS Migration Error

Hi,
I'm facing Weird kind of DTS Migration Error.

I've created a set of DTS Packages on MS SQL Server 2000, SP4 on Windows 2003, SP1. When this is executed via the GUI Console or via the DTSRun.exe utility it works fine.
But if copy this DTS Packages to other Windows 2003 server running the same version of SQL Server(with patches), it fails to open the DTS package [It gives Unknown error]. On trying to execute using the DTSRun utility it gives Unknown error (Error Code : 80004005).
But if I copy the same package to any other machine running Windows 2000 Server SP4 and SQL Server same version, it does not create any problem and runs fine.

All the packages are created and saved as structured file system object, so that this can be easily migrated from machine to machine.

Please help ASAP.

Thanx in advance.


rgds,
Unni
0
unniks
Asked:
unniks
  • 4
  • 3
  • 2
  • +3
2 Solutions
 
imran_fastCommented:
WHAT IS YOUR DTS PACKAGE DOING?
I DEPENDS LIKE MAY BE IT IS ACCESSING SOME DATABASES OR FILES WHICH ARE NOT ACCESSABLE FROM THAT SERVER.
0
 
unniksAuthor Commented:
Hi imran_fast,

Thanx.

This DTS package is used to download a set of files from the FTP server and load it to the database.

This DTS has full rights. And I don't get errors when I migrate it to any other SQL Servers running on Windows 2000 Servers. I get this kind of error only in machines that has Windows 2003 as the OS. So I feel this has to do something with the OS where the SQL Server has been installed.

Even I can't open the DTS package using the Enterprise Manager Console (this gives unknown error).

Thanx in advance.

rgds,
Unni
0
 
pjdeeCommented:
there used to be a problem where packages created on 2000 would not open in sql7 (or the other way round) unless they had a password

may be nothing to do with it but give it a go.
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
pjdeeCommented:
i realise you are not using sql7 but thought i would mention it just in case.
0
 
unniksAuthor Commented:
Thanx pjdee.

My Development Environment is
OS - Windows 2003 with SP1
SQL Server - MS SQL Server 2000, with SP4


Target Test Environments

Case 1 - Which Failed
OS - Windows 2003 with SP1
SQL Server - MS SQL Server 2000, with SP4


Case 2 - Which Passed
OS - Windows 2000 with SP4
SQL Server - MS SQL Server 2000, with SP4


rgds,
Unni
0
 
J2811Commented:
I believe this is security issue. In Windows 2003, the security is tighter as such somethings might have closed.

I don't have a fixed solution for you but below are pointers you can check that might resolve.

1. Check if the FTP service on the 2003 server is up.
2. Did you use different credential when running the DTS package? For example local administrator of the Win2000 server and local administrator of the Win2003 server. Does both credential have same rights to the SQL 2000 server?
3. Go to Event Viewer on the 2003 server, check Security log and see if you can see any clue there.

Hope this helps.

Regards,
0
 
imran_fastCommented:
<<Even I can't open the DTS package using the Enterprise Manager Console (this gives unknown error).>>

ok can you check one thing

 
on your development environment ie.SQL Server - MS SQL Server 2000, with SP4 open package in design mode and use save as to deploy it to windows 2003 server and then execute the package in windows 2003 server.
0
 
AaronAbendCommented:
If server names are hard coded in the package at the package level, this can happen. Are you logging the results? If you are logging the package results to a named server that is not accessible in the production environment, you could get this problem. Right mouse on the background and check the Logging tab. If there is no logging, this is not the problem. If logging is turned on and the server name there is not available in the production enviornment, it would have the problem you describe.
0
 
unniksAuthor Commented:
Thankyou everybody.

From searching in google I found that this could be of some kind of version problem of the MDAC components. So I used the latest version of Component Checker to determine the versions. It was strange to find that there were some DLLs which were reported as mismatch (this was the same case on both the Windows 2003 Servers - seems some kind of rights issue). So rebooted the server (thank god it was test environment), applied the SQL Server Patch 4 again [Now with the user/password combination having both domain and local administrator rights] and rebooted it again. After this when I ran the component checker the DLLs seems to have been fixed. And now my DTS packages is running.

Thanx a lot.

rgds,
Unni
0
 
Anthony PerkinsCommented:
Great! Now please close the question.
0
 
imran_fastCommented:
Do You still need help?
0
 
unniksAuthor Commented:
No Thanx.
But I don't know how to distribute the points and close the question.
As i could not get the actual pointers to my question from anybody i can't just accept any comment as such, but some pointers prompted me to check for the application of patches on SQL Server (like the security warning by J2811, saving to other machines and try to open it by imran_fast). So I'd like to distribute the points between imran_fast and J2811.

Thanx again


rgds,
Unni


0
 
J2811Commented:
Erm, if you need more help just post specific questions and will help.

As to how to distribute the points, refer below.

Can I split the points?
 
Yes. Scroll down to the bottom of the question, just above the text box, and click the "Split Points" link. Select the radio button of the comment who you want to Accept as the Accepted Answer. Only one button can be selected. Set the point value (a text box above the comment) of how much you want this person to receive of the points. Then set the point values for each of the experts comments to whom you want to allocate points and these will be considered Assisted Answers in helping you resolve the issue. Double check your information and then click the Submit button at the bottom of the page. One note: the total points of the splits must equal the amount you asked the question for itself, and no person can receive fewer than 20 points.
 
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

  • 4
  • 3
  • 2
  • +3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now