how to open SSIS from sql db | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

how to open SSIS from sql db

I had create the SSIS project and deploy it into sql database.
May I know How to open the project from the sql database that i deployed.
I not sure this thing can do or not.
Just would like to double confirm weather this things can done or not if the project SSIS file missing or spoil.
Thanks in advance.
u can open it…
once u deploy it inthe sql server open sql server and there u find u r database name …
u find u r database under the master database bz, by default it will store under the master only..
satish.e
http://msdn2.microsoft.com/en-us/library/dahcx0ww(VS.80).aspx
http://msdn2.microsoft.com/en-us/library/c8dbfz8s(VS.80).aspx If you are using for SSIS then you can take help of Package Installer wizard http://www.microsoft.com/technet/prodtechnol/sql/2005/mgngssis.mspx Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
Yes,you are right .
I can see the setting data at the master database after deployment.But,
let said the project for SSIS in file format already missing and spoil, then
I still dont know how to open it from the master database’s master table using MS visio studio for doing changes to the package. Hope to get clear picture.
Thanks for helping.
If there is a mismatch or corruption of package deployment then only way is to rerun the deployment wizard from the source server, if you wish to take that route. You are asking too many in one question, can you be clear whether you want to view data from Visio or any other API. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
]]>