View Full Version : SSIS package delay


neoklis
03-17-2008, 06:14 AM
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
03-18-2008, 01:58 AM
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
03-18-2008, 02:16 AM
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