I am trying to recreate some fairly simple data exports that I had in 2000
DTS packages. I created them by using the data export wizard and then
selecting the "Save DTS Package" option at the end. Then I could re-open them
in the DTS designer to make modifications, copy and paste them to string
together, etc.

I just created my first export in Management Studio 2005 and the export data
wizard is mostly the same. However, I have no idea how to find the SSIS
"package" that I just saved. I'm still learning my way around the IDE and any
help would be appreciated. Thanks in advance.

Hello Nathaniel:

I haven't done an import/export wizard in a while so don't remember where it
saves the package. BUT, knowing the file type is ".dtsx" you could do a
desktop search of the files on the machine to find that type.

In the Business Intelligence Develepment Studio, they are store under My
Documents/Visual Studio 2005/Projects...

HTH
--
Todd C




"Nathaniel" wrote:

Hello Nathaniel:

I haven't done an import/export wizard in a while so don't remember where it
saves the package. BUT, knowing the file type is ".dtsx" you could do a
desktop search of the files on the machine to find that type.

In the Business Intelligence Develepment Studio, they are store under My
Documents/Visual Studio 2005/Projects...

HTH
--
Todd C




"Nathaniel" wrote:

Hello Nathaniel:

I haven't done an import/export wizard in a while so don't remember where it
saves the package. BUT, knowing the file type is ".dtsx" you could do a
desktop search of the files on the machine to find that type.

In the Business Intelligence Develepment Studio, they are store under My
Documents/Visual Studio 2005/Projects...

HTH
--
Todd C




"Nathaniel" wrote:

Hello Nathaniel:

I haven't done an import/export wizard in a while so don't remember where it
saves the package. BUT, knowing the file type is ".dtsx" you could do a
desktop search of the files on the machine to find that type.

In the Business Intelligence Develepment Studio, they are store under My
Documents/Visual Studio 2005/Projects...

HTH
--
Todd C




"Nathaniel" wrote:

Hello Nathaniel:

I haven't done an import/export wizard in a while so don't remember where it
saves the package. BUT, knowing the file type is ".dtsx" you could do a
desktop search of the files on the machine to find that type.

In the Business Intelligence Develepment Studio, they are store under My
Documents/Visual Studio 2005/Projects...

HTH
--
Todd C




"Nathaniel" wrote:

Hello Nathaniel:

I haven't done an import/export wizard in a while so don't remember where it
saves the package. BUT, knowing the file type is ".dtsx" you could do a
desktop search of the files on the machine to find that type.

In the Business Intelligence Develepment Studio, they are store under My
Documents/Visual Studio 2005/Projects...

HTH
--
Todd C




"Nathaniel" wrote:

Hello Nathaniel:

I haven't done an import/export wizard in a while so don't remember where it
saves the package. BUT, knowing the file type is ".dtsx" you could do a
desktop search of the files on the machine to find that type.

In the Business Intelligence Develepment Studio, they are store under My
Documents/Visual Studio 2005/Projects...

HTH
--
Todd C




"Nathaniel" wrote:

Hello Nathaniel:

I haven't done an import/export wizard in a while so don't remember where it
saves the package. BUT, knowing the file type is ".dtsx" you could do a
desktop search of the files on the machine to find that type.

In the Business Intelligence Develepment Studio, they are store under My
Documents/Visual Studio 2005/Projects...

HTH
--
Todd C




"Nathaniel" wrote:

On 15 Ott, 04:13, Todd C <To... (AT) discussions (DOT) microsoft.com> wrote:
Hi,
if you're using Management Studio (right-click on DB icon then Task
then Export, for istance) then after choosing Source, target and which
tables to export you should also have some options like: execute
immediately, Save SSIS package. This second one is folloew by two
alternative options: File System (then browse your profile's folders)
or SQLServer (then it's saved in msdb, you can see it by connecting to
Integration Services from Management Studio).

M.