you can set configuration file at the job level.

Steps:

•Create configuration files for the connections used in SSIS package.

•Disable the configuration at SSIS package, deploy it.

•Put the configuration file in the...

Alternatively, we can capture the job id of that subscription.

we can trigger it as a job in Execute Sql Task.

E.g. : Execute Msdb..sp_start_job '4055734B-F633-425B-AA91-062FFE751A04'

Hi All,

I agree with you that parset encounters the same statement twice and hence it errors.

But in my case, am creating table structure dynamically by "select * into #temp"

So, i...

Thanks for your reply.

I too believe the same, it assumes the table gets created in the first block itself even though it does not get executed.

Can someone help me how...