dbTalk Databases Forums  

Syntax error or access violation (Error again appeard)

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Syntax error or access violation (Error again appeard) in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
J-T
 
Posts: n/a

Default Syntax error or access violation (Error again appeard) - 05-30-2005 , 02:33 PM






I have been given the Administrator Role (in our server).In our server there
are two databases.I'm in Public role for both databses .My DTS package works
in one database in other database it gives me this error :

Step 'DTSStep_DTSDataPumpTask_1' failed
Step Error Source: Microsoft OLE DB Provider for SQL Server
Step Error Description:Syntax error or access violation
Step Error code: 80074005
Step Error Help File:
Step Error Help Context ID:0
Step Execution Started: 5/30/2005 11:40:46 AM
Step Execution Completed: 5/30/2005 11:40:46 AM
Total Step Execution Time: 0.157 seconds
Progress count in Step: 0
Step 'DTSStep_DTSExecuteSQLTask_1' was not executed




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.