Home Forums Article Discussions Article Discussions by Author Discuss content posted by Koen Verbeeck SSIS 2012 - Build Project RE: SSIS 2012 - Build Project

  • June 10, 2012 at 11:25 pm

    #1499144

    Koen Verbeeck (6/10/2012)

    The behaviour should not be dependent on the OS.

    What is this "SSIS new project for flat file conversion "?

    There are only two ways of developing SSIS projects:

    * Project Deployment Model: this one is new and is introduced in SQL Server 2012. The question deals with this Model only.

    * Legacy Deployment Model: this one corresponds with earlier versions of SSIS (2005 - 2008R2).

    It is possible that you had your project first in Legacy Deployment Model, as that Model did copy the .dtsx packages into the bin folder. However, the Project Deployment Model creates an .ispac file and puts the .dtsx inside it.

    I had a typo on last reply. It should be Project Deployment Model.

    I gave an example of SSIS project for converting flat data file and load to db for testing.

    You should also notice that in SQL 2012, it is possible for one to convert legacy deployment model to project deployment model. I did not observe that .dtsx file was inside .ispac file. They were both in /bin/development folder.