February 22, 2012 at 1:23 pm
My issue is we have an SSIS package which runs in BIDS as well as in Integration Services on the server both under the Agent Account and my domain account and unzips the file. When run as a SQL job it hangs and never finishes. Have tried some logging but all to no avail. We are using remotesigned and have tried several other parameter as the initial thinking is that it was waiting for some user interaction which it does not appear to be. Any insight would be appreciated.
February 23, 2012 at 11:00 am
Why not use a zip task in SSIS to unzip the file instead of Powershell?
Or you could even use an Execute Process Task.
Here is a link that may be helpfull to you. It aslo has script task info in it.
February 23, 2012 at 11:11 am
We are using a Execute Process task and calling powershell from within. Thansk for the link we may have to go this route.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply