I don't have a copy of the package available now, but do check out the images I posted in one of the replies to this thread. Along with the original...

Hi Kiran

I don't have the code separately I'm afraid. The thread should contain all the information you need though. It really doesn't take long to create, since there are only...

This script only works for owners that are specifically listed in syslogins. However, you can easily have the case, for example, where the owner of a job is a network...

If they're all SQL Server instances then you can create Linked Servers on the Destination server(s) to the Source server(s). Once you've done that, if the destination server is always...

SSIS can still be used easily, since you're just using it to perform a loop for you that executes a dynamic SQL statement.

In your SSIS package you should have at...

Amtzva

This is all specific to SSIS which didn't appear until SQL Server 2005. In SQL Server 2000 you can use DTS and make things dynamic too, but requires a completely...

I have attached some images that may help.

Hi

You won't be able to use the Bulk Insert Task because that only applies to files and not database connections. So if you want to use the Execute SQL task,...

We had a similar problem, although it was using text files and other ODBC connections as the source. I also looked through the web, and unfortunately as far as i...