September 27, 2007 at 10:13 pm
Hi Friends,
In MS SQL SERVER 2005 we created one new SSIS package.
Where it will be stored in MS SQL SERVER 2005.
Default location SSIS package storage in MS SQL SERVER 2005
Ths & Regaurds
shiv
September 28, 2007 at 5:34 am
If you deploy a package to an SSIS server, it will put it in the root of the msdb "folder" on that SSIS server by default.
September 28, 2007 at 11:11 am
it will be stored in msdb database sysdtspackages table
🙂
October 4, 2007 at 2:32 pm
But if u have saved the package as a file then it will store the location where you wanted the pacakge to be stored. In that case Security level of your SQL server will not apply
October 5, 2007 at 5:14 am
If you want to see the packages you have created & deployed within SQL Server, connect to server type of Integration Services rather than Database engine either when first opening management studio, or from the Connect drop down box at the top left of managament studio once it is open.
Once that is open, you will have access to the packages that have been loaded. From there you can delete & run individual packages.
Catherine Eibner
cybner.com.au
October 5, 2007 at 5:22 am
After deployment, a SSIS Package gets stored in SQL Server database msdb in the table sysdtspackages90. But if you login to the Integration Services Server it will be shown under the "Stored Packages\MSDB" folder (kind of) path.
From there you will be able to Import/Export the package, change the roles and even execute the package.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply