Link to home
Create AccountLog in
Avatar of Larry Brister
Larry BristerFlag for United States of America

asked on

SQL Server 2005

I'm saving some import export tasks as SSIS projects on the SQL Server.

I know they're saved in the msdb database but for the LIFE of me I can't seem to find them.  
Avatar of rboyd56
rboyd56

By defatul SSIS packages/projects are saved on the disk itself. You have to import them or deploy them to SQL Server.

If they are on disk you can search for them. They have a dtsx extension.

The only way to view the packages themself is via Visual Studio.
ASKER CERTIFIED SOLUTION
Avatar of rboyd56
rboyd56

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
Avatar of Larry Brister

ASKER

rboyd56:
  Thanks but WHERE do they export from?  Is there a particulat table/view/stored procedure?  I really am not getting this.
rboyd56:
Gotit..thanks.  And sorry for the late turnaround