Archive for March 8th, 2018

Option “/” is not valid. The command line parameters are invalid. The step failed.

March 8th, 2018

When running a SQL Server Job that has a step that executes an SSIS package, you may receive the following cryptic error.

Option "/" is not valid. The command line parameters are invalid. The step failed.

This is actually a sort of generic error that basically means executing the package failed for some reason. To get the real reason, open the job step properties, go to the Advanced page and check the option "Include step output in history". Suddenly, the cryptic error will disappear and the real reason for the error will be logged in the Job History.

Posted in Sql, SSIS | Comments (0)

SEO Powered by Platinum SEO from Techblissonline