Maybe I just haven't found the right place yet, but...
1. In 2000 you could hold down the control key, select several tables and
script them out into 1 file... why doesn't this work in 2005 (or how do you
do it in 2005) ?
2. In 2000 you could right click on a table and quickly export its
contents... how in 2005 ?
When using SSIS...
So I connect to Integration services... I expand my stored packages... MSDB
folder... I see the packages there... Is there a way to "open them" in
design view from EM ?
Thanks !Hi Rob
"Rob" wrote:
> Maybe I just haven't found the right place yet, but...
> 1. In 2000 you could hold down the control key, select several tables and
> script them out into 1 file... why doesn't this work in 2005 (or how do you
> do it in 2005) ?
You can script multiple objects by clicking the database then choosing
task/generate scripts and choose from them, a mixture of multiple objects of
different types can be chosen.
> 2. In 2000 you could right click on a table and quickly export its
> contents... how in 2005 ?
Again at database level, tasks and export data to get the wizard..
> When using SSIS...
> So I connect to Integration services... I expand my stored packages... MSDB
> folder... I see the packages there... Is there a way to "open them" in
> design view from EM ?
No, you need to used BIDS ( SQL Server Business Intelligence Development
Studio )
> Thanks !
>
John|||Thanks for the response John...
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:DEF8B71A-5370-4A3F-899C-B8D8D3296D0B@.microsoft.com...
> Hi Rob
> "Rob" wrote:
>> Maybe I just haven't found the right place yet, but...
>> 1. In 2000 you could hold down the control key, select several tables and
>> script them out into 1 file... why doesn't this work in 2005 (or how do
>> you
>> do it in 2005) ?
> You can script multiple objects by clicking the database then choosing
> task/generate scripts and choose from them, a mixture of multiple objects
> of
> different types can be chosen.
>> 2. In 2000 you could right click on a table and quickly export its
>> contents... how in 2005 ?
> Again at database level, tasks and export data to get the wizard..
>> When using SSIS...
>> So I connect to Integration services... I expand my stored packages...
>> MSDB
>> folder... I see the packages there... Is there a way to "open them" in
>> design view from EM ?
> No, you need to used BIDS ( SQL Server Business Intelligence Development
> Studio )
>> Thanks !
> John
No comments:
Post a Comment