June 26, 2012 at 1:32 pm
I am trying to use the copy database wizard. I am using the detach and attach method in the wizard.
It works fine.
And it creates a SSIS package when the wizard is done.
I am curious what is exactly in the package, and see if I can later edit it.
But when I open the package in BIDs, all I see is only one task there, and when I want to see the detail of the task, it shows the following message:
------------------------------
This task does not have a custom editor. Use the Properties window to edit properties of this task.
------------------------------
But in the property there is not much I can see either, I cannot see even what is the source database and destintation database.
Anything I am missing?
THanks
June 27, 2012 at 3:19 am
the message gives you all the info you need. The task is not an editable SSIS object, rather, it has a set of properties that define the execution context. Right click the task and select properties, here you set mode of transfer and database details, etc, etc!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 27, 2012 at 10:43 am
But I cannot see some settings of the transfer like source database and destination database in the property window of the task.
The only way I can see that is open view code and see it in the xml file.
June 27, 2012 at 11:20 am
Source and destination db, etc are a collection of items under the database details property
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 27, 2012 at 11:23 am
Thanks, will check into it.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply