Viewing 9 posts - 1 through 9 (of 9 total)
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...
August 24, 2011 at 5:24 am
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...
July 8, 2010 at 4:55 pm
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...
June 7, 2010 at 8:49 am
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...
October 22, 2009 at 4:29 pm
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...
October 22, 2009 at 2:39 am
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...
January 29, 2009 at 4:06 pm
I have attached some images that may help.
January 29, 2009 at 4:57 am
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,...
January 5, 2009 at 5:52 am
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...
January 2, 2009 at 4:03 am
Viewing 9 posts - 1 through 9 (of 9 total)