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,

Once you check this on it adds a line to the command line (in the command line tab) with /CONNECTION specified.

Obviously it becomes an invalid connection parameter for the package to run with.

You can use when you want to override it. The same functionality is exposed through the DTExecUI utility

Hi Me.Saqib,

In Job Step properties, if we select one connection under the Data Sources tab, it resulted in the connections to be explicitly specified in the command line which we can check from the Command line tab. If one data source has a connection string with attributes separated by semi-colons, an escape character "\" will be added to the /CONNECTION parameter of the command line automatically which will cause the command to become invalid. So, you need to switch to the Command line tab, select the Edit the command line manually option, and modify the command line to remove the extra escape character and double quotes.

Regards,

Ok, it worked now.

So is it a bug while generating the command?

Hi Me.Saqib,

Glad to hear that the issue is resolved. Its a known issue. If you have concerns about it, I would suggest you submitting a feedback at https://connect.microsoft.com/sql.

Connect site is a connection point between you and Microsoft, and ultimately the larger community. Your feedback enables Microsoft to make software and services the best that they can be, and you can learn about and contribute to exciting projects.

Regards,

I went back again to check how the command line tab look like and it appears that that escape character along with quote is back but not causing the job to fail.

Totally confusing ....