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.

Hi Rob,
I understand that you would like to know how the SSIS package generated by
Copy Database Wizard in SSMS is implemented.
If I have misunderstood, please let me know.

During the Copy Database Wizard, you can find two options:
1. Use the detach and attach method
2. Use the SQL Management Object model (SMO assemblies)
So the SSIS package implement the database copying via either of the two
ways, however the detail code of the implementation is undocumented.

The generated package is indeed a native kind of SSIS package just
containing a custom task. You may refer to this article in BOL:
Using the Copy Database Wizard
http://msdn.microsoft.com/en-us/library/ms188664.aspx
There is a section which name is "Copy Database Wizard SQL Server
Integration Services Custom Tasks". The name indicates that it is actually
a custom task.

You can also develop a custom task to implement the database copying
function if you learn some knowledge of SSIS Custom Task.
I would like to provide the following links for your reference:
Extending Packages with Custom Objects
http://technet.microsoft.com/en-us/l.../ms345161.aspx
Creating a Custom Task
http://msdn.microsoft.com/en-us/library/ms345156.aspx
Coding a Custom Task
http://technet.microsoft.com/it-it/l.../ms135896.aspx
Developing a Custom Task
http://technet.microsoft.com/en-us/l.../ms135965.aspx
Connecting to Data Sources in a Custom Task
http://technet.microsoft.com/it-it/l.../ms135948.aspx
Adding Support for Debugging in a Custom Task
http://msdn.microsoft.com/en-us/library/ms136129.aspx
Developing a User Interface for a Custom Task
http://technet.microsoft.com/en-us/l.../ms136080.aspx

Regarding SMO, you may refer to:
SQL Server Management Objects (SMO)
http://msdn.microsoft.com/en-us/library/ms162169.aspx

Hope this gives you some hints. If you have any other questions or
concerns, please feel free to let me know.

Best regards,
Charles Wang
Microsoft Online Community Support
================================================== =========
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg (AT) microsoft (DOT) com.
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for
non-urgent issues where an initial response from the community
or a Microsoft Support Engineer within 1 business day is acceptable.
Please note that each follow up response may take approximately
2 business days as the support professional working with you may
need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti...t/default.aspx.
================================================== ==========
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

Hi Rob,
I understand that you would like to know how the SSIS package generated by
Copy Database Wizard in SSMS is implemented.
If I have misunderstood, please let me know.

During the Copy Database Wizard, you can find two options:
1. Use the detach and attach method
2. Use the SQL Management Object model (SMO assemblies)
So the SSIS package implement the database copying via either of the two
ways, however the detail code of the implementation is undocumented.

The generated package is indeed a native kind of SSIS package just
containing a custom task. You may refer to this article in BOL:
Using the Copy Database Wizard
http://msdn.microsoft.com/en-us/library/ms188664.aspx
There is a section which name is "Copy Database Wizard SQL Server
Integration Services Custom Tasks". The name indicates that it is actually
a custom task.

You can also develop a custom task to implement the database copying
function if you learn some knowledge of SSIS Custom Task.
I would like to provide the following links for your reference:
Extending Packages with Custom Objects
http://technet.microsoft.com/en-us/l.../ms345161.aspx
Creating a Custom Task
http://msdn.microsoft.com/en-us/library/ms345156.aspx
Coding a Custom Task
http://technet.microsoft.com/it-it/l.../ms135896.aspx
Developing a Custom Task
http://technet.microsoft.com/en-us/l.../ms135965.aspx
Connecting to Data Sources in a Custom Task
http://technet.microsoft.com/it-it/l.../ms135948.aspx
Adding Support for Debugging in a Custom Task
http://msdn.microsoft.com/en-us/library/ms136129.aspx
Developing a User Interface for a Custom Task
http://technet.microsoft.com/en-us/l.../ms136080.aspx

Regarding SMO, you may refer to:
SQL Server Management Objects (SMO)
http://msdn.microsoft.com/en-us/library/ms162169.aspx

Hope this gives you some hints. If you have any other questions or
concerns, please feel free to let me know.

Best regards,
Charles Wang
Microsoft Online Community Support
================================================== =========
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg (AT) microsoft (DOT) com.
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for
non-urgent issues where an initial response from the community
or a Microsoft Support Engineer within 1 business day is acceptable.
Please note that each follow up response may take approximately
2 business days as the support professional working with you may
need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti...t/default.aspx.
================================================== ==========
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

Hi Rob,
I understand that you would like to know how the SSIS package generated by
Copy Database Wizard in SSMS is implemented.
If I have misunderstood, please let me know.

During the Copy Database Wizard, you can find two options:
1. Use the detach and attach method
2. Use the SQL Management Object model (SMO assemblies)
So the SSIS package implement the database copying via either of the two
ways, however the detail code of the implementation is undocumented.

The generated package is indeed a native kind of SSIS package just
containing a custom task. You may refer to this article in BOL:
Using the Copy Database Wizard
http://msdn.microsoft.com/en-us/library/ms188664.aspx
There is a section which name is "Copy Database Wizard SQL Server
Integration Services Custom Tasks". The name indicates that it is actually
a custom task.

You can also develop a custom task to implement the database copying
function if you learn some knowledge of SSIS Custom Task.
I would like to provide the following links for your reference:
Extending Packages with Custom Objects
http://technet.microsoft.com/en-us/l.../ms345161.aspx
Creating a Custom Task
http://msdn.microsoft.com/en-us/library/ms345156.aspx
Coding a Custom Task
http://technet.microsoft.com/it-it/l.../ms135896.aspx
Developing a Custom Task
http://technet.microsoft.com/en-us/l.../ms135965.aspx
Connecting to Data Sources in a Custom Task
http://technet.microsoft.com/it-it/l.../ms135948.aspx
Adding Support for Debugging in a Custom Task
http://msdn.microsoft.com/en-us/library/ms136129.aspx
Developing a User Interface for a Custom Task
http://technet.microsoft.com/en-us/l.../ms136080.aspx

Regarding SMO, you may refer to:
SQL Server Management Objects (SMO)
http://msdn.microsoft.com/en-us/library/ms162169.aspx

Hope this gives you some hints. If you have any other questions or
concerns, please feel free to let me know.

Best regards,
Charles Wang
Microsoft Online Community Support
================================================== =========
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg (AT) microsoft (DOT) com.
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for
non-urgent issues where an initial response from the community
or a Microsoft Support Engineer within 1 business day is acceptable.
Please note that each follow up response may take approximately
2 business days as the support professional working with you may
need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti...t/default.aspx.
================================================== ==========
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

Hi Rob,
I understand that you would like to know how the SSIS package generated by
Copy Database Wizard in SSMS is implemented.
If I have misunderstood, please let me know.

During the Copy Database Wizard, you can find two options:
1. Use the detach and attach method
2. Use the SQL Management Object model (SMO assemblies)
So the SSIS package implement the database copying via either of the two
ways, however the detail code of the implementation is undocumented.

The generated package is indeed a native kind of SSIS package just
containing a custom task. You may refer to this article in BOL:
Using the Copy Database Wizard
http://msdn.microsoft.com/en-us/library/ms188664.aspx
There is a section which name is "Copy Database Wizard SQL Server
Integration Services Custom Tasks". The name indicates that it is actually
a custom task.

You can also develop a custom task to implement the database copying
function if you learn some knowledge of SSIS Custom Task.
I would like to provide the following links for your reference:
Extending Packages with Custom Objects
http://technet.microsoft.com/en-us/l.../ms345161.aspx
Creating a Custom Task
http://msdn.microsoft.com/en-us/library/ms345156.aspx
Coding a Custom Task
http://technet.microsoft.com/it-it/l.../ms135896.aspx
Developing a Custom Task
http://technet.microsoft.com/en-us/l.../ms135965.aspx
Connecting to Data Sources in a Custom Task
http://technet.microsoft.com/it-it/l.../ms135948.aspx
Adding Support for Debugging in a Custom Task
http://msdn.microsoft.com/en-us/library/ms136129.aspx
Developing a User Interface for a Custom Task
http://technet.microsoft.com/en-us/l.../ms136080.aspx

Regarding SMO, you may refer to:
SQL Server Management Objects (SMO)
http://msdn.microsoft.com/en-us/library/ms162169.aspx

Hope this gives you some hints. If you have any other questions or
concerns, please feel free to let me know.

Best regards,
Charles Wang
Microsoft Online Community Support
================================================== =========
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg (AT) microsoft (DOT) com.
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for
non-urgent issues where an initial response from the community
or a Microsoft Support Engineer within 1 business day is acceptable.
Please note that each follow up response may take approximately
2 business days as the support professional working with you may
need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti...t/default.aspx.
================================================== ==========
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

Hi Rob,
I understand that you would like to know how the SSIS package generated by
Copy Database Wizard in SSMS is implemented.
If I have misunderstood, please let me know.

During the Copy Database Wizard, you can find two options:
1. Use the detach and attach method
2. Use the SQL Management Object model (SMO assemblies)
So the SSIS package implement the database copying via either of the two
ways, however the detail code of the implementation is undocumented.

The generated package is indeed a native kind of SSIS package just
containing a custom task. You may refer to this article in BOL:
Using the Copy Database Wizard
http://msdn.microsoft.com/en-us/library/ms188664.aspx
There is a section which name is "Copy Database Wizard SQL Server
Integration Services Custom Tasks". The name indicates that it is actually
a custom task.

You can also develop a custom task to implement the database copying
function if you learn some knowledge of SSIS Custom Task.
I would like to provide the following links for your reference:
Extending Packages with Custom Objects
http://technet.microsoft.com/en-us/l.../ms345161.aspx
Creating a Custom Task
http://msdn.microsoft.com/en-us/library/ms345156.aspx
Coding a Custom Task
http://technet.microsoft.com/it-it/l.../ms135896.aspx
Developing a Custom Task
http://technet.microsoft.com/en-us/l.../ms135965.aspx
Connecting to Data Sources in a Custom Task
http://technet.microsoft.com/it-it/l.../ms135948.aspx
Adding Support for Debugging in a Custom Task
http://msdn.microsoft.com/en-us/library/ms136129.aspx
Developing a User Interface for a Custom Task
http://technet.microsoft.com/en-us/l.../ms136080.aspx

Regarding SMO, you may refer to:
SQL Server Management Objects (SMO)
http://msdn.microsoft.com/en-us/library/ms162169.aspx

Hope this gives you some hints. If you have any other questions or
concerns, please feel free to let me know.

Best regards,
Charles Wang
Microsoft Online Community Support
================================================== =========
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg (AT) microsoft (DOT) com.
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for
non-urgent issues where an initial response from the community
or a Microsoft Support Engineer within 1 business day is acceptable.
Please note that each follow up response may take approximately
2 business days as the support professional working with you may
need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti...t/default.aspx.
================================================== ==========
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

Hi Rob,
I understand that you would like to know how the SSIS package generated by
Copy Database Wizard in SSMS is implemented.
If I have misunderstood, please let me know.

During the Copy Database Wizard, you can find two options:
1. Use the detach and attach method
2. Use the SQL Management Object model (SMO assemblies)
So the SSIS package implement the database copying via either of the two
ways, however the detail code of the implementation is undocumented.

The generated package is indeed a native kind of SSIS package just
containing a custom task. You may refer to this article in BOL:
Using the Copy Database Wizard
http://msdn.microsoft.com/en-us/library/ms188664.aspx
There is a section which name is "Copy Database Wizard SQL Server
Integration Services Custom Tasks". The name indicates that it is actually
a custom task.

You can also develop a custom task to implement the database copying
function if you learn some knowledge of SSIS Custom Task.
I would like to provide the following links for your reference:
Extending Packages with Custom Objects
http://technet.microsoft.com/en-us/l.../ms345161.aspx
Creating a Custom Task
http://msdn.microsoft.com/en-us/library/ms345156.aspx
Coding a Custom Task
http://technet.microsoft.com/it-it/l.../ms135896.aspx
Developing a Custom Task
http://technet.microsoft.com/en-us/l.../ms135965.aspx
Connecting to Data Sources in a Custom Task
http://technet.microsoft.com/it-it/l.../ms135948.aspx
Adding Support for Debugging in a Custom Task
http://msdn.microsoft.com/en-us/library/ms136129.aspx
Developing a User Interface for a Custom Task
http://technet.microsoft.com/en-us/l.../ms136080.aspx

Regarding SMO, you may refer to:
SQL Server Management Objects (SMO)
http://msdn.microsoft.com/en-us/library/ms162169.aspx

Hope this gives you some hints. If you have any other questions or
concerns, please feel free to let me know.

Best regards,
Charles Wang
Microsoft Online Community Support
================================================== =========
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg (AT) microsoft (DOT) com.
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for
non-urgent issues where an initial response from the community
or a Microsoft Support Engineer within 1 business day is acceptable.
Please note that each follow up response may take approximately
2 business days as the support professional working with you may
need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti...t/default.aspx.
================================================== ==========
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

Hi Rob,
I understand that you would like to know how the SSIS package generated by
Copy Database Wizard in SSMS is implemented.
If I have misunderstood, please let me know.

During the Copy Database Wizard, you can find two options:
1. Use the detach and attach method
2. Use the SQL Management Object model (SMO assemblies)
So the SSIS package implement the database copying via either of the two
ways, however the detail code of the implementation is undocumented.

The generated package is indeed a native kind of SSIS package just
containing a custom task. You may refer to this article in BOL:
Using the Copy Database Wizard
http://msdn.microsoft.com/en-us/library/ms188664.aspx
There is a section which name is "Copy Database Wizard SQL Server
Integration Services Custom Tasks". The name indicates that it is actually
a custom task.

You can also develop a custom task to implement the database copying
function if you learn some knowledge of SSIS Custom Task.
I would like to provide the following links for your reference:
Extending Packages with Custom Objects
http://technet.microsoft.com/en-us/l.../ms345161.aspx
Creating a Custom Task
http://msdn.microsoft.com/en-us/library/ms345156.aspx
Coding a Custom Task
http://technet.microsoft.com/it-it/l.../ms135896.aspx
Developing a Custom Task
http://technet.microsoft.com/en-us/l.../ms135965.aspx
Connecting to Data Sources in a Custom Task
http://technet.microsoft.com/it-it/l.../ms135948.aspx
Adding Support for Debugging in a Custom Task
http://msdn.microsoft.com/en-us/library/ms136129.aspx
Developing a User Interface for a Custom Task
http://technet.microsoft.com/en-us/l.../ms136080.aspx

Regarding SMO, you may refer to:
SQL Server Management Objects (SMO)
http://msdn.microsoft.com/en-us/library/ms162169.aspx

Hope this gives you some hints. If you have any other questions or
concerns, please feel free to let me know.

Best regards,
Charles Wang
Microsoft Online Community Support
================================================== =========
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg (AT) microsoft (DOT) com.
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for
non-urgent issues where an initial response from the community
or a Microsoft Support Engineer within 1 business day is acceptable.
Please note that each follow up response may take approximately
2 business days as the support professional working with you may
need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti...t/default.aspx.
================================================== ==========
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

Hi Rob,
I understand that you would like to know how the SSIS package generated by
Copy Database Wizard in SSMS is implemented.
If I have misunderstood, please let me know.

During the Copy Database Wizard, you can find two options:
1. Use the detach and attach method
2. Use the SQL Management Object model (SMO assemblies)
So the SSIS package implement the database copying via either of the two
ways, however the detail code of the implementation is undocumented.

The generated package is indeed a native kind of SSIS package just
containing a custom task. You may refer to this article in BOL:
Using the Copy Database Wizard
http://msdn.microsoft.com/en-us/library/ms188664.aspx
There is a section which name is "Copy Database Wizard SQL Server
Integration Services Custom Tasks". The name indicates that it is actually
a custom task.

You can also develop a custom task to implement the database copying
function if you learn some knowledge of SSIS Custom Task.
I would like to provide the following links for your reference:
Extending Packages with Custom Objects
http://technet.microsoft.com/en-us/l.../ms345161.aspx
Creating a Custom Task
http://msdn.microsoft.com/en-us/library/ms345156.aspx
Coding a Custom Task
http://technet.microsoft.com/it-it/l.../ms135896.aspx
Developing a Custom Task
http://technet.microsoft.com/en-us/l.../ms135965.aspx
Connecting to Data Sources in a Custom Task
http://technet.microsoft.com/it-it/l.../ms135948.aspx
Adding Support for Debugging in a Custom Task
http://msdn.microsoft.com/en-us/library/ms136129.aspx
Developing a User Interface for a Custom Task
http://technet.microsoft.com/en-us/l.../ms136080.aspx

Regarding SMO, you may refer to:
SQL Server Management Objects (SMO)
http://msdn.microsoft.com/en-us/library/ms162169.aspx

Hope this gives you some hints. If you have any other questions or
concerns, please feel free to let me know.

Best regards,
Charles Wang
Microsoft Online Community Support
================================================== =========
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg (AT) microsoft (DOT) com.
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for
non-urgent issues where an initial response from the community
or a Microsoft Support Engineer within 1 business day is acceptable.
Please note that each follow up response may take approximately
2 business days as the support professional working with you may
need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti...t/default.aspx.
================================================== ==========
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

Thanks - that's all I need confirming. I'll have a further read on custom
objects.

Cheers, Rob.