Newbie: "Compiling" a DTSx package

Hot Topic

SQL Server 2005 Service Pack 1 is now available
Can we use User Defined Functions in Report Builder
100% stacked bar chart labels not formatted as expected
publishing downloading report model
Merge disparate queries into raw file
Poorly written assembly and CLR
Discard Rows in a flat file
Database Mail Fails For SQL Server Agent Jobs
Resources about Load/Run SSIS packages using .NET Remoting.
Using constraints in SQL Server 2005?

SQL Server

outer join produced cartesion product; embedding where conditions in outer join clause
Report Project and Report Designer
Strange bug with intellisense...
Problem running package with 'larger' amount of data
How to Choose "Cache Size" for a Lookup Transformation?
help on a business case related to status reporting
Howto suppress FETCH output
Unable to achieve database connectivity with my ASP.NET web application
date distribution
SQL Performance

Newbie: "Compiling" a DTSx package

I have now created a few simple SSIS packages. In BIDS I right-clicked on a solution and selected "Build". I went to the "bin" directory hoping to find a standalone ".exe\.dll" file but found only a ".dtsx' file.

Can BIDS can actually build a standalone exe\dll or is the .dtsx file all that's available (If so, I guess that another program is expected to invoke the .dtsx file.)

TIA,

barker

Answer this question

Newbie: "Compiling" a DTSx package

  • SuperJaD

    In my SSIS package deployments, I've deployed my packages via file system files. Basically, all you get for this is a .dtsx file in your /bin folder. To the best of my knowledge, you can't really get a standalone exe file. I'm not really sure there's a need to, but on each computer you're actually going to be running SSIS packages from, you need to install SSIS from the SQL Server installer.

  • Kjelle

    SSIS does not generate standalone executable for your pkg. DTExec.exe under \Program Files\Microsoft SQL Server\90\DTS\Binn is the application which launchs the run of your pkg (.dtsx file)

    HTH

    wenyang



  • Newbie: "Compiling" a DTSx package
Answer this question