Hi,
I created a DTS package using import/export wizard in SQL 2005 SP2
eviroment, then I saved it on server. However, when I looked for it, couldn't
find it in SMO. It is different from 2000.

Thanks a lot,
sg

I you selected the "Server Storage" for saving your SSIS Package, then it is
stored in the MSDB database.

To see the list of stored packages, use Management Studio and, when you
connect to a server, connect to an SSIS Instance, not a Database Engine
instance. (In the "Registered Servers" pane, there is an icon for registered
SSIS instances.)

HTH
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"sg" wrote:

I you selected the "Server Storage" for saving your SSIS Package, then it is
stored in the MSDB database.

To see the list of stored packages, use Management Studio and, when you
connect to a server, connect to an SSIS Instance, not a Database Engine
instance. (In the "Registered Servers" pane, there is an icon for registered
SSIS instances.)

HTH
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"sg" wrote:

I you selected the "Server Storage" for saving your SSIS Package, then it is
stored in the MSDB database.

To see the list of stored packages, use Management Studio and, when you
connect to a server, connect to an SSIS Instance, not a Database Engine
instance. (In the "Registered Servers" pane, there is an icon for registered
SSIS instances.)

HTH
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"sg" wrote:

I you selected the "Server Storage" for saving your SSIS Package, then it is
stored in the MSDB database.

To see the list of stored packages, use Management Studio and, when you
connect to a server, connect to an SSIS Instance, not a Database Engine
instance. (In the "Registered Servers" pane, there is an icon for registered
SSIS instances.)

HTH
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"sg" wrote:

I you selected the "Server Storage" for saving your SSIS Package, then it is
stored in the MSDB database.

To see the list of stored packages, use Management Studio and, when you
connect to a server, connect to an SSIS Instance, not a Database Engine
instance. (In the "Registered Servers" pane, there is an icon for registered
SSIS instances.)

HTH
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"sg" wrote:

I you selected the "Server Storage" for saving your SSIS Package, then it is
stored in the MSDB database.

To see the list of stored packages, use Management Studio and, when you
connect to a server, connect to an SSIS Instance, not a Database Engine
instance. (In the "Registered Servers" pane, there is an icon for registered
SSIS instances.)

HTH
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"sg" wrote:

I you selected the "Server Storage" for saving your SSIS Package, then it is
stored in the MSDB database.

To see the list of stored packages, use Management Studio and, when you
connect to a server, connect to an SSIS Instance, not a Database Engine
instance. (In the "Registered Servers" pane, there is an icon for registered
SSIS instances.)

HTH
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"sg" wrote:

I you selected the "Server Storage" for saving your SSIS Package, then it is
stored in the MSDB database.

To see the list of stored packages, use Management Studio and, when you
connect to a server, connect to an SSIS Instance, not a Database Engine
instance. (In the "Registered Servers" pane, there is an icon for registered
SSIS instances.)

HTH
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"sg" wrote: