Post reply

Please Help Solve Why SSIS Package Fails When Run as SQL Agent Job

  • May 9, 2015 at 12:48 pm

    #1796818

    http://www.sqlserverbox.com/ssis-package-in-sql-server-agent-job-fails.html

    http://sqlism.blogspot.com/2012/08/ssis-package-in-sql-server-agent-job.html

    SSIS Package in SQL Server Agent Job Fails

    Error:

    Argument "xyz" for option "connection" is not valid. The command line parameters are invalid. The step failed.

    Solution:

    If your SQL Server is 64 bit

    In SQL Server JOB-->Properties-->Steps--->

    In the Execution Option Tab -- Check "Use 32 bit runtime"

    In the Data Sources Tab -- Uncheck the checkboxes of the connection managers if already checked.

    Schedule the Job and run it.

  • May 11, 2015 at 8:09 am

    #1796963

    fellmeth (1/19/2011)

    Thanks, Grasshopper. I'd forgotten about this post. I'll keep your solution in mind for the future. What I discovered a few weeks ago was that we'd been copying existing working packages and then modifying them for the new server. SSIS really does not like this copying and modifying. When we finally gave that up and rebuilt the packages from scratch, all the problems we were having vanished.

    Some things change. Some things never should. 😎

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply