Hi,

When we deploy package to run by SQL Server Job, there is tab "Data Sources" that shows connectionstring defined in the package. It also has checkbox.

The package runs fine if I don't check that checkbox but it doesn't if its checked.

What is the use of this tab and checkbox if it breaks thing?

Thanks,

I'm sorry, I m not following.

I tried to use but it didn't work. I checked it and when I tried to run package, it gave me error

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

I unchecked it, then the package ran.

And you also said "Obviously it becomes an invalid connection parameter for the package to run with."