Executing SSIS package

Question

I posted my question on stackoverflow but I was told that it might be better off here. I have a problem executing my SSI package from command line. I created the package via SQL Server Business Intelligence Studio while logged in as a domain administrator.

Answer 1

A quick search returns plenty of possible causes for this error, such as this: SSIS Error from DTEXEC: Login timeout expired. Have you worked through these already?

Answer 2

Another thing can you go to Start->Control Panel->Administrative Tools->Services and ensure you have a listing for SQL Server Integration Services.

If not you will need to go to Control Panel->Add/Remove Programs->SQL Server and change the options and ensure you have installed SSIS.

If the SSIS service is not installed you cannot run packages correctly and will get an error msg.

This may not be your particular problem but may just be as simple as this.

Update 1:

Can you confirm some of the following:

1. You have deleted and redeployed the package to the server with your credentials?
2. You have run the package successfully using the file option?

Also you could try the following command on the SQL server to reset the owner of the DTS package:

sp_reassign_dtspackageowner [@name =] 'name', [@id =] 'id', [@newloginname =] 'newloginname'

Answer 3

Look to see if it works when you use escalated privileges to run the Command Prompt. Ie, right-click on your Command Prompt shortcut and say "Run as administrator"

Answer 4

Are you trying to log into the SQL Server via TCP or named pipes? Are you able to use sqlcmd from the server's console?

Answer 5

On first glance this looks to be an authentication issue.

I would first ensure that you are using the correct command line syntax for the dtsexec utility. Consult the following Microsoft reference for full details.

http://msdn.microsoft.com/en-us/library/ms162810.aspx