where is it saved?

where is it saved? - SQL 2005

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sg - 14 Jul 2008 21:22 GMT

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

Reply to this Message

Todd C - 23 Jul 2008 19:58 GMT

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

Signature

Todd C

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

> Hi,
> I created a DTS package using import/export wizard in SQL 2005 SP2
[quoted text clipped - 3 lines]
> Thanks a lot,
> sg

Reply to this Message