Larry Brister
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.
I know they're saved in the msdb database but for the LIFE of me I can't seem to find them.
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
rboyd56:
Thanks but WHERE do they export from? Is there a particulat table/view/stored procedure? I really am not getting this.
Thanks but WHERE do they export from? Is there a particulat table/view/stored procedure? I really am not getting this.
ASKER
rboyd56:
Gotit..thanks. And sorry for the late turnaround
Gotit..thanks. And sorry for the late turnaround
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.