Quick Description: in Powershell, shell.application.copyhere works in a script called by SSIS when executed from SQL Server Data Tools. It does not work when executed from the SSIS catalog when deployed to SSIS/SQL Server.
Problem:
Do not try to use shell.application copyhere as a way of unzipping a file in a
powershell script called by SSIS. It will work in the IDE, it will work
executing from the Integration services catalog, and it will fail spectacularly
as a sqlAgent job. Apparently, copyhere only works when called as a script for
regular files, and only
works for zip files when it feels like it (I'd argue that executing from the
SSIS catalog isn't exactly interactive, but apparently, I'd be wrong).
Friday, May 8, 2015
Powershell copyhere Behavior Differs between Integrated Development Environment and Integration Services Catalog
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment