Home
%3CLINGO-SUB%20id%3D%22lingo-sub-796527%22%20slang%3D%22en-US%22%3ERun%20SSIS%20Package%20in%20Azure%20via%20SSDT%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-796527%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20feature%20of%20Azure-enabled%20SQL%20Server%20Integration%20Services%20(SSIS)%20projects%20on%20SQL%20Server%20Data%20Tools%20(SSDT)%20allows%20you%20to%20run%20packages%20on%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fdata-factory%2Fcreate-azure-ssis-integration-runtime%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAzure-SSIS%20Integration%20Runtime%3C%2FA%3E(IR)%20in%20Azure%20Data%20Factory%20(ADF).%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20can%20download%20below%20SSDT%20versions%20to%20use%20the%20feature%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Fssdt%2Fdownload-sql-server-data-tools-ssdt%3Fview%3Dsql-server-2017%23ssdt-for-vs-2017-standalone-installer%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EVS%202017%20SSDT%20version%2015.9.2%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fmarketplace.visualstudio.com%2Fitems%3FitemName%3DSSIS.SqlServerIntegrationServicesProjects%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EVS%202019%20Integration%20Service%20extension%2C%20version%203.1%3C%2FA%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESample%20SSIS%20package%20is%20to%20transfer%20data%20from%20on-premises%20file%20(E%3A%5CInput.txt)%20to%20Azure%20SQL.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20315px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F126337iD052C2DA05FB37B8%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%221.png%22%20title%3D%221.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20can%20perform%20below%20operations%20to%20run%20that%20package%20in%20Azure%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EStep%201%3C%2FSTRONG%3E%3A%20Azure-enabling%20your%20SSIS%20project.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20728px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F126323i6646D537E77478BB%2Fimage-dimensions%2F728x182%3Fv%3D1.0%22%20width%3D%22728%22%20height%3D%22182%22%20alt%3D%22clipboard_image_1.png%22%20title%3D%22clipboard_image_1.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EPlease%20note%2C%20it%20requires%20you%20to%20set%20target%20server%20version%20of%20SSIS%20project%20to%20be%20the%20latest%20one%20supported%20by%20Azure-SSIS%20IR%2C%20which%20is%20currently%26nbsp%3B%3CSTRONG%3ESQL%20Server%202017%3C%2FSTRONG%3E.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EStep%202%3C%2FSTRONG%3E%3A%20Connect%20your%20project%20to%20SSIS%20Platform-as-a-Service%20(PaaS)%20in%20Azure%20Data%20Factory.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20546px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F126322i77CF14C108E1F3F8%2Fimage-dimensions%2F546x71%3Fv%3D1.0%22%20width%3D%22546%22%20height%3D%2271%22%20alt%3D%22clipboard_image_2.png%22%20title%3D%22clipboard_image_2.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOn%20the%26nbsp%3B%3CSTRONG%3ESelect%20SSIS%20IR%20in%20ADF%3C%2FSTRONG%3E%26nbsp%3Bpage%2C%20select%20your%20existing%20ADF%20and%20Azure-SSIS%20IR%20to%20run%20packages%20or%20create%20new%20ones%20if%20you%20do%20not%20have%20any.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20568px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F126324i25E39DA47DD7F63B%2Fimage-dimensions%2F568x368%3Fv%3D1.0%22%20width%3D%22568%22%20height%3D%22368%22%20alt%3D%22clipboard_image_3.png%22%20title%3D%22clipboard_image_3.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20your%20existing%20Azure%20subscription%20does%20not%20have%20any%20Azure%20Data%20Factory%2C%20you%20can%20click%20on%20the%26nbsp%3B%3CSTRONG%3ECreate%20SSIS%20IR%3C%2FSTRONG%3E%26nbsp%3Bbutton%20to%20launch%20the%26nbsp%3B%3CSTRONG%3EIntegration%20Runtime%20Creation%20Wizard%3C%2FSTRONG%3E%2C%20where%20you%20can%20enter%20the%20location%20and%20prefix%20for%20us%20to%20automatically%20create%20a%20new%20Azure%20Resource%20Group%2C%20Data%20Factory%2C%20and%20SSIS%20IR%20on%20your%20behalf.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20567px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F126325i58D2EE0074E1D739%2Fimage-dimensions%2F567x353%3Fv%3D1.0%22%20width%3D%22567%22%20height%3D%22353%22%20alt%3D%22clipboard_image_4.png%22%20title%3D%22clipboard_image_4.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOn%20the%26nbsp%3B%3CSTRONG%3ESelect%20Azure%20Storage%3C%2FSTRONG%3E%26nbsp%3Bpage%2C%20select%20your%20existing%20Azure%20Storage%20account%20to%20upload%20packages%20into%20Azure%20Files%20or%20create%20a%20new%20one%20if%20you%20do%20not%20have%20any.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20568px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F126326iFD1397B4233A15AF%2Fimage-dimensions%2F568x238%3Fv%3D1.0%22%20width%3D%22568%22%20height%3D%22238%22%20alt%3D%22clipboard_image_5.png%22%20title%3D%22clipboard_image_5.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EStep%203%3C%2FSTRONG%3E%3A%20Run%20your%20package%20in%20Azure%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20566px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F126328i8C5D4431DCF0AC3E%2Fimage-dimensions%2F566x173%3Fv%3D1.0%22%20width%3D%22566%22%20height%3D%22173%22%20alt%3D%22clipboard_image_6.png%22%20title%3D%22clipboard_image_6.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20your%20Azure-SSIS%20Integration%20Runtime%20is%20not%20started%2C%20a%20dialog%20window%20will%20pop%20up%20to%20start%20it.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20700px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F126333iDFAD303D61FFC8AD%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22IR_Start.png%22%20title%3D%22IR_Start.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EYou%20will%20be%20able%20to%20see%20the%20logs%20of%20execution%20on%20the%20%E2%80%9CProgress%E2%80%9D%20tab%20same%20as%20local%20run%20and%20log%20content%20will%20be%20refreshed%20every%20minute%20until%20execution%20completes.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20580px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F126329iC685A955C9516695%2Fimage-dimensions%2F580x561%3Fv%3D1.0%22%20width%3D%22580%22%20height%3D%22561%22%20alt%3D%22clipboard_image_8.png%22%20title%3D%22clipboard_image_8.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EStep%204%3C%2FSTRONG%3E%3A%20Adjust%20your%20package%20to%20solve%20compatibility%20issue%20if%20there%20is%3C%2FP%3E%0A%3CP%3EYou%20might%20see%20package%20execution%20failed%20as%20above%20if%20there%20is%20some%20compatibility%20issue%20to%20lift%20%26amp%3B%20shift%20your%20package%20from%20on-prem%20to%20cloud.%20For%20this%20sample%20package%2C%20as%20it%20refers%20to%20a%20on-premises%20file%20which%20Azure-SSIS%20Integration%20Runtime%20can%E2%80%99t%20access%20directly%2C%20package%20execution%20will%20fail.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20can%20have%203%20options%20to%20solve%20the%20problem%3A%3C%2FP%3E%0A%3COL%3E%0A%3CLI%3ELeverage%20Azure%20File%20share%20to%20store%20the%20file%20and%20configure%20Azure-SSIS%20IR%20to%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Fintegration-services%2Flift-shift%2Fssis-azure-connect-with-windows-auth%3Fview%3Dsql-server-2017%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Eaccess%20that%20Azure%20File%20share%20via%20cmdkey%20with%20custom%20setup%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3EPut%20file%20into%20on-premises%20file%20share%20and%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fdata-factory%2Fjoin-azure-ssis-integration-runtime-virtual-network%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ejoin%20Azure-SSIS%20IR%20into%20VNet%3C%2FA%3Eto%20access%20on-premises%20file%20share%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fdata-factory%2Fself-hosted-integration-runtime-proxy-ssis%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EConfigure%20Self-Hosted%20IR%20as%20proxy%3C%2FA%3Eto%20access%20on-premises%20file%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CP%3ETake%20option%201%20as%20example%2C%20upload%20file%20to%20%5C%5Cssisdemotest.file.core.windows.net%5Cshare%5CInput.txt%20and%20then%20update%20file%20connection%20manager%20in%20package%20to%20refer%20to%20new%20file%20location.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20594px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F126330i008503366F6E21AF%2Fimage-dimensions%2F594x159%3Fv%3D1.0%22%20width%3D%22594%22%20height%3D%22159%22%20alt%3D%22clipboard_image_9.png%22%20title%3D%22clipboard_image_9.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EThen%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fdata-factory%2Fhow-to-configure-azure-ssis-ir-custom-setup%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Econfigure%20your%20Azure-SSIS%20IR%20with%20custom%20setup%20script%3C%2FA%3E%3A%3C%2FP%3E%0A%3CP%3E%3CEM%3Ecmdkey%20%2Fadd%3Assisdemotest.file.core.windows.net%20%2Fuser%3Aazure%5Cssisdemotest%20%2Fpass%3A%20%5Bstorage_key%5D%3C%2FEM%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETry%20to%20execute%20package%20in%20Azure%20again%20and%20execution%20will%20pass.%3C%2FP%3E%0A%3CP%3E%3CEM%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20610px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F126331i28340BD6A1B771E6%2Fimage-dimensions%2F610x272%3Fv%3D1.0%22%20width%3D%22610%22%20height%3D%22272%22%20alt%3D%22clipboard_image_10.png%22%20title%3D%22clipboard_image_10.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FEM%3E%3C%2FP%3E%0A%3CP%3E%3CEM%3E%26nbsp%3B%3C%2FEM%3E%3C%2FP%3E%0A%3CP%3EFor%20more%20information%20about%20Azure-Enabled%20feature%2C%20please%20refer%20to%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fdata-factory%2Fhow-to-invoke-ssis-package-ssdt%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fdata-factory%2Fhow-to-invoke-ssis-package-ssdt%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-796527%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20728px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F126323i6646D537E77478BB%2Fimage-dimensions%2F728x182%3Fv%3D1.0%22%20width%3D%22728%22%20height%3D%22182%22%20alt%3D%22clipboard_image_1.png%22%20title%3D%22clipboard_image_1.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EThe%20feature%20of%20Azure-enabled%20SQL%20Server%20Integration%20Services%20(SSIS)%20projects%20on%20SQL%20Server%20Data%20Tools%20(SSDT)%20allows%20you%20to%20run%20packages%20on%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fdata-factory%2Fcreate-azure-ssis-integration-runtime%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAzure-SSIS%20Integration%20Runtime%3C%2FA%3E(IR)%20in%20Azure%20Data%20Factory%20(ADF).%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-SUB%20id%3D%22lingo-sub-822339%22%20slang%3D%22en-US%22%3ERe%3A%20Run%20SSIS%20Package%20in%20Azure%20via%20SSDT%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-822339%22%20slang%3D%22en-US%22%3E%3CP%3EAmazing%20feature!%20Tried%20today%20myself%2C%20but%20i%20keep%20getting%20a%20error%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20710px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F128497i779E4CD070ED779F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22V6bL4yF.png%22%20title%3D%22V6bL4yF.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EVS%20is%20a%20new%20install%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-826153%22%20slang%3D%22en-US%22%3ERe%3A%20Run%20SSIS%20Package%20in%20Azure%20via%20SSDT%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-826153%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20turn%20out%20to%20be%20a%20bug%20in%20product%20that%20package%20with%20container%20will%20fail%20when%20execute%20in%20Azure%20and%20it%20will%20be%20fixed%20in%20next%20release.%20Thanks%20for%20reporting.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Microsoft

The feature of Azure-enabled SQL Server Integration Services (SSIS) projects on SQL Server Data Tools (SSDT) allows you to run packages on Azure-SSIS Integration Runtime (IR) in Azure Data Factory (ADF).

 

You can download below SSDT versions to use the feature:

 

Sample SSIS package is to transfer data from on-premises file (E:\Input.txt) to Azure SQL.

1.png

 

You can perform below operations to run that package in Azure:

 

Step 1: Azure-enabling your SSIS project.

clipboard_image_1.png

Please note, it requires you to set target server version of SSIS project to be the latest one supported by Azure-SSIS IR, which is currently SQL Server 2017.

 

Step 2: Connect your project to SSIS Platform-as-a-Service (PaaS) in Azure Data Factory.

clipboard_image_2.png

 

On the Select SSIS IR in ADF page, select your existing ADF and Azure-SSIS IR to run packages or create new ones if you do not have any.

clipboard_image_3.png

 

If your existing Azure subscription does not have any Azure Data Factory, you can click on the Create SSIS IR button to launch the Integration Runtime Creation Wizard, where you can enter the location and prefix for us to automatically create a new Azure Resource Group, Data Factory, and SSIS IR on your behalf.

clipboard_image_4.png

 

On the Select Azure Storage page, select your existing Azure Storage account to upload packages into Azure Files or create a new one if you do not have any.

clipboard_image_5.png

 

Step 3: Run your package in Azure

clipboard_image_6.png

 

If your Azure-SSIS Integration Runtime is not started, a dialog window will pop up to start it.

IR_Start.png

You will be able to see the logs of execution on the “Progress” tab same as local run and log content will be refreshed every minute until execution completes.

clipboard_image_8.png

 

Step 4: Adjust your package to solve compatibility issue if there is

You might see package execution failed as above if there is some compatibility issue to lift & shift your package from on-prem to cloud. For this sample package, as it refers to a on-premises file which Azure-SSIS Integration Runtime can’t access directly, package execution will fail.

 

You can have 3 options to solve the problem:

  1. Leverage Azure File share to store the file and configure Azure-SSIS IR to access that Azure File share via cmdkey with custom setup
  2. Put file into on-premises file share and join Azure-SSIS IR into VNet to access on-premises file share
  3. Configure Self-Hosted IR as proxy to access on-premises file

Take option 1 as example, upload file to \\ssisdemotest.file.core.windows.net\share\Input.txt and then update file connection manager in package to refer to new file location.

clipboard_image_9.png

Then configure your Azure-SSIS IR with custom setup script:

cmdkey /add:ssisdemotest.file.core.windows.net /user:azure\ssisdemotest /pass: [storage_key]

 

Try to execute package in Azure again and execution will pass.

clipboard_image_10.png

 

For more information about Azure-Enabled feature, please refer to

https://docs.microsoft.com/en-us/azure/data-factory/how-to-invoke-ssis-package-ssdt

2 Comments
Frequent Visitor

Amazing feature! Tried today myself, but i keep getting a error:

V6bL4yF.png

 

VS is a new install :)

 

Microsoft

This turn out to be a bug in product that package with container will fail when execute in Azure and it will be fixed in next release. Thanks for reporting.