CODEWITHSUNDEEP
sql-server-2005ssis
Saif Khan
Saif Khan

Reputation: 18792

I Need Assistance with executing an SSIS package

I've tried with this for over 48 hours and no luck. I then create a simple package, one FTP task to download text files. I deployed the package using the option "SQL Server Deployment". I see the package in SSIS but when I try to run from command line with the command

dtexec /ser svrprod05 /sq Package

I get the error

Microsoft (R) SQL Server Execute Package Utility
Version 9.00.3042.00 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.

Started:  10:56:39 PM
Could not load package "Package" because of error 0xC0014062.
Description: The LoadFromSQLServer method has encountered OLE DB error code 0x80
004005 (Login timeout expired).  The SQL statement that was issued has failed.
Source:
Started:  10:56:39 PM
Finished: 10:56:55 PM
Elapsed:  15.625 seconds

I tried passing a username and password of the following

1. Local Administrator
2. Domain Administrator
3. Ent Administrator
4. SQL Server SA

My original objective is mentioned here. I don't know what else to try.

Upvotes: 3

Views: 1491

Answers (1)

JBrooks
JBrooks

Reputation: 10013

In my view SSIS is programming - every time something needs to be done in SSIS in our company a programmer is called to do it.
Here are a few things to try.

Try 1: Add 127.0.0.1 crl.microsoft.com to the hosts file on the server.

Try 2: providing the db_dtsoperator role to the executing user

Try 3: Make sure you are not using the 32 bit version of DTExec on a 62 bit OS.

Upvotes: 1

Related Questions