dts where ssis where

Posted on 2011-10-06
Last Modified: 2013-11-10
SSIS packages are stored in MSDB database.. what format are they stored in (xml etc)

where are the DTS (SQL 2000) stored?
Question by:25112
    LVL 17

    Assisted Solution

    SSIS packages can be stored in the database or in the file system.

    dtx packages could also be stored in the file system.
    LVL 30

    Assisted Solution

    by:Reza Rad
    when you deploy package on SQL Server;
    they will be stored in the dbo.sysssispackages table
    one record per each package will be created
    and the field which contains whole package is "packagedata" which is IMAGE type and whole package will be stored there converted in binary format.

    same thing exists about dts packages in same database, but table name is: dbo.sysdtspackages, field name and datatype is same
    LVL 21

    Assisted Solution

    by:Alpesh Patel
    great post reza_rad:

    Table "sysssispackagefolders" is name of table in which package is stored in MSDB database.
    LVL 5

    Author Comment


    select * from msdb..sysssispackages
    Invalid object name 'msdb..sysssispackages'.

    select * from msdb..sysssispackagefolders
    Invalid object name 'msdb..sysssispackagefolders'.

    the above is on 2005.

    select * from msdb..sysdtspackages is fine both on 2005 & 2000
    LVL 5

    Author Comment

    >>SSIS packages can be stored in the database or in the file system. dtx packages could also be stored in the file system.

    so both 2000 and 2005 can be stored purely in file system or purely in msdb, right?
    LVL 30

    Accepted Solution

    yes, you can deploy each of them on file system or sql server msdb as you like,  
    this link has a comparison on deployment of SSIS and DTS:
    LVL 5

    Author Comment

    thanks reza_rad

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Suggested Solutions

    Introduction In my previous article ( I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
    JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now