Transfer Sql Server Objects Task. Errorcode 1073548784 descriptionexecuting the query alter table dbotemplatepropertyvalue with ch failed with the following error. Once the database is successfully then by using transfer sql server objects task we will transfer the database objects such astables views and stored procedures etc from a sql server 2005 to a sql server 2008 instance.
The transfer sql server objects task in ssis is used to transfer one or more sql server objects such as tables view stored procedures user defined functions indexes users logins etc from one database to another database. After clicking on the copy database wizard then the following screen will appear. 0x4002f418 at mydatabase transfer sql server objects task.
If you dont want to go the route of creating multiple data flow tasks you could create an ado recordset of the table names after the transfer task runs then create a foreach loop to iterate over the ado recordset.
Msbi ssis transfer sql server objects task. Important some information relates to prerelease product that may be substantially modified before its released. If you dont want to go the route of creating multiple data flow tasks you could create an ado recordset of the table names after the transfer task runs then create a foreach loop to iterate over the ado recordset. Errorcode 1073548784 descriptionexecuting the query alter table dbotemplatepropertyvalue with ch failed with the following error.