Hi Naveed,
I am working on a similar issue. There are 2 SQL Server databases. I need to transfer all the data from tables in source DB to target DB tables after truncating the target tables. I did not setup LinkedServer because I do not need to do. I followed every thing. But what is confusing to me is Step 5. How can write a query like this in it.
INSERT INTO [target db]..[target table] select * from [source db]..[source table]
Do I need to create a connectionstring variable for source? what default value I can give it to this variable?
Do I need to select the target connection in the "connection" in SQL Statement section of the "Execute SQL Task Editior"?
Thanks
Sundar