You might not consider people from India I guess

I don't find logging in option settting for DTSRUN yes it allows Server option which will not set the logging( Steps Run status to SQL Server&nbsp

I mean by package property is exclusively for the logging option which we cannot set at run time. Yes /S option is for server or server instance on which the Package is...

Anyone deployed DTS packages on instance of SQL . I welcome any help.

Johnson

Thank you for the response.

Yea that is what I tried first. I think we cannot change the logging in option once the package started. I have solve the issue temporarly...

Another way you could create 2 connection one to server1 and other 1 to server 2 and update what ever you want..

Hi

Using the Disconnect Edit option you could change the name etc. of the tasks. So change the name and see how you find it.

Johnson

Use global variable for Keeping your run time file name. Include Dynamic Propery Task for setting the Destination table name. And set a workflow so as to do the actual task only after...

You could use Data Driven queries also and call an SP Which will add multiple records in the destination based on each row. In the example you have given you...

Try Setting the Global variable value using Dynamic property.

This may solve the issue. I am not sure whether you already tried it.

Johnson

Hi

I have tried it this way and the DATABASE was in SQL Server

In your production database flag the records which are modified or inserted using Triggers/ someother way. And fetch...

Here you have an alternative. I am not sure if it help you

create a variable to store the dtsrun command with paramters

 SET @SQLCMD = 'DTSRUN /F "' + @PKG_PATH +...