So, I used the SQL Server (2005) Import and Export Wizard to create an Import
operation. I saved it to SQL Server instead of the file system. Now I can't
find it!!

The help files states:
"If the wizard is started from SQL Server Management Studio or the command
prompt, the package can run immediately. You can save the package to the SQL
Server msdb database or to the file system."

I've looked in the msdb database and have no clue how to find this SSIS
package.

--
Michael Hockstein

Open SQL Server Management Studio. When the Connect To Server window comes
up, choose Integration Services in the Server type drop-down. Once you
successfully connect, expand the nodes in Object Explorer and expand Stored
Packages. If you expand MSDB, you should see your package there.

You can also connect to the database engine and open a query with the
database context as msdb. If you run this query, you should see your package
name:

select * from dbo.sysdtspackages90

Charles Kangai, MCT, MCDBA

"michael" wrote:

OK! Found it.

Now once it's there, it doesn't seem to be editable. I was hoping that I
could use the Wizard to create a template of a package that I could edit.
Maybe that's only possible if I save it to the file system.

--
Michael Hockstein


"Charles Kangai" wrote:

You can only edit packages in the SSIS Designer or programmatically using a
..NET language. Editing the XML in Notepad is not a serious proposition, so I
have not included it.

Charles Kangai, MCT, MCDBA

"michael" wrote:

Sorry that I forgot to get back to you. Thanks for your help.
--
Michael Hockstein


"Charles Kangai" wrote: