Home Forums SQL Server 7,2000 SQL Server Agent Please Help Solve Why SSIS Package Fails When Run as SQL Agent Job RE: Please Help Solve Why SSIS Package Fails When Run as SQL Agent Job

  • Hope this link helps you

    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