Error Executing SQL DTS package through a Batch File

Error Executing the Batch file.  Please see below error:
DTSRun:  Loading...

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 file:
   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?

hariprasadereAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

rboyd56Commented:
Does this command run from the command line?

Also is CHAMPION the name of the machine you are running the job on?

If not, what account is the task scheduler running under. If it is a local account it may not have the necessary permissions on the network to access a remote SQl Server.
0
hariprasadereAuthor Commented:
I get that error when I ran it from Comand Line

CHAMPION is the Machine name where this job resides and runs from. It should not be a network permission issue because I am not running it over the network I am running it on the Server itself.

I am thinking that it might be SQL Server login problem.
0
rboyd56Commented:
If it were a SQL Server login problem you would get something like login failed for user....

The error you are getting indicates that the SQL Server cannot be found when the package runs. Is SQL Server a default instance or is it a named instance?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

hariprasadereAuthor Commented:
It is a Default Instance
0
rboyd56Commented:
When you run this from Enterprise Manager and it succeds are you running it on the server itself or on a client machine? If it is a client machine, do this:

On the server machine, open the SQL Server Client Network Utility
Go to the alias tab
See if there is an alias for CHAMPION
If there is rename it and try DTSRUN again
If there is not an alias, create one with these properties:
Server alias: CHAMPION
Server name: IP address of server
Network library: TCP/IP
Leave Dynamically determine port checked.

Click OK and try the DTSRUN command again
0
hariprasadereAuthor Commented:
tried and Tried and finally I got a solution for myself. Though it is running locally on the machine I still had to enter the domain qualifier. eg

DTSRUN /S machinename.yourdomain.com /E /N "DTS PACKAGE NAME"
I guess I would give  rboyd56: credit for this atleast he made think on this issue.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.