Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
FYI: Getting the Transfer SQL Server Objects Task to wor
Message
 
 
To
27/06/2006 20:04:59
General information
Forum:
Microsoft SQL Server
Category:
Import/Export
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01132230
Message ID:
01132238
Views:
14
>FYI
>
>I had a lot of trouble today getting the Transfer SQL Server Objects Task in Integration Services to transfer anything at all until I found a post on a blog from someone who spent many more hours than I did wrestling with the same issue.
>
>See: http://www.tdaley.net/Home/tabid/36/EntryID/9/Default.aspx
>
>The upshot of the post is: set the CopySchema property to True on the task object.
>
>I did this, and actually copied a table from one SQL Server instance to another. So, I was able to reach my goal of producing at least 2 bytes of workable code per day.
>
>(The post also says that the destination database has to be set to a compatibility level of 9.0, but this was already true in my case.)
>
>Chris

Thanks for sharing.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform