July 11, 2014 at 2:57 am
Hi...
I have an Issue....
Scenario is:
I have an SSIS package which runs macro. Macro opens ie, pull data and create files. And those files again read by SSIS. This all works fine in BIDS or Visual Studio.
Now I deployed that package in integration services catalogs. And create a SQL Agent job. Now excel and ie opens in background due to that Macro is unable to fetch URL. Hence my job does not finish and keep running .
will anyone please suggest on this?
July 11, 2014 at 3:05 am
Two things you have to look out for when you run a package from a SQL Server Agent job:
(1) Interactive components. Things like pop-up messages or user applications will fail.
(2) Permissions. When you run from BIDS, it runs in the context of your Windows login. When it runs as a job, it runs in the context of the SQL Server Agent service account (or proxy account).
You need to take the above into consideration when designing your package.
John
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply