"Todd C" <ToddC@discussions.microsoft.com> wrote in message
news:A6D66EB7-6355-4E09-B6AE-5C47ACF20A39@microsoft.com...
> Hellow Conan:
>
> In SSMS, display the Registered Servers pane (Alt+Ctrl+G)
> The icon on the far right is the one for SSIS. Click it.
> Register your server under it just like you would for a database engine
> server.
> Double-click the newly registered server.
> Expand Stored Packages node.
> Expand MSDB node.
>
> See your packages there?
>
> By the way, you cannot edit packages that have been deployed to SSIS. You
> must load them into BIDS for editing. Afterward, you can go back to SSIS,
> right-click a folder and select Import to re-import and overwrite the
> package
> you have in production.
>
> Microsoft moved toward a Development/Production environment with this
> model.
> Gone are the days where a DBA would just make a change to a DTS package
> right
> on the production server!
>
> Another note: you must be a member of db_dtsadmin role in the MSDB
> database
> of the server in question before you can deploy packages, etc.
>
> HTH
> --
> Todd Chittenden
>
> [If this response was helpful, please indicate by clicking the appropriate
> answer at the bottom]
>
>
> "Conan Kelly" wrote:
>
>> Hello all,
>>
>> When I go through the Import/Export Wizard and select the option to save
>> the
>> SSIS to SQL Server package near the end of the process, how do I access
>> that
>> saved package to edit and run it?
>>
>> In EM in SQL Server 2000, I could see the saved DTS packages by going to
>> Console Root>MS SQL Servers>SQL Server Group>[Server Name/Instance]>Data
>> Transformation Services>Local Packages.
>>
>> There doesn't appear to be a similar path in Server Management Studio to
>> see
>> locally saved SSIS packages.
>>
>> Thanks for any help anyone can provide,
>>
>> Conan Kelly
>>
>>
>>

"Conan Kelly" <CTBarbarinNOSPAM@msnNOSPAM.comNOSPAM> wrote in message
news:Lu5uh.819623$QZ1.349403@bgtnsc04-news.ops.worldnet.att.net:

> Hello all,
>
> When I go through the Import/Export Wizard and select the option to save the
> SSIS to SQL Server package near the end of the process, how do I access that
> saved package to edit and run it?
>
> In EM in SQL Server 2000, I could see the saved DTS packages by going to
> Console Root>MS SQL Servers>SQL Server Group>[Server Name/Instance]>Data
> Transformation Services>Local Packages.
>
> There doesn't appear to be a similar path in Server Management Studio to see
> locally saved SSIS packages.
>
> Thanks for any help anyone can provide,
>
> Conan Kelly