Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Help! I have this error and need some help

Author  Topic 

jnunley
Starting Member

1 Post

Posted - 2007-05-10 : 17:12:04
CardioLab Critical Error

05/10 02:45 PM

An error has occurred during the review of the patient study file. Details of this error are below:

Step 'DTSStep_DTSExecuteSQLTask_4' Failed
Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description: Unspecified error
(Microsoft OLE DB Provider for SQL Server (80004005) : Cannot open database requested in login 'Clab_Optical'. Login Fails.)
Step Error Code: 80074005
Step Error Help File: sqldts.hlp
Step Error Help Context ID:1100



I noted that someone at this link
http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=36150
was having the same issues. If anyone could help resolve this it would be greatly appreciated.

niki_west
Starting Member

2 Posts

Posted - 2007-05-11 : 07:02:17
I think your problem has to do with rights. Check that the user has sufficient rights and that the connection string is correct.
Go to Top of Page
   

- Advertisement -