SSIS package delay (1 Viewer)

neoklis

Registered User.
Local time
Today, 14:31
Joined
Mar 12, 2007
Messages
80
When I exectute from cmd prompt (dtexec) an SSIS package on a local server, it takes about a few seconds to complete. When I execute the same package from a remote machine it takes about one minute. Any clues why is this happening;

Thank you
 

SQL_Hell

SQL Server DBA
Local time
Today, 12:31
Joined
Dec 4, 2003
Messages
1,360
Hi there,

I haven't had alot of dealing with SSIS packages running slow, but I will try to help anyway. What is the package doing exactly?
 

neoklis

Registered User.
Local time
Today, 14:31
Joined
Mar 12, 2007
Messages
80
thanks man for your reply. The package i run imports text file to Sql Server. As i said, when i execute it on local server it is executed really fast, but when i do the same from a remote computer there is a delay.. Looking for info on net i found the above.

http://www.cubido.at/Blog/tabid/176/EntryID/20/Default.aspx

It demands a restart so i'll give it a try when i 'll be ready.

thanks in advance
 

Users who are viewing this thread

Top Bottom