Error Executing SQL DTS package through a Batch File
Posted on 2007-03-28
Error Executing the Batch file. Please see below error:
Error: -2147467259 (80004005); Provider Error: 17 (11)
Error string: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exi
st or access denied.
Error source: Microsoft OLE DB Provider for SQL Server
Help context: 0
I am executing a DTS Package from a Batch file which I need to schedule through Task Scheduler.
When I run the package from SQL Server it runs fine but when I execuet it through a batch file I get the following error. Please see bwlow for the Batch File settings:
DTSRUN /S CHAMPION /E /N "ClearNotification"
CHAMPION = Server name
/E = Trusted Connection
/N = DTS Package name
The package contains simple T-SQL statements to delete contents of a table with respect to the time.
The connection for the SQL Server 2000 is WINNT Authentication.
Any help regrading this appeciated. Let me know what is the mistake I am doing?