none
Where to find newest dtsx files specifications? RRS feed

  • Question

  • Specifications here (https://msdn.microsoft.com/en-us/library/gg587789(v=sql.105).aspx) are only valid up to VS2012 (or maybe 2013, don't have it) with PackageFormatVersion=6, and don't work for files created in newer versions of VS (first noticeable issue - ExecutableType property is fixed to "SSIS.Package.3" in 2010-2012, and "Microsoft.Package" in 2015+).

    Is it possible to obtain actual XSDs?

    Saturday, June 9, 2018 9:50 PM

Answers

All replies

  • Hello Xandrmoro

    Thank you for contacting Microsoft Support. An engineer will be in touch to assist you further.

    Thanks


    Tarun Chopra | Escalation Engineer | Open Specifications Support Team


    Monday, June 11, 2018 6:02 AM
  • Hello Xandrmoro,

    SQL Server 2014 Integration Services uses "DTSX2 2014/01" version.

    Under section 2.5.1.1 AnyNonPackageExecutableTypeExecutableTypeEnum

    enumeration values for the AnyNonPackageExecutableTypeExecutableTypeEnum as it applies to DTSX2 schema for version 2014/01 (DTSX2 2014/01) shows the following

    <xs:simpleType name="AnyNonPackageExecutableTypeExecutableTypeEnum">
       <xs:restriction base="xs:string">
           <xs:enumeration value="Microsoft.Package"/>

    Section "5 Appendix A: Full DTSX2 Schemas" lists the main schemas along with tasks.  Let us know if this helps.   

    Regards,
    Sreekanth Nadendla
    Microsoft Windows Open specifications

    Monday, June 11, 2018 7:38 PM
    Moderator
  • Hello Sreekanth,

    Thank you for your answer!

    Yes, than enum specifies "Microsoft.Package" as a valid option, but there is that line a bit earlier (page 478, bottom):

    <xs:attribute name="ExecutableType" use="required" fixed="SSIS.Package.3" />

    resulting in such an error:

    Element '{www.microsoft.com/SqlServer/Dts}Executable', attribute '{www.microsoft.com/SqlServer/Dts}ExecutableType': The value 'Microsoft.Package' does not match the fixed value constraint 'SSIS.Package.3'.

    Also, when I apply that xsd to my sample dtsx file from VS2015 it shows me two more errors:

    Element '{www.microsoft.com/SqlServer/Dts}Executable': The attribute '{www.microsoft.com/SqlServer/Dts}ExecValueType' is required but missing

    Element '{www.microsoft.com/SqlServer/Dts}Variables': This element is not expected. Expected is one of ( {www.microsoft.com/SqlServer/Dts}PackageVariables, {www.microsoft.com/SqlServer/Dts}DesignTimeProperties )


    • Edited by Xandrmoro Monday, June 11, 2018 8:12 PM
    Monday, June 11, 2018 7:59 PM
  • Hello Xandrmoro, I am currently researching the error messages you've posted. I will provide you with an update soon. Thank you for your patience.

    Regards,
    Sreekanth Nadendla
    Microsoft Windows Open specifications

    Tuesday, June 12, 2018 8:12 PM
    Moderator
  • Hello?
    Saturday, June 16, 2018 8:32 AM
  • Hello Xandrmoro, we are still researching this and working with various resources on the best way to resolve this issue for you. Thank you for being patient.

    Regards,
    Sreekanth Nadendla
    Microsoft Windows Open specifications

    Tuesday, June 19, 2018 8:32 PM
    Moderator
  • Cmon, does it really take a month to validate documentation for an actual version of format?
    Friday, July 6, 2018 10:43 AM
  • Hello Xandrmoro, we are proposing to add new sample to the document that can be used as a template.  This template will make it clear how it can be modified with content suitable to your situation.  We are in the midst of that work, and it will take a bit longer to realize. If you could contact us by sending an e-mail to dochelp at microsoft dot com, we will be able to share some information that might be of help to you. Also it will provide an opportunity to identify any other issues before we actually publish our updates.


    Regards,
    Sreekanth Nadendla
    Microsoft Windows Open specifications
    Friday, July 6, 2018 2:44 PM
    Moderator
  • Hello Xandrmoro,

    Is this still a concern for you? If you could send us email at the DocHelp alias mentioned above, we have additional information we can share with you.

    Thanks,


    Jeff McCashland | Microsoft Protocols Open Specifications Team

    Monday, July 16, 2018 8:04 PM
    Moderator
  • We have addressed this issue and updated the document for the next release. When available, the changes will be posted here:

    [MS-DTSX2]: Data Transformation Services Package XML Version 2 File Format

    https://msdn.microsoft.com/en-us/library/mt449530(v=sql.105).aspx

    All references to AnyNonPackageExecutableTypeExecutableTypeEnum have been removed, and the schema has been updated to a generic format for more flexibility in implementation.

    Thanks,

    Jeff McCashland | Microsoft Protocols Open Specifications Team

    Monday, July 23, 2018 8:10 PM
    Moderator