I have just been using the Import Data wizard in SSMS and when going through the wizard I checked the "Optimize for many tables" checkbox.
The resultant package contains a task called "Transfer Task". I've never heard of this before. Its not listed in the toolbox and its not documented in BOL.
It does some rather strange things as well.
- From what I can determine it uses an XML manifest file (stored in c:\documents and settings\<user>\Local settings\temp) to construct a SSIS package on the fly which is then executed by an Execute Package Task.
- Its SourceDBÃÂ property is always "smo_Pubs". Its DestinationDB property is always "smo_Pubs_xfred"
- There's no UI for it
All very peculiar.
What is it?
Where has it come from?
Did it arrive with SP1 or have I just never noticed it before?
Why is it preferable to a package with lots of data-flows?
Why is it not documented?
When should I use it/not use it?
Questions questions questions...
View Complete Post