none
How do I execute a dtsx file?

    Question

  •  

    I'm familar with executing SSIS in SQL Server 2000.  I have created a dtsx file in SQL Server 2005, but how do I execute it?

     

    Thanks,

     

    Jim

    Friday, September 12, 2008 7:39 PM

Answers

  • Jim,

    You can execute it with the DTEXEC command line utility.

    You can also run a package from SQL Server Agent as a job.

    You can call it from stored a procedure.

    You can execute it from Management Studio. Make sure you register the IS server in registered servers. Right click on IS server --> select Connect --> Object Explorer.  In OE, right click on package, there is an execute option.

    SSIS Import/Export Wizard:

    http://www.sqlusa.com/bestpractices/ssis-wizard/



    Kalman Toth SQL SERVER 2012 & BI TRAINING
    New Book: Beginner Database Design & SQL Programming Using Microsoft SQL Server 2012



    • Edited by Kalman Toth Saturday, October 06, 2012 4:44 PM
    Friday, September 12, 2008 7:56 PM
  • The most simple route, is to double click the DTSX file.  Invocation from a command line will begin with DTEXEC and the supplied parameters will be based on where the package is stored and what the name is.

    Friday, September 12, 2008 7:50 PM
    Answerer
  • For testing from your machine you can right click the dtsx file in BIDS and say Execute package. For running the file on a server you first need to deploy it on server.  The follwoing articles are good

    http://www.microsoft.com/technet/prodtechnol/sql/2005/mgngssis.mspx

    http://www.mssqltips.com/tip.asp?tip=1024

     

    So you can deploy your packate on server (File system or MSDB) :

    The file system deployment option installs your packages in the file system as .dtsx files. You can later open and edit .dtsx files using the SSIS Designer. If you’ve used custom folders to store your SSIS file system packages then you will want to select the appropriate target folder.

    The SQL Server deployment option installs your packages in the sysdtspackages90 table in SQL Server 2005’s msdb database. This option also copies any of the package’s dependency files such as an XML Configuration file, to a folder on the file system that you designate.

    Using either of these deployment options will register the package and display it in the Stored Packages folder of SQL Server Management Studio

     

    once you have deployed it you can schedule it as SQL server Agent job.

     

    HTH

    Mukti

    Friday, September 12, 2008 7:56 PM

All replies

  • The most simple route, is to double click the DTSX file.  Invocation from a command line will begin with DTEXEC and the supplied parameters will be based on where the package is stored and what the name is.

    Friday, September 12, 2008 7:50 PM
    Answerer
  • Jim,

    You can execute it with the DTEXEC command line utility.

    You can also run a package from SQL Server Agent as a job.

    You can call it from stored a procedure.

    You can execute it from Management Studio. Make sure you register the IS server in registered servers. Right click on IS server --> select Connect --> Object Explorer.  In OE, right click on package, there is an execute option.

    SSIS Import/Export Wizard:

    http://www.sqlusa.com/bestpractices/ssis-wizard/



    Kalman Toth SQL SERVER 2012 & BI TRAINING
    New Book: Beginner Database Design & SQL Programming Using Microsoft SQL Server 2012



    • Edited by Kalman Toth Saturday, October 06, 2012 4:44 PM
    Friday, September 12, 2008 7:56 PM
  • For testing from your machine you can right click the dtsx file in BIDS and say Execute package. For running the file on a server you first need to deploy it on server.  The follwoing articles are good

    http://www.microsoft.com/technet/prodtechnol/sql/2005/mgngssis.mspx

    http://www.mssqltips.com/tip.asp?tip=1024

     

    So you can deploy your packate on server (File system or MSDB) :

    The file system deployment option installs your packages in the file system as .dtsx files. You can later open and edit .dtsx files using the SSIS Designer. If you’ve used custom folders to store your SSIS file system packages then you will want to select the appropriate target folder.

    The SQL Server deployment option installs your packages in the sysdtspackages90 table in SQL Server 2005’s msdb database. This option also copies any of the package’s dependency files such as an XML Configuration file, to a folder on the file system that you designate.

    Using either of these deployment options will register the package and display it in the Stored Packages folder of SQL Server Management Studio

     

    once you have deployed it you can schedule it as SQL server Agent job.

     

    HTH

    Mukti

    Friday, September 12, 2008 7:56 PM
  • If the file is in you solution you can play button in ssis to execute.

    If the .dtxs file is some where else you can copy and paste it in the project and the execute it.

    Thanks.

    Wednesday, November 28, 2012 8:26 PM