"Tony Rogerson" <tonyrogerson@sqlserverfaq.com> wrote in message
news:urlUaI$8FHA.4076@tk2msftngp13.phx.gbl...
> Hi Scott,
>
> Do you mean, where does SQL 2005 save legacy 2000 DTS packages or where
> does it save SSIS (new name for the DTS rewrite) packages?
>
> You now have an 'Integration Services' engine that you connect to in order
> to manage packages, packages are stored as XML and can be saved in the
> File System or MSDB.
>
> --
> Tony Rogerson
> SQL Server MVP
> http://sqlserverfaq.com - free video tutorials
>
>
> "Scott" <sbailey@mileslumber.com> wrote in message
> news:uvmuMv88FHA.3416@TK2MSFTNGP15.phx.gbl...
>> Where did MS put SQL 2005 DTS packages that are saved? I'm waiting on a
>> book and trying to discover the new UI.
>>
>
>

"scott" <sbailey@mileslumber.com> wrote in message
news:%235i1NtD9FHA.2616@TK2MSFTNGP15.phx.gbl...
> yes, i saved a new SSIS package and couldn't find it in the menu options.
>
>
> "Tony Rogerson" <tonyrogerson@sqlserverfaq.com> wrote in message
> news:urlUaI$8FHA.4076@tk2msftngp13.phx.gbl...
>> Hi Scott,
>>
>> Do you mean, where does SQL 2005 save legacy 2000 DTS packages or where
>> does it save SSIS (new name for the DTS rewrite) packages?
>>
>> You now have an 'Integration Services' engine that you connect to in
>> order to manage packages, packages are stored as XML and can be saved in
>> the File System or MSDB.
>>
>> --
>> Tony Rogerson
>> SQL Server MVP
>> http://sqlserverfaq.com - free video tutorials
>>
>>
>> "Scott" <sbailey@mileslumber.com> wrote in message
>> news:uvmuMv88FHA.3416@TK2MSFTNGP15.phx.gbl...
>>> Where did MS put SQL 2005 DTS packages that are saved? I'm waiting on a
>>> book and trying to discover the new UI.
>>>
>>
>>
>
>

"Tony Rogerson" <tonyrogerson@sqlserverfaq.com> wrote in message
news:uTNlN0D9FHA.4084@TK2MSFTNGP10.phx.gbl...
> Sounds like you saved it into the file system.
>
> If you connect to the 'Integration Services' on the machine in Management
> Studio, you can tree down to STored Packages and right click on the File
> Ssytem/MSDB and import the package.
>
> Tony.
>
> --
> Tony Rogerson
> SQL Server MVP
> http://sqlserverfaq.com - free video tutorials
>
>
> "scott" <sbailey@mileslumber.com> wrote in message
> news:%235i1NtD9FHA.2616@TK2MSFTNGP15.phx.gbl...
>> yes, i saved a new SSIS package and couldn't find it in the menu options.
>>
>>
>> "Tony Rogerson" <tonyrogerson@sqlserverfaq.com> wrote in message
>> news:urlUaI$8FHA.4076@tk2msftngp13.phx.gbl...
>>> Hi Scott,
>>>
>>> Do you mean, where does SQL 2005 save legacy 2000 DTS packages or where
>>> does it save SSIS (new name for the DTS rewrite) packages?
>>>
>>> You now have an 'Integration Services' engine that you connect to in
>>> order to manage packages, packages are stored as XML and can be saved in
>>> the File System or MSDB.
>>>
>>> --
>>> Tony Rogerson
>>> SQL Server MVP
>>> http://sqlserverfaq.com - free video tutorials
>>>
>>>
>>> "Scott" <sbailey@mileslumber.com> wrote in message
>>> news:uvmuMv88FHA.3416@TK2MSFTNGP15.phx.gbl...
>>>> Where did MS put SQL 2005 DTS packages that are saved? I'm waiting on a
>>>> book and trying to discover the new UI.
>>>>
>>>
>>>
>>
>>
>
>