1. Created the packge1.SSISDeploymentManifest

2. Copied the files from local box to production box folder. C:/SSIS_Deploy/

a.packge1.dtsx

...

I got it resolved.

Here are the steps.

1. Created the packge1.SSISDeploymentManifest

2. Copied the files from local box to production box folder. C:/SSIS_Deploy/

...

I am using SQL server 2008 Bids.

1. Please tell me how to deploy an SSIS package with dtsconfig file on prod SQL server.

a) as per...

Can DtUtil be used to install the packages with config files. Please let me know the Syntax for that.

I copied all to the Production box and using Sql server deploy. It is SQL server 2008 and alos the BIDs is alos 2008.

Yes you got it right. These are the logical steps.

Thaks again for your time.

In the above example the value to compare with range value is the diffference between Source tax_val and Destination tax_val.

that is the only Source_tax_val = 100,...

From source file :The row for a tax record has Tax_val =100 for city xyz.

In destination table: For the same city xyz from table Tax_val = 250.

For thae...

Sorry before I finished my logical steps I pressed post..

But here are the steps.

Here are the logical step1.

1.Source is Tax File

2. Destination Tax_tb

From source get the row.

If the...

Here are the logical step1.

1.Source is Tax File

2. Destination Tax_tb

From source get the row.

If the row exists in Tax_tb

find the...

Thanks for quick reply. I am working on one SSIS package right now and have the situation where the insert is very simpele , that is if it doesn't...

The properties FailPackageOnFailure and FailPArentOnFailure are kept False for a reason in my package . That is, if any task fails I am taking some action and the ForEach loop...

Thanks for your reply. I can get to the OnError but How to terminate the execution of the package. The container of all these tasks is a ForEach loop.