Home
%3CLINGO-SUB%20id%3D%22lingo-sub-830672%22%20slang%3D%22en-US%22%3EAzure%20Feature%20Pack%201.14.0%20released%20with%20Azure%20Data%20Lake%20Storage%20Gen2%20Support%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-830672%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%3EAzure%20Feature%20Pack%201.14.0%20is%20here%2C%20which%20enables%20you%20to%20connect%20to%20%3CA%20href%3D%22https%3A%2F%2Fnam06.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Fdocs.microsoft.com%252Fazure%252Fstorage%252Fblobs%252Fdata-lake-storage-introduction%26amp%3Bdata%3D02%257C01%257Clingxl%2540microsoft.com%257C1d2ad14d1da74bd7c37908d72d059176%257C72f988bf86f141af91ab2d7cd011db47%257C1%257C0%257C637027374248258452%26amp%3Bsdata%3Dn96Hkjs33L2Nv7c6taCh%252BbT3czQvUOjdlRK9vYNabx0%253D%26amp%3Breserved%3D0%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAzure%20Data%20Lake%20Storage%20Gen2%3C%2FA%3E(ADLS%20Gen2).%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMajor%20updates%20include%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3E%3CSTRONG%3E%3CA%20href%3D%22https%3A%2F%2Fnam06.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Fdocs.microsoft.com%252Fsql%252Fintegration-services%252Fconnection-manager%252Fazure-storage-connection-manager%253Fview%253Dsql-server-2017%26amp%3Bdata%3D02%257C01%257Clingxl%2540microsoft.com%257C1d2ad14d1da74bd7c37908d72d059176%257C72f988bf86f141af91ab2d7cd011db47%257C1%257C0%257C637027374248258452%26amp%3Bsdata%3D%252BMsiCGI1DD0Ju0oegWEM%252FVYp%252Bu7cKPQrNPLZrGfnqus%253D%26amp%3Breserved%3D0%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAzure%20Storage%20Connection%20Manager%3C%2FA%3E%3A%3C%2FSTRONG%3EThe%20improved%20Azure%20Storage%20Connection%20Manager%20now%20supports%20both%20Blob%20Storage%20and%20Data%20Lake%20Storage%20Gen2%20services%20of%20Azure%20Storage.%20We%20have%20also%20added%20a%20service%20principal%20authentication%20method%20on%20top%20of%20the%20access%20key%20one.%20When%20you%20run%20your%20packages%20on%20%3CA%20href%3D%22https%3A%2F%2Fnam06.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Fdocs.microsoft.com%252Fazure%252Fdata-factory%252Ftutorial-deploy-ssis-packages-azure%26amp%3Bdata%3D02%257C01%257Clingxl%2540microsoft.com%257C1d2ad14d1da74bd7c37908d72d059176%257C72f988bf86f141af91ab2d7cd011db47%257C1%257C0%257C637027374248268445%26amp%3Bsdata%3DeY4F777qYQmgXLB9d6%252BURNIa0EZLEAbrDMcAsCpki7Q%253D%26amp%3Breserved%3D0%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAzure-SSIS%20IR%3C%2FA%3E%2C%20you%20have%20cloud-only%20security%20features%20at%20your%20disposal.%20For%20example%2C%20when%20you%20use%20%3CA%20href%3D%22https%3A%2F%2Fnam06.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Fdocs.microsoft.com%252Fazure%252Fdata-factory%252Fhow-to-invoke-ssis-package-ssis-activity%26amp%3Bdata%3D02%257C01%257Clingxl%2540microsoft.com%257C1d2ad14d1da74bd7c37908d72d059176%257C72f988bf86f141af91ab2d7cd011db47%257C1%257C0%257C637027374248268445%26amp%3Bsdata%3DoRoaRGhdNh5LmrbMiH0hnnPkyTmaeRyYqR3CBUhN4%252Bo%253D%26amp%3Breserved%3D0%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EExecute%20SSIS%20Package%20activities%20in%20Azure%20Data%20Factory%20(ADF)%20pipelines%3C%2FA%3E%2C%20you%20can%20store%20the%20sensitive%20values%20for%20account%2Fapplication%20keys%20and%20application%2Ftenant%20IDs%20as%20secrets%20in%20Azure%20Key%20Vault%20(AKV).%20On%20top%20of%20that%2C%20you%20can%20do%20away%20with%20sensitive%20values%20altogether%20and%20authenticate%20using%20%3CA%20href%3D%22https%3A%2F%2Fnam06.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Fdocs.microsoft.com%252Fsql%252Fintegration-services%252Fconnection-manager%252Fazure-storage-connection-manager%253Fview%253Dsql-server-2017%2523managed-identities-for-azure-resources-authentication%26amp%3Bdata%3D02%257C01%257Clingxl%2540microsoft.com%257C1d2ad14d1da74bd7c37908d72d059176%257C72f988bf86f141af91ab2d7cd011db47%257C1%257C0%257C637027374248278438%26amp%3Bsdata%3DDgVF8nSDFScLfPn%252BWbMnMFgGUlAq2hxpULfw97%252BMmAg%253D%26amp%3Breserved%3D0%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ethe%20managed%20identity%20of%20hosting%20ADF%3C%2FA%3E.%3C%2FLI%3E%0A%3CLI%3E%3CSTRONG%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fsql%2Fintegration-services%2Fcontrol-flow%2Fflexible-file-task%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EFlexible%20File%20Task%3C%2FA%3E%3A%3C%2FSTRONG%3EThis%20newly%20added%20task%20is%20designed%20to%20support%20different%20kinds%20of%20file%20operations%20on%20various%20supported%20storage%20services.%3CBR%20%2F%3ECurrently%2C%20only%20%3CSTRONG%3ECopy%3C%2FSTRONG%3Eoperation%20is%20provided%2C%20and%20the%20supported%20storage%20services%20for%20source%2Fdestination%20are%20local%20file%20system%2C%20Blob%20Storage%2C%20and%20ADLS%20Gen2.%3CBR%20%2F%3EWe%20expect%20to%20support%20more%20operations%20and%20storage%20services%20in%20the%20future.%3C%2FLI%3E%0A%3CLI%3E%3CSTRONG%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fsql%2Fintegration-services%2Fdata-flow%2Fflexible-file-source%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EFlexible%20File%20Source%3C%2FA%3E%2F%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fsql%2Fintegration-services%2Fdata-flow%2Fflexible-file-destination%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EDestination%3C%2FA%3E%3A%3C%2FSTRONG%3ELike%20Flexible%20File%20Task%2C%20the%20source%2Fdestination%20is%20designed%20to%20support%20various%20storage%20services.%3CBR%20%2F%3ECurrently%2C%20Blob%20Storage%20and%20ADLS%20Gen2%20are%20supported.%3C%2FLI%3E%0A%3CLI%3E%3CSTRONG%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fsql%2Fintegration-services%2Fcontrol-flow%2Fforeach-loop-container%23ForeachBlobFsFile%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EForeach%20Data%20Lake%20Storage%20Gen2%20File%20Enumerator%3C%2FA%3E%3A%3C%2FSTRONG%3EThis%20newly%20added%20foreach%20enumerator%20enables%20you%20to%20list%20files%20in%20a%20specified%20folder%20on%20ADLS%20Gen2.%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3EMinor%20updates%20include%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fsql%2Fintegration-services%2Fazure-feature-pack-for-integration-services-ssis%23dependency-on-java%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3ESupport%20Zulu%E2%80%99s%20OpenJDK%3C%2FA%3E.%3C%2FLI%3E%0A%3CLI%3EAdded%20%3CSTRONG%3ESearchRecursively%3C%2FSTRONG%3Eoption%20to%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fsql%2Fintegration-services%2Fcontrol-flow%2Fazure-blob-download-task%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CSTRONG%3EAzure%20Blob%20Download%3C%2FSTRONG%3E%3C%2FA%3E%2F%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fsql%2Fintegration-services%2Fcontrol-flow%2Fazure-blob-upload-task%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CSTRONG%3EUpload%20Task%3C%2FSTRONG%3E%3C%2FA%3E%2C%20and%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fsql%2Fintegration-services%2Fcontrol-flow%2Fforeach-loop-container%23ForeachAzureBlob%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CSTRONG%3EForeach%20Azure%20Blob%20Enumerator%3C%2FSTRONG%3E%3C%2FA%3E.%3C%2FLI%3E%0A%3C%2FUL%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%3D47367%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EAzure%20Feature%20Pack%20for%20SQL%20Server%202012%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_self%22%20rel%3D%22noopener%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%3D49492%22%20target%3D%22_self%22%20rel%3D%22noopener%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%3D54798%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EAzure%20Feature%20Pack%20for%20SQL%20Server%202017%3C%2FA%3E%3C%2FLI%3E%0A%3C%2FUL%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-830672%22%20slang%3D%22en-US%22%3E%3CP%3EAzure%20Feature%20Pack%201.14.0%20is%20here%2C%20which%20enables%20you%20to%20connect%20to%20%3CA%20href%3D%22https%3A%2F%2Fnam06.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Fdocs.microsoft.com%252Fazure%252Fstorage%252Fblobs%252Fdata-lake-storage-introduction%26amp%3Bdata%3D02%257C01%257Clingxl%2540microsoft.com%257C1d2ad14d1da74bd7c37908d72d059176%257C72f988bf86f141af91ab2d7cd011db47%257C1%257C0%257C637027374248258452%26amp%3Bsdata%3Dn96Hkjs33L2Nv7c6taCh%252BbT3czQvUOjdlRK9vYNabx0%253D%26amp%3Breserved%3D0%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAzure%20Data%20Lake%20Storage%20Gen2%3C%2FA%3E(ADLS%20Gen2).%3C%2FP%3E%3C%2FLINGO-TEASER%3E
Microsoft

Dear SSIS Users,

 

Azure Feature Pack 1.14.0 is here, which enables you to connect to Azure Data Lake Storage Gen2 (ADLS Gen2).

 

Major updates include

  • Azure Storage Connection Manager: The improved Azure Storage Connection Manager now supports both Blob Storage and Data Lake Storage Gen2 services of Azure Storage. We have also added a service principal authentication method on top of the access key one. When you run your packages on Azure-SSIS IR, you have cloud-only security features at your disposal. For example, when you use Execute SSIS Package activities in Azure Data Factory (ADF) pipelines, you can store the sensitive values for account/application keys and application/tenant IDs as secrets in Azure Key Vault (AKV). On top of that, you can do away with sensitive values altogether and authenticate using the managed identity of hosting ADF.
  • Flexible File Task: This newly added task is designed to support different kinds of file operations on various supported storage services.
    Currently, only Copy operation is provided, and the supported storage services for source/destination are local file system, Blob Storage, and ADLS Gen2.
    We expect to support more operations and storage services in the future.
  • Flexible File Source/Destination: Like Flexible File Task, the source/destination is designed to support various storage services.
    Currently, Blob Storage and ADLS Gen2 are supported.
  • Foreach Data Lake Storage Gen2 File Enumerator: This newly added foreach enumerator enables you to list files in a specified folder on ADLS Gen2.

Minor updates include

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