SQL Server Performance

how to open SSIS from sql db

Discussion in 'SQL Server 2005 Analysis Services' started by tboonleong, May 9, 2007.

  1. tboonleong Member

    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.
  2. edarasatish New Member

    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
  3. satya Moderator

    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.
  4. tboonleong Member

    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.
  5. satya Moderator

    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.

Share This Page