August 17, 2009 at 10:27 pm
im getting error while executing dts package through job
Message
Executed as user: EDEMUMEXTDBS005\SYSTEM. ... Delete from Table [CrossBr].[ed2user].[Client_master] Step DTSRun OnStart: Delete from Table [CrossBr].[ed2user].[Holding] Step DTSRun OnStart: Delete from Table [CrossBr].[ed2user].[Rate_master] Step DTSRun OnStart: Delete from Table [CrossBr].[ed2user].[ledger] Step DTSRun OnFinish: Delete from Table [CrossBr].[ed2user].[Client_master] Step DTSRun OnStart: Copy Data from Client_master to [CrossBr].[ed2user].[Client_master] Step DTSRun OnFinish: Delete from Table [CrossBr].[ed2user].[ledger] Step DTSRun OnError: Copy Data from Client_master to [CrossBr].[ed2user].[Client_master] Step, Error = -2147467259 (80004005) Error string: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 Error Detail Records: Error: -2147467259 (80004005); Provider Error: 17 ... Process Exit Code 6. The step failed.
but when i execute DTS package it executes properly
what is the soln for this?
Sanket Ahir
Don't run behind the success, Try to be eligible & success will run behind u......
August 21, 2009 at 4:22 am
This is your problem: SQL Server does not exist or access denied.
When you run the package manually it runs under your security context.
When you schedule it it will run either under the security context of the SQL Agent account or the account you use in the "Run as" option.
[font="Verdana"]Markus Bohse[/font]
August 21, 2009 at 4:27 am
Hi,
check your data sources and linked servers once.
KSB.
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply