Home
%3CLINGO-SUB%20id%3D%22lingo-sub-941566%22%20slang%3D%22en-US%22%3EAzure%20Feature%20Pack%201.15.0%20released%20for%20SQL%20Server%202019%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-941566%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20SSIS%20Users%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFrom%201.15.0%2C%26nbsp%3BAzure%20Feature%20Pack%20supports%20%3CA%20href%3D%22https%3A%2F%2Fwww.microsoft.com%2Fsql-server%2Fsql-server-2019%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3ESQL%20Server%202019%3C%2FA%3E.%20Also%20included%20are%20the%20following%20new%20features.%3C%2FP%3E%0A%3COL%3E%0A%3CLI%3E%3CSTRONG%3EDelete%3C%2FSTRONG%3E%20operation%20in%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fsql%2Fintegration-services%2Fcontrol-flow%2Fflexible-file-task%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EFlexible%20File%20Task%3C%2FA%3E.%3CUL%3E%0A%3CLI%3ESupport%20deleting%20folder%2Ffile%20from%20local%20file%20system%2FAzure%20Data%20Lake%20Storage%20Gen2%3C%2FLI%3E%0A%3CLI%3ESupport%20deleting%20file%20from%20Azure%20Blob%20Storage%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FLI%3E%0A%3CLI%3EExternal%20and%20Output%20data%20type%20conversion%20in%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fsql%2Fintegration-services%2Fdata-flow%2Fflexible-file-source%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EFlexible%20File%20Source%3C%2FA%3E.%26nbsp%3BYou%20can%20change%20the%20%3CEM%3EDataType%3C%2FEM%3E%20properties%20for%20Output%20Columns%20to%20convert%20data%20types%20in%20the%20%3CEM%3EInput%20and%20Output%20Properties%3C%2FEM%3E%20tab%20of%20the%20%3CEM%3EAdvanced%20Editor%20for%20Flexible%20File%20Source%3C%2FEM%3E%20dialog%20as%20shown%20below.%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20801px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F145826iD34964FED3510E34%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22convert.png%22%20title%3D%22convert.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CP%3EYou%20can%20download%20this%20new%20version%20of%20Azure%20Feature%20Pack%20from%20the%20following%20links%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fwww.microsoft.com%2Fdownload%2Fdetails.aspx%3Fid%3D100430%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAzure%20Feature%20Pack%20for%20SQL%20Server%202019%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fwww.microsoft.com%2Fdownload%2Fdetails.aspx%3Fid%3D54798%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAzure%20Feature%20Pack%20for%20SQL%20Server%202017%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fwww.microsoft.com%2Fdownload%2Fdetails.aspx%3Fid%3D49492%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAzure%20Feature%20Pack%20for%20SQL%20Server%202016%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fwww.microsoft.com%2Fdownload%2Fdetails.aspx%3Fid%3D47366%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAzure%20Feature%20Pack%20for%20SQL%20Server%202014%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fwww.microsoft.com%2Fdownload%2Fdetails.aspx%3Fid%3D47367%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAzure%20Feature%20Pack%20for%20SQL%20Server%202012%3C%2FA%3E%3C%2FLI%3E%0A%3C%2FUL%3E%3C%2FLINGO-BODY%3E
Microsoft

Dear SSIS Users,

 

From 1.15.0, Azure Feature Pack supports SQL Server 2019. Also included are the following new features.

  1. Delete operation in Flexible File Task.
    • Support deleting folder/file from local file system/Azure Data Lake Storage Gen2
    • Support deleting file from Azure Blob Storage
  2. External and Output data type conversion in Flexible File Source. You can change the DataType properties for Output Columns to convert data types in the Input and Output Properties tab of the Advanced Editor for Flexible File Source dialog as shown below.
    convert.png

You can download this new version of Azure Feature Pack from the following links: