SSIS - it's magic really

Tech-Archive recommends: Fix windows errors by optimizing your registry

Currently trying to get my head around this SSIS infrastructure which is a
big shock after coming from DTS. I appreciate, as a developer, that it's
powerful but there's a pretty steep learning curve!

I've used the Copy Database wizard in SQL management studio to copy four
databases between servers. It's worked fine but I'm interested in how it
works. I loaded up business intelligence dev studio (daft name) and loaded
the package that had been saved onto SQL server. I expected to see some kind
of individual tasks like create database, move data but nope - one single
big package. I can see where the four databases are defined (database
objects) but how is all of this actually working?? When it's run, there's
lot of Information: prompts but I can't find where these steps are defined
in the task.

Even looking at the XML doesn't make much sense.

My suspicion is that the Copy database wizard in SQL Management Studio has
created a rather magic DTS package that isn't actually a native kind of SSIS
tasks.

Anyone shed any light on this?

Cheers, Rob.


.

Quantcast