RE: Transformation service export
From: Michael Cheng [MSFT] (v-mingqc_at_online.microsoft.com)
Date: 10/28/04
- Next message: Robin Martin via SQLMonster.com: "Single-Threading / Performance issues"
- Previous message: netspam_at_shic.co.uk: "Re: Left Outer Join and CONTAINS - performance question..."
- In reply to: Sunny: "RE: Transformation service export"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 28 Oct 2004 10:04:03 GMT
Hi Sunny,
First of all, make sure you have upgraded to the latest service pack, SQL
Server 2000 Service Pack 3a. As there is an known issue exists in the
previous edition
FIX: DTSRUN Fails with Errors If the Arguments Have Multiple Space
Characters Between Them
http://support.microsoft.com/?id=308801
Secondly, I am not sure the DTS package design, however, I think you must
make sure every OLE DB Provider for SQL Server connects fine. From the
error message "SQL Server does not exist or access denied", it is entirely
possible that it recognize the wrong SQL Server so that please change the
(local) to the computer name directly, which will clarify the settings.
Thirdly, here is some ideas for further troubleshooting this issue
1. make sure the account has sufficient permissions to run the DTS package
2. make sure the SQL Server Agent startup account has the sufficient
permissions to run the package
3. Execute the Tasks separately to see which one fails
Thank you for your patience and corperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---------------------------------------------------------------
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
- Next message: Robin Martin via SQLMonster.com: "Single-Threading / Performance issues"
- Previous message: netspam_at_shic.co.uk: "Re: Left Outer Join and CONTAINS - performance question..."
- In reply to: Sunny: "RE: Transformation service export"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
