SSIS - Execute task works quickly but execute package works as lifelong

1
votes

I installed the most recent version of visual studio and SSDT (so all settings are default) and I created a simple package which works completely fine in less than two seconds when I execute it by right click and then press "execute task".

However when I right-click on package and then press "execute package" it takes more than three minutes and in progress no error.

How can I resolve this problem? i also cannot connect my SSIS when i open it "Run As Administrator". Both SSMS and SQL Server are 17 and on the same machine.

1
sql-serverssis
Are you literally out of memory on your local machine? Try closing some programs (browsers...). – Jacob H
No, memory is fine and in my package there is only a single task which could be run in less than a second – Anfi
Which version of visual studio did you install? – SQLBobScot
15.9.6 which the latest version – Anfi
Have you seen this post - sqlservercentral.com/Forums/692952/… ? – SQLBobScot

1 Answers

1
votes

SSIS usually takes a bit longer than 1 sec to run a package as it has to do a full validation phase first.

Also -You might have multiple tasks in your package (not necessarily connected)... When you "execute package" - all tasks are ran but when you "execute task" then only the selected task is being ran.

I would not worry too much about this warning message. It is not strictly related to your issue as I have seen it lots of times and usually just filter it out as it only appears via VS. You can demonstrate this by opening up a cmd shell and running the package via DTEXEC.exe. EG:

C:\Program Files (x86)\Microsoft Visual Studio\2017\Professional>dtexec.exe
Microsoft (R) SQL Server Execute Package Utility
Version 12.0.4100.1 for 64-bit
Copyright (C) Microsoft Corporation. All rights reserved.

pass in your saved ssis package and you will see the output of the package execution.