Home
%3CLINGO-SUB%20id%3D%22lingo-sub-565923%22%20slang%3D%22en-US%22%3EMicrosoft%20Connector%20for%20Oracle%20is%20released%20for%20SQL%20Server%202019%20Preview%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-565923%22%20slang%3D%22en-US%22%3E%3CP%3EMicrosoft%20Connector%20for%20Oracle%26nbsp%3B%20is%20the%20replacement%20of%20Attunity%20Oracle%20Connector%20starting%20from%20SQL%20Server%202019%20and%20now%20it%20is%20released%20for%20preview.%20Microsoft%20Connector%20for%20Oracle%20provides%20compatibility%20with%20Attunity%20Oracle%20Connector%20in%20functionality%20and%20performance.%20Packages%20designed%20with%20Attunity%20Oracle%20Connector%20can%20run%20with%20Microsoft%20Connector%20for%20Oracle%20without%20any%20changes.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMicrosoft%20Connector%20for%20Oracle%20is%20supported%20in%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3COL%3E%0A%3CLI%3ESQL%20Server%202019%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CP%3EUser%20can%20download%20%3CA%20href%3D%22https%3A%2F%2Fwww.microsoft.com%2Fen-us%2Fdownload%2Fdetails.aspx%3Fid%3D58228%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EMicrosoft%20Connector%20for%20Oracle%20V1.0%20(SQL%20Server%202019)%20-%20Preview%3C%2FA%3E%20for%20executing%20Oracle%20packages%20in%20SQL%20Server%202019.%20For%20Microsoft%20Oracle%20Connector%2C%20Oracle%20client%20is%20not%20required.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3COL%20start%3D%222%22%3E%0A%3CLI%3ESQL%20Server%20Data%20Tools%20(SSDT)%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CP%3EMicrosoft%20Connector%20for%20Oracle%20has%20is%20shipped%20in%20SSDT%20for%20VS%202017%20since%20version%2015.9.0%2C%20as%20well%20as%20in%20SSIS%20projects%20for%20VS%202019.%20Users%20do%20not%20need%20extra%20installation%20of%20Oracle%20connector%20when%20designing%20packages%20targeting%20SQL%20Server%202019.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH1%20id%3D%22toc-hId-1932680903%22%20id%3D%22toc-hId-1932681058%22%20id%3D%22toc-hId-1932681058%22%20id%3D%22toc-hId-1932681058%22%20id%3D%22toc-hId-1932681058%22%20id%3D%22toc-hId-1932681058%22%20id%3D%22toc-hId-1932681058%22%20id%3D%22toc-hId-1932681058%22%20id%3D%22toc-hId-1932681058%22%20id%3D%22toc-hId-1932681058%22%20id%3D%22toc-hId-1932681058%22%20id%3D%22toc-hId-1932681058%22%20id%3D%22toc-hId-1932681058%22%20id%3D%22toc-hId-1932681058%22%20id%3D%22toc-hId-1932681058%22%20id%3D%22toc-hId-1932681058%22%20id%3D%22toc-hId-1932681058%22%20id%3D%22toc-hId-1932681058%22%20id%3D%22toc-hId-1932681058%22%20id%3D%22toc-hId-1932681058%22%20id%3D%22toc-hId-1932681058%22%20id%3D%22toc-hId-1932681058%22%20id%3D%22toc-hId-1932681058%22%20id%3D%22toc-hId-1932681058%22%20id%3D%22toc-hId-1932681058%22%20id%3D%22toc-hId-1932681058%22%20id%3D%22toc-hId-1932681058%22%20id%3D%22toc-hId-1932681058%22%20id%3D%22toc-hId-1932681058%22%20id%3D%22toc-hId-1932681058%22%20id%3D%22toc-hId-1932681058%22%20id%3D%22toc-hId-1932681058%22%20id%3D%22toc-hId-1932681058%22%20id%3D%22toc-hId-1932681058%22%20id%3D%22toc-hId-1932681058%22%20id%3D%22toc-hId-1932681058%22%20id%3D%22toc-hId-1932681058%22%20id%3D%22toc-hId-1932681058%22%20id%3D%22toc-hId-1932681058%22%20id%3D%22toc-hId-1932681058%22%20id%3D%22toc-hId-1932681058%22%20id%3D%22toc-hId-1932681058%22%3EUsing%20Oracle%20Connector%20in%20SQL%20Server%20Data%20Tools%20(SSDT)%2015.9.x%20for%20VS%202017%20or%20SSIS%20Projects%20for%20VS%202019%3C%2FH1%3E%0A%3CP%3EMicrosoft%20Connector%20for%20Oracle%20has%20been%20shipped%20in%20SSDT%20for%20VS%202017%20since%2015.9.0%20and%20SSIS%20Projects%20for%20VS%202019.%20User%20can%20use%20Microsoft%20Connector%20for%20Oracle%20to%20design%20packages%20targeting%20to%20SQL%20Server%202019%20and%20pre-2019.%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId--815989563%22%20id%3D%22toc-hId--815989408%22%20id%3D%22toc-hId--815989408%22%20id%3D%22toc-hId--815989408%22%20id%3D%22toc-hId--815989408%22%20id%3D%22toc-hId--815989408%22%20id%3D%22toc-hId--815989408%22%20id%3D%22toc-hId--815989408%22%20id%3D%22toc-hId--815989408%22%20id%3D%22toc-hId--815989408%22%20id%3D%22toc-hId--815989408%22%20id%3D%22toc-hId--815989408%22%20id%3D%22toc-hId--815989408%22%20id%3D%22toc-hId--815989408%22%20id%3D%22toc-hId--815989408%22%20id%3D%22toc-hId--815989408%22%20id%3D%22toc-hId--815989408%22%20id%3D%22toc-hId--815989408%22%20id%3D%22toc-hId--815989408%22%20id%3D%22toc-hId--815989408%22%20id%3D%22toc-hId--815989408%22%20id%3D%22toc-hId--815989408%22%20id%3D%22toc-hId--815989408%22%20id%3D%22toc-hId--815989408%22%20id%3D%22toc-hId--815989408%22%20id%3D%22toc-hId--815989408%22%20id%3D%22toc-hId--815989408%22%20id%3D%22toc-hId--815989408%22%20id%3D%22toc-hId--815989408%22%20id%3D%22toc-hId--815989408%22%20id%3D%22toc-hId--815989408%22%20id%3D%22toc-hId--815989408%22%20id%3D%22toc-hId--815989408%22%20id%3D%22toc-hId--815989408%22%20id%3D%22toc-hId--815989408%22%20id%3D%22toc-hId--815989408%22%20id%3D%22toc-hId--815989408%22%20id%3D%22toc-hId--815989408%22%20id%3D%22toc-hId--815989408%22%20id%3D%22toc-hId--815989408%22%20id%3D%22toc-hId--815989408%22%20id%3D%22toc-hId--815989408%22%3EDesign%20new%20SSIS%20packages%3C%2FH2%3E%0A%3CP%3EOpen%20SSDT%2015.9.x%2C%20Oracle%20components%20can%20be%20found%20in%20SSIS%20Toolbox%2C%20under%20Common%20Category.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20201px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F113249iDBB08B5E54E40E9E%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%3EAnd%20in%20Connection%20Managers%2C%20Oracle%20connection%20manager%20is%20displayed%20with%20type%20%E2%80%9C%3CSTRONG%3EORACLE%3C%2FSTRONG%3E%E2%80%9D.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20522px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F113251iD28C1190DC31D148%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%222.png%22%20title%3D%222.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EMicrosoft%20Connector%20for%20Oracle%20provides%20similar%20user%20experience%20with%20Attunity%20Oracle%20Connector.%20User%20can%20design%20new%20packages%20based%20on%20previous%20experience.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20design%20time%2C%20no%20matter%20which%20SQL%20Server%20version%20the%20project%20is%20targeting%2C%20no%20extra%20dependency%20is%20required%20to%20be%20installed.%20If%20user%20wants%20to%20use%20TNS%20service%20name%20in%20tnsnames.ora%20for%20connecting%20to%20Oracle%20Server%2C%20there%20are%20a%20few%20ways%20to%20achieve%20this%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3COL%3E%0A%3CLI%3EInstall%20Oracle%20client%20and%20create%20tnsnames.ora%20in%20network%5Cadmin%20under%20Oracle%20client%20path.%20This%20is%20exactly%20the%20same%20with%20Attunity%20Oracle%20connector.%3C%2FLI%3E%0A%3CLI%3ECreate%20tnsnames.ora%20under%20any%20local%20directory%20and%20add%20a%20TNS_ADMIN%20system%20environment%20variable%20which%20value%20is%20the%20tnsnames.ora%20directory%20path.%3C%2FLI%3E%0A%3CLI%3ECreate%20tnsnames.ora%20under%20any%20local%20directory%20and%20set%20the%20direct%20path%20to%20OracleHome%20property%20in%20Oracle%20connection%20manager%20advanced%20editor.%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CH2%20id%3D%22toc-hId-926820772%22%20id%3D%22toc-hId-926820927%22%20id%3D%22toc-hId-926820927%22%20id%3D%22toc-hId-926820927%22%20id%3D%22toc-hId-926820927%22%20id%3D%22toc-hId-926820927%22%20id%3D%22toc-hId-926820927%22%20id%3D%22toc-hId-926820927%22%20id%3D%22toc-hId-926820927%22%20id%3D%22toc-hId-926820927%22%20id%3D%22toc-hId-926820927%22%20id%3D%22toc-hId-926820927%22%20id%3D%22toc-hId-926820927%22%20id%3D%22toc-hId-926820927%22%20id%3D%22toc-hId-926820927%22%20id%3D%22toc-hId-926820927%22%20id%3D%22toc-hId-926820927%22%20id%3D%22toc-hId-926820927%22%20id%3D%22toc-hId-926820927%22%20id%3D%22toc-hId-926820927%22%20id%3D%22toc-hId-926820927%22%20id%3D%22toc-hId-926820927%22%20id%3D%22toc-hId-926820927%22%20id%3D%22toc-hId-926820927%22%20id%3D%22toc-hId-926820927%22%20id%3D%22toc-hId-926820927%22%20id%3D%22toc-hId-926820927%22%20id%3D%22toc-hId-926820927%22%20id%3D%22toc-hId-926820927%22%20id%3D%22toc-hId-926820927%22%20id%3D%22toc-hId-926820927%22%20id%3D%22toc-hId-926820927%22%20id%3D%22toc-hId-926820927%22%20id%3D%22toc-hId-926820927%22%20id%3D%22toc-hId-926820927%22%20id%3D%22toc-hId-926820927%22%20id%3D%22toc-hId-926820927%22%20id%3D%22toc-hId-926820927%22%20id%3D%22toc-hId-926820927%22%20id%3D%22toc-hId-926820927%22%20id%3D%22toc-hId-926820927%22%20id%3D%22toc-hId-926820927%22%3E%26nbsp%3B%3C%2FH2%3E%0A%3CH2%20id%3D%22toc-hId--1625336189%22%20id%3D%22toc-hId--1625336034%22%20id%3D%22toc-hId--1625336034%22%20id%3D%22toc-hId--1625336034%22%20id%3D%22toc-hId--1625336034%22%20id%3D%22toc-hId--1625336034%22%20id%3D%22toc-hId--1625336034%22%20id%3D%22toc-hId--1625336034%22%20id%3D%22toc-hId--1625336034%22%20id%3D%22toc-hId--1625336034%22%20id%3D%22toc-hId--1625336034%22%20id%3D%22toc-hId--1625336034%22%20id%3D%22toc-hId--1625336034%22%20id%3D%22toc-hId--1625336034%22%20id%3D%22toc-hId--1625336034%22%20id%3D%22toc-hId--1625336034%22%20id%3D%22toc-hId--1625336034%22%20id%3D%22toc-hId--1625336034%22%20id%3D%22toc-hId--1625336034%22%20id%3D%22toc-hId--1625336034%22%20id%3D%22toc-hId--1625336034%22%20id%3D%22toc-hId--1625336034%22%20id%3D%22toc-hId--1625336034%22%20id%3D%22toc-hId--1625336034%22%20id%3D%22toc-hId--1625336034%22%20id%3D%22toc-hId--1625336034%22%20id%3D%22toc-hId--1625336034%22%20id%3D%22toc-hId--1625336034%22%20id%3D%22toc-hId--1625336034%22%20id%3D%22toc-hId--1625336034%22%20id%3D%22toc-hId--1625336034%22%20id%3D%22toc-hId--1625336034%22%20id%3D%22toc-hId--1625336034%22%20id%3D%22toc-hId--1625336034%22%20id%3D%22toc-hId--1625336034%22%20id%3D%22toc-hId--1625336034%22%20id%3D%22toc-hId--1625336034%22%20id%3D%22toc-hId--1625336034%22%20id%3D%22toc-hId--1625336034%22%20id%3D%22toc-hId--1625336034%22%20id%3D%22toc-hId--1625336034%22%20id%3D%22toc-hId--1625336034%22%3EOpen%20and%20Execute%20existing%20SSIS%20packages%3C%2FH2%3E%0A%3CP%3EExisting%20SSIS%20packages%20which%20have%20been%20designed%20with%20Attunity%20Oracle%20Connector%20will%20be%20automatically%20upgraded%20to%20use%20Microsoft%20Connector%20for%20Oracle.%20The%20icons%20will%20be%20changed%20as%20well.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAfter%20successfully%20opening%20existing%20packages%2C%20users%20can%20redesign%20or%20execute%20package%2C%20or%20change%20the%20target%20SQL%20Server%20version%20for%20the%20project.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId-117474146%22%20id%3D%22toc-hId-117474301%22%20id%3D%22toc-hId-117474301%22%20id%3D%22toc-hId-117474301%22%20id%3D%22toc-hId-117474301%22%20id%3D%22toc-hId-117474301%22%20id%3D%22toc-hId-117474301%22%20id%3D%22toc-hId-117474301%22%20id%3D%22toc-hId-117474301%22%20id%3D%22toc-hId-117474301%22%20id%3D%22toc-hId-117474301%22%20id%3D%22toc-hId-117474301%22%20id%3D%22toc-hId-117474301%22%20id%3D%22toc-hId-117474301%22%20id%3D%22toc-hId-117474301%22%20id%3D%22toc-hId-117474301%22%20id%3D%22toc-hId-117474301%22%20id%3D%22toc-hId-117474301%22%20id%3D%22toc-hId-117474301%22%20id%3D%22toc-hId-117474301%22%20id%3D%22toc-hId-117474301%22%20id%3D%22toc-hId-117474301%22%20id%3D%22toc-hId-117474301%22%20id%3D%22toc-hId-117474301%22%20id%3D%22toc-hId-117474301%22%20id%3D%22toc-hId-117474301%22%20id%3D%22toc-hId-117474301%22%20id%3D%22toc-hId-117474301%22%20id%3D%22toc-hId-117474301%22%20id%3D%22toc-hId-117474301%22%20id%3D%22toc-hId-117474301%22%20id%3D%22toc-hId-117474301%22%20id%3D%22toc-hId-117474301%22%20id%3D%22toc-hId-117474301%22%20id%3D%22toc-hId-117474301%22%20id%3D%22toc-hId-117474301%22%20id%3D%22toc-hId-117474301%22%20id%3D%22toc-hId-117474301%22%20id%3D%22toc-hId-117474301%22%20id%3D%22toc-hId-117474301%22%20id%3D%22toc-hId-117474301%22%20id%3D%22toc-hId-117474301%22%3EExecute%20SSIS%20packages%3C%2FH2%3E%0A%3CH3%20id%3D%22toc-hId-1663770976%22%20id%3D%22toc-hId-1663771131%22%20id%3D%22toc-hId-1663771131%22%20id%3D%22toc-hId-1663771131%22%20id%3D%22toc-hId-1663771131%22%20id%3D%22toc-hId-1663771131%22%20id%3D%22toc-hId-1663771131%22%20id%3D%22toc-hId-1663771131%22%20id%3D%22toc-hId-1663771131%22%20id%3D%22toc-hId-1663771131%22%20id%3D%22toc-hId-1663771131%22%20id%3D%22toc-hId-1663771131%22%20id%3D%22toc-hId-1663771131%22%20id%3D%22toc-hId-1663771131%22%20id%3D%22toc-hId-1663771131%22%20id%3D%22toc-hId-1663771131%22%20id%3D%22toc-hId-1663771131%22%20id%3D%22toc-hId-1663771131%22%20id%3D%22toc-hId-1663771131%22%20id%3D%22toc-hId-1663771131%22%20id%3D%22toc-hId-1663771131%22%20id%3D%22toc-hId-1663771131%22%20id%3D%22toc-hId-1663771131%22%20id%3D%22toc-hId-1663771131%22%20id%3D%22toc-hId-1663771131%22%20id%3D%22toc-hId-1663771131%22%20id%3D%22toc-hId-1663771131%22%20id%3D%22toc-hId-1663771131%22%20id%3D%22toc-hId-1663771131%22%20id%3D%22toc-hId-1663771131%22%20id%3D%22toc-hId-1663771131%22%20id%3D%22toc-hId-1663771131%22%20id%3D%22toc-hId-1663771131%22%20id%3D%22toc-hId-1663771131%22%20id%3D%22toc-hId-1663771131%22%20id%3D%22toc-hId-1663771131%22%20id%3D%22toc-hId-1663771131%22%20id%3D%22toc-hId-1663771131%22%20id%3D%22toc-hId-1663771131%22%20id%3D%22toc-hId-1663771131%22%20id%3D%22toc-hId-1663771131%22%20id%3D%22toc-hId-1663771131%22%3EExecute%20packages%20targeting%20SQL%20Server%202019%3C%2FH3%3E%0A%3CP%3EIf%20the%20project%20is%20targeting%20SQL%20Server%202019%2C%20there%20is%20no%20extra%20dependency%20for%20execution.%20Oracle%20client%20is%20not%20required.%20User%20can%20directly%20execute%20and%20debug%20package.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH3%20id%3D%22toc-hId--888385985%22%20id%3D%22toc-hId--888385830%22%20id%3D%22toc-hId--888385830%22%20id%3D%22toc-hId--888385830%22%20id%3D%22toc-hId--888385830%22%20id%3D%22toc-hId--888385830%22%20id%3D%22toc-hId--888385830%22%20id%3D%22toc-hId--888385830%22%20id%3D%22toc-hId--888385830%22%20id%3D%22toc-hId--888385830%22%20id%3D%22toc-hId--888385830%22%20id%3D%22toc-hId--888385830%22%20id%3D%22toc-hId--888385830%22%20id%3D%22toc-hId--888385830%22%20id%3D%22toc-hId--888385830%22%20id%3D%22toc-hId--888385830%22%20id%3D%22toc-hId--888385830%22%20id%3D%22toc-hId--888385830%22%20id%3D%22toc-hId--888385830%22%20id%3D%22toc-hId--888385830%22%20id%3D%22toc-hId--888385830%22%20id%3D%22toc-hId--888385830%22%20id%3D%22toc-hId--888385830%22%20id%3D%22toc-hId--888385830%22%20id%3D%22toc-hId--888385830%22%20id%3D%22toc-hId--888385830%22%20id%3D%22toc-hId--888385830%22%20id%3D%22toc-hId--888385830%22%20id%3D%22toc-hId--888385830%22%20id%3D%22toc-hId--888385830%22%20id%3D%22toc-hId--888385830%22%20id%3D%22toc-hId--888385830%22%20id%3D%22toc-hId--888385830%22%20id%3D%22toc-hId--888385830%22%20id%3D%22toc-hId--888385830%22%20id%3D%22toc-hId--888385830%22%20id%3D%22toc-hId--888385830%22%20id%3D%22toc-hId--888385830%22%20id%3D%22toc-hId--888385830%22%20id%3D%22toc-hId--888385830%22%20id%3D%22toc-hId--888385830%22%20id%3D%22toc-hId--888385830%22%3EExecute%20package%20targeting%20Pre-SQL%20Server%202019%3C%2FH3%3E%0A%3CP%3EIf%20the%20project%20is%20targeting%20Pre-SQL%20Server%202019%2C%20corresponding%20Attunity%20Oracle%20Connector%20and%20Oracle%20client%20are%20required%20to%20be%20installed%20on%20the%20SSDT%20machine%20for%20package%20execution.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAttunity%20Oracle%20Connector%20download%20links%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fwww.microsoft.com%2Fen-us%2Fdownload%2Fdetails.aspx%3Fid%3D55179%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EMicrosoft%20Connector%20Version%205.0%20for%20Oracle%20by%20Attunity%20targeting%20SQL%20Server%202017%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fwww.microsoft.com%2Fen-us%2Fdownload%2Fdetails.aspx%3Fid%3D52950%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EMicrosoft%20Connector%20Version%204.0%20for%20Oracle%20by%20Attunity%20targeting%20SQL%20Server%202016%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fwww.microsoft.com%2Fen-us%2Fdownload%2Fdetails.aspx%3Fid%3D44582%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EMicrosoft%20Connector%20Version%203.0%20for%20Oracle%20by%20Attunity%20targeting%20SQL%20Server%202014%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fwww.microsoft.com%2Fen-us%2Fdownload%2Fdetails.aspx%3Fid%3D29283%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EMicrosoft%20Connector%20Version%202.0%20for%20Oracle%20by%20Attunity%20targeting%20SQL%20Server%202012%3C%2FA%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3EThe%20required%20Attunity%20Oracle%20Connector%20and%20Oracle%20client%20platform%20version%20depends%20on%20project%20debug%20config%2C%20as%20the%20picture%20shown.%20%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20791px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F113253i388BF16E6D23B685%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%223.png%22%20title%3D%223.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EIf%20Run64BitRuntime%20is%20set%20to%20True%2C%20x64%20version%20Attunity%20Oracle%20Connector%20and%20Oracle%20client%20are%20required%20to%20be%20installed.%3C%2FP%3E%0A%3CP%3EIf%20Run64BitRuntime%20is%20set%20to%20False%2C%20x32%20version%20Attunity%20Oracle%20Connector%20and%20Oracle%20client%20are%20required%20to%20be%20installed.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3ESome%20FAQs%3A%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3COL%3E%0A%3CLI%3E%3CSTRONG%3EException%20from%20HRESULT%3A%200xC0011001%20when%20opening%20existing%20package%3C%2FSTRONG%3E%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CP%3EIt%20is%20a%20known%20issue%20in%20SSDT%2015.9.0%20and%2015.9.1%2C%20when%20package%20uses%20features%20like%20Expressions%20in%20the%20connection%20manager.%20User%20can%20remove%20Expressions%20as%20a%20workaround.%20The%20issue%20will%20be%20fixed%20in%20next%20SSDT%20release%20(15.9.2).%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3COL%20start%3D%222%22%3E%0A%3CLI%3E%3CSTRONG%3ECannot%20connect%20to%20Oracle%20Server%3C%2FSTRONG%3E%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CP%3EWhen%20using%20TNS%20service%20name%20in%20tnsnames.ora%2C%20user%20may%20encounter%20this%20error%20if%20the%20environment%20is%20not%20set%20right.%20There%20are%20few%20ways%20to%20fix%3A%3C%2FP%3E%0A%3COL%3E%0A%3CLI%3EAdd%20TNS_ADMIN%20to%20system%20environment%20variable%2C%20which%20value%20is%20the%20path%20of%20tnsnames.ora%20file.%3C%2FLI%3E%0A%3CLI%3ESet%20OracleHome%20and%20OracleHome64%20in%20Oracle%20connection%20manager%20to%20tnsnames.ora%20path%20in%20x86%20and%20x64%20Oracle%20client%20respectively.%3C%2FLI%3E%0A%3CLI%3EUse%20format%20%5B%2F%2F%5Dhost%5B%3Aport%5D%5B%2Fservice_name%5D%20in%20the%20TNS%20service%20name%20field%20in%20connection%20manager%20to%20connect%20instead.%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3COL%20start%3D%223%22%3E%0A%3CLI%3E%3CSTRONG%3EException%20deserializing%20the%20package%26nbsp%3B%3CEM%3E%22Value%20does%20not%20fall%20with%20the%20expected%20Range%22%20%3C%2FEM%3Ewhen%20running%20package%3C%2FSTRONG%3E%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CP%3EThis%20will%20happen%20in%20package%20execution%20if%20package%20is%20targeted%20to%20pre-SQL%20Server%202019%2C%20and%20corresponding%20Attunity%20Oracle%20Connector%20is%20not%20installed.%20Just%20install%20the%20corresponding%20Attunity%20connector%20to%20mitigate%20the%20error.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-565923%22%20slang%3D%22en-US%22%3E%3CP%3EMicrosoft%20Connector%20for%20Oracle%20is%20the%20replacement%20of%20Attunity%20Oracle%20Connector%20starting%20from%20SQL%20Server%202019%20and%20now%20it%20is%20released%20for%20preview.%20Microsoft%20Connector%20for%20Oracle%20provides%20compatibility%20with%20Attunity%20Oracle%20Connector%20in%20functionality%20and%20performance.%20Packages%20designed%20with%20Attunity%20Oracle%20Connector%20can%20run%20with%20Microsoft%20Connector%20for%20Oracle%20without%20any%20changes.%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-SUB%20id%3D%22lingo-sub-623884%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Connector%20for%20Oracle%20is%20released%20for%20SQL%20Server%202019%20Preview%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-623884%22%20slang%3D%22en-US%22%3E%3CP%3EThi%20is%20really%20a%20cool%20%2C%20so%20now%20SQL2019%20can%20cun%20any%20Oracle%20Packages%20using%20connector%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-649172%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Connector%20for%20Oracle%20is%20released%20for%20SQL%20Server%202019%20Preview%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-649172%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F345800%22%20target%3D%22_blank%22%3E%40BhavinSQL%3C%2FA%3E%26nbsp%3BSQL%202019%20can%20now%20run%20previous%20versions%20of%20SSIS%20packages%20that%20have%20Attunity%20Oracle%20connectors.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-658435%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Connector%20for%20Oracle%20is%20released%20for%20SQL%20Server%202019%20Preview%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-658435%22%20slang%3D%22en-US%22%3E%3CP%3ECan%20connect%20to%20only%20one%20Oracle%20Server.%20With%20all%20others%20received%20errors%20in%20dataflow%20component.%26nbsp%3BAlthough%20connection%20itself%20successfully%20verifies%20with%20TNS%20name%2C%20login%20and%20password.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EError%20Validation%20error.%20Data%20Flow%20Task%3A%20Data%20Flow%20Task%3A%20SSIS%20Error%20Code%20DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.%20The%20AcquireConnection%20method%20call%20to%20the%20connection%20manager%20%22M1%22%20failed%20with%20error%20code%200xC0014009.%20There%20may%20be%20error%20messages%20posted%20before%20this%20with%20more%20information%20on%20why%20the%20AcquireConnection%20method%20call%20failed.%20Package.dtsx%200%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EError%20Validation%20error.%20Data%20Flow%20Task%3A%20Package%3A%20There%20was%20an%20error%20trying%20to%20establish%20an%20Open%20Database%20Connectivity%20(ODBC)%20connection%20with%20the%20database%20server.%20Package.dtsx%200%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-659743%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Connector%20for%20Oracle%20is%20released%20for%20SQL%20Server%202019%20Preview%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-659743%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F351969%22%20target%3D%22_blank%22%3E%40AnatoliS%3C%2FA%3E%26nbsp%3B%2Cthanks%20for%20trying%20Oracle%20connector.%20Can%20you%20help%20confirm%20that%2C%20does%20the%20test%20connection%20success%20in%20connection%20manager%20for%20the%20Servers%20which%20has%26nbsp%3B%3CSPAN%3EDTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER%20error%3F%20And%20is%20the%20working%20server%20using%20same%20connection%20method%20with%20others%3F%20The%20connection%20can%20be%20configured%20with%20TNS%20names%2C%20and%26nbsp%3B%5B%2F%2F%5Dhost%5B%3Aport%5D%5B%2Fservice_name%5D%20format.%20Did%20you%20installed%20Oracle%20client%3F%20Do%20you%20have%26nbsp%3BNAMES.DIRECTORY_PATH%20setting%20in%20sqlnet.ora%20under%20Oracle%20client%20path%3F%20Thanks.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-660046%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Connector%20for%20Oracle%20is%20released%20for%20SQL%20Server%202019%20Preview%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-660046%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F338877%22%20target%3D%22_blank%22%3E%40Zoe_Luo%3C%2FA%3E%2C%20thank%20you%20for%20your%20involvement.%20Yes%2C%26nbsp%3B%20the%20connection%20test%20is%20OK%20for%20all%20the%20servers.%20Error%20appears%20in%20data%20flow%20task%20Oracle%20Source%20component%20during%20validation.%20Yes%2C%20all%20servers%20are%20using%20same%20connection%20method%2C%20only%20I%20change%20is%20TNS%20service%20name.%20Oracle%20clients%2C%20both%2032%20and%2064%20bits%20are%20installed.%20Attunity%20version%20in%20VS2017%20with%26nbsp%3B%3CSPAN%3ESSDTBI%2015.8.0%20works%20with%20all%20servers.%20In%20sqlnet.ora%20this%20setting%20is%20commented%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3ESQLNET.AUTHENTICATION_SERVICES%3D%20(NONE)%3CBR%20%2F%3E%23NAMES.DIRECTORY_PATH%3D%20(TNSNAMES%2C%20EZCONNECT)%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-660076%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Connector%20for%20Oracle%20is%20released%20for%20SQL%20Server%202019%20Preview%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-660076%22%20slang%3D%22en-US%22%3E%3CP%3Ewith%26nbsp%3B%2F%2Fserver%3Aport%2Fservice%20variant%20-%20the%20same%20effect%3C%2FP%3E%3CP%3EThe%20only%20difference%20between%20servers%20as%20DBA%20told%20that%20working%20is%20SE%20edition%2C%20others%20EE%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-660180%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Connector%20for%20Oracle%20is%20released%20for%20SQL%20Server%202019%20Preview%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-660180%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F351969%22%20target%3D%22_blank%22%3E%40AnatoliS%3C%2FA%3E%26nbsp%3B%2C%20I%20just%20checked%20my%20server%20is%20EE%20as%20well%2C%20but%20not%20able%20to%20repro%20this%20error.%20Did%20you%20see%20a%20red%20flag%20on%20your%20Oracle%20source%20component%20in%20SSDT%20before%20executing%20the%20package%3F%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20150px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F116702i16DA4A6F45DDCD48%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Untitled.png%22%20title%3D%22Untitled.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-661103%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Connector%20for%20Oracle%20is%20released%20for%20SQL%20Server%202019%20Preview%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-661103%22%20slang%3D%22en-US%22%3E%3CP%3EYes%2C%20same%20as%20yours%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%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%2F116734i0C18BB8103C76544%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Annotation%202019-05-31%20190656.png%22%20title%3D%22Annotation%202019-05-31%20190656.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-663607%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Connector%20for%20Oracle%20is%20released%20for%20SQL%20Server%202019%20Preview%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-663607%22%20slang%3D%22en-US%22%3E%3CP%3EPlease%20set%26nbsp%3B%3CFONT%20size%3D%222%22%3E%3CSTRONG%3EDelay%20Validation%20property%20to%20True%20and%20check.%3C%2FSTRONG%3E%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-663793%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Connector%20for%20Oracle%20is%20released%20for%20SQL%20Server%202019%20Preview%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-663793%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F351969%22%20target%3D%22_blank%22%3E%40AnatoliS%3C%2FA%3E%26nbsp%3B%2C%20for%20better%20further%20investigation%2C%20I%20have%20sent%20you%20a%20message.%20Please%20have%20a%20check.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-775152%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Connector%20for%20Oracle%20is%20released%20for%20SQL%20Server%202019%20Preview%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-775152%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F321867%22%20target%3D%22_blank%22%3E%40Tim.Chen%3C%2FA%3E%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F338877%22%20target%3D%22_blank%22%3E%40Zoe_Luo%3C%2FA%3E%26nbsp%3B-%20any%20chance%20of%20this%20being%20back-ported%20to%202017%3F%26nbsp%3B%20I'd%20love%20to%20remove%20the%20extra%20dependencies%20and%20slim%20down%20our%20ETL%20VM%20images%20by%20dropping%20the%20Attunity%20connector%20and%20Oracle%20client%20installs%2C%20but%20we're%20just%20now%20migrating%20from%202012%20to%202017%20since%202019%20is%20still%20in%20CTP.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-775368%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Connector%20for%20Oracle%20is%20released%20for%20SQL%20Server%202019%20Preview%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-775368%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20recently%20updated%20to%2015.9.2%20for%20Visual%20Studio%202017.%26nbsp%3B%20I%20have%20all%20the%20Attunity%20Drivers%20install%20since%202.0%20(2.0%2C%203.0%2C%204.0%2C%205.0).%26nbsp%3B%20When%20I%20load%20an%20SSIS%20project%20that%20is%20targeting%20SQL%20Server%202017%2C%20my%20project%20Oracle%20connection%20manager%20shows%20a%20red%20X%20and%20when%20I%20double%20click%20on%20it%2C%20it%20says%20Class%20not%20registered.%26nbsp%3B%20I%20uninstalled%20Attunity%205.0%20and%20reinstalled%20it%2C%20but%20got%20the%20same%20error.%26nbsp%3B%20Any%20ideas%20how%20to%20solve%20that%20problem%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-776913%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Connector%20for%20Oracle%20is%20released%20for%20SQL%20Server%202019%20Preview%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-776913%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F382819%22%20target%3D%22_blank%22%3E%40frugecn%3C%2FA%3E%26nbsp%3B%2C%20could%20you%20please%20have%20a%20screenshot%20about%20the%20errors%3F%20Thanks.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-776936%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Connector%20for%20Oracle%20is%20released%20for%20SQL%20Server%202019%20Preview%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-776936%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F382748%22%20target%3D%22_blank%22%3E%40Bowers_Neil%3C%2FA%3E%26nbsp%3Bwe%20currently%20do%20not%20have%20a%20plan%20to%20back%20port%20this%20to%202017.%20We%20will%20certainly%20consider%20this%20if%20more%20customers%20are%20asking%20for%20it.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-777761%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Connector%20for%20Oracle%20is%20released%20for%20SQL%20Server%202019%20Preview%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-777761%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F338877%22%20target%3D%22_blank%22%3E%40Zoe_Luo%3C%2FA%3E%2C%26nbsp%3Bunfortunately%20in%20my%20troubleshooting%2C%20I%20deleted%20the%20offending%20connection%20manager%20and%20re-added%20it.%26nbsp%3B%20I%20can't%20reproduce%20the%20class%20error%20at%20the%20moment.%26nbsp%3B%20I%20am%20finding%2C%20though%2C%20that%20even%20though%20I%20have%20the%20Oracle%20Client%20installed%20with%20a%20sqlnet.ora%20pointing%20to%20go%20to%20an%20LDAP%20lookup%2C%20the%20connection%20manager%20is%20not%20able%20to%20find%20the%20Oracle%20database.%26nbsp%3B%20It%20will%20work%20if%20I%20go%20%2F%2Fhost%3Aport%2Fservice_name.%26nbsp%3B%20If%20I%20upload%20the%20package%20to%20an%20SSIS%20Catalog%20that%20doesn't%20have%20the%20new%20Oracle%20Connection%2C%20will%20that%20even%20work%3F%26nbsp%3B%20Is%20it%20going%20to%20use%20the%20Attunity%20Drivers%20or%20the%20new%20Oracle%20Connection%20drivers%20when%20the%20Target%20Server%20is%20SSIS%202017%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-778378%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Connector%20for%20Oracle%20is%20released%20for%20SQL%20Server%202019%20Preview%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-778378%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F382819%22%20target%3D%22_blank%22%3E%40frugecn%3C%2FA%3E%26nbsp%3B%2C%20if%20you%20upload%20the%20package%20to%20SSIS%20Catalog%20in%20SQL%20Server%202017%2C%20it%20will%20use%20Attunity%20Driver%2C%20same%20as%20today.%20The%20new%20Oracle%20connector%20supports%20only%20in%20SQL%202019%20currently.%20When%20you%20say%20the%20connection%20manager%20is%20not%20able%20to%20find%20the%20Oracle%20database%2C%20were%20you%20using%20the%20TNSname%20to%20connect%3F%20If%20yes%2C%20did%20you%20try%20the%20options%20in%20the%20doc%20about%20setting%20TNS_MAIN%20or%20OracleHome%3F%20May%20I%20know%20how%20your%20sqlnet.ora%20and%20tnsnames.ora%20are%20configured%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-782493%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Connector%20for%20Oracle%20is%20released%20for%20SQL%20Server%202019%20Preview%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-782493%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F338877%22%20target%3D%22_blank%22%3E%40Zoe_Luo%3C%2FA%3E%2C%26nbsp%3Bwe%20are%20not%20using%20tnsnames.ora%20to%20connect%20because%20there%20are%20too%20many%20to%20keep%20them%20synced%20in%20a%20tnsnames.ora%20file%20on%20all%20of%20the%20machines.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20have%20an%20ldap.ora%20file%20that%20points%20to%20our%20OID%20server%20and%20in%20the%20sqlent.ora%20it%20references%20LDAP%20first%2C%20then%20tnsnames.%26nbsp%3B%20I%20frankly%20don't%20even%20have%20a%20tnsnames.ora%20file%20on%20my%20box.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Esqlnet.ora%3C%2FP%3E%3CPRE%3Enames.directory_path%3D(ldap%2Ctnsnames)%0A%0Adiag_adr_enabled%3Don%0Asec_protocol_error_trace_action%3Dalert%0Asec_protocol_error_further_action%3Ddelay%2C2%0Asec_max_failed_login_attempts%3D2%0Asqlnet.encryption_server%3Drequested%0Asqlnet.encryption_types_server%3D(aes256%2Caes192%2Caes128%2C3des168%2C3des112)%0Asqlnet.encryption_client%3Drequested%0Asqlnet.encryption_types_client%3D(aes256%2Caes192%2Caes128%2C3des168%2C3des112)%0Asqlnet.expire_time%3D10%0Asqlnet.inbound_connect_timeout%3D5%3C%2FPRE%3E%3CP%3Eldap.ora%3C%2FP%3E%3CPRE%3EDEFAULT_ADMIN_CONTEXT%20%3D%20%22dc%3Danywhere%2Cdc%3Dcom%22%0ADIRECTORY_SERVERS%3D%20(oid.anywhere.com%3A4545%3A4546)%0ADIRECTORY_SERVER_TYPE%20%3D%20OID%3C%2FPRE%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-782908%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Connector%20for%20Oracle%20is%20released%20for%20SQL%20Server%202019%20Preview%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-782908%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F382819%22%20target%3D%22_blank%22%3E%40frugecn%3C%2FA%3E%26nbsp%3B%2C%20what%20was%20the%20value%20you%20set%20to%20TNS%20Service%20Name%20when%20you%20cannot%20connect%20to%20the%20server%3F%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F125207i4DD7D2DA9F0BB3D5%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-817124%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Connector%20for%20Oracle%20is%20released%20for%20SQL%20Server%202019%20Preview%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-817124%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20also%20recently%20updated%20to%20SSDT%2015.9.2%20with%20VS2017%20and%20receive%20the%20following%20error%20when%20executing%20the%20package%20%3A-%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CUL%3E%3CLI%3E%3CFONT%3EError%3A%20OCI%20error%20encountered.%20ORA-12154%3A%20TNS%3Acould%20not%20resolve%20the%20connect%20identifier%20specified%3C%2FFONT%3E%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20have%20Attunity%20Drivers%20installed%204.0%20and%205.0%20(x64)%20installed%20targeting%20SQL%20Server%202016%20and%20using%20LDAP%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThe%20strange%20thing%20is%20the%20test%20connection%20in%20design%20time%20succeede%20but%20fails%20when%20running%20in%20the%20IDE.%20Deploying%20to%20SSISDB%20Catalog%20sems%20to%20work%20as%20well.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EHas%20anyone%20encountered%20this%20issue%20%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-817164%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Connector%20for%20Oracle%20is%20released%20for%20SQL%20Server%202019%20Preview%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-817164%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F396637%22%20target%3D%22_blank%22%3E%40ctrembea%3C%2FA%3E%2C%20does%20the%20error%20happen%20when%20executing%20the%20package%20and%20targeting%20SQL%20Server%202016%3F%20Did%20you%20set%20Run64bitRuntime%20to%20true%20since%20you%20have%20X64%20installed%3F%20Thanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-818365%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Connector%20for%20Oracle%20is%20released%20for%20SQL%20Server%202019%20Preview%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-818365%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F338877%22%20target%3D%22_blank%22%3E%40Zoe_Luo%3C%2FA%3E%2C%20yes%20I%20had%20set%20the%20Rn64bitRuntime%20to%20true%2C%20but%20still%20get%20the%20error%20when%20executing%20th%20package.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-818383%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Connector%20for%20Oracle%20is%20released%20for%20SQL%20Server%202019%20Preview%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-818383%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F338877%22%20target%3D%22_blank%22%3E%40Zoe_Luo%3C%2FA%3E%2C%20Sorry%2C%20I've%20been%20out%20of%20pocket%20the%20last%20few%20weeks.%26nbsp%3B%20For%20my%20TNS%20Service%20Name%20I%20use%20one%20of%20the%20Aliases%20available%20in%20OID.%26nbsp%3B%20So%20like%20Appprd1.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F396637%22%20target%3D%22_blank%22%3E%40ctrembea%3C%2FA%3E%2C%26nbsp%3Bwill%20using%20%2F%2FServerName%3Aport%2FServiceName%20work%3F%26nbsp%3B%20I%20think%20that's%20the%20right%20syntax.%26nbsp%3B%20That's%20the%20only%20way%20I%20could%20get%20it%20to%20work.%26nbsp%3B%20It%20is%20definitely%20not%20able%20to%20query%20using%20the%20LDAP.ora%20settings%20from%20what%20I%20can%20see.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-818564%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Connector%20for%20Oracle%20is%20released%20for%20SQL%20Server%202019%20Preview%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-818564%22%20slang%3D%22en-US%22%3E%3CP%3Ethanks%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F382819%22%20target%3D%22_blank%22%3E%40frugecn%3C%2FA%3E%26nbsp%3B%20I%20had%20setup%20the%20TNS%20Service%20name%20using%20%2F%2FServername%3Aport%2FServicename.%20and%20clicking%20on%20test%20conection%20worked%2C%20it%20is%20just%20when%20I%20execute%20the%20package%20it%20fails%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-819259%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Connector%20for%20Oracle%20is%20released%20for%20SQL%20Server%202019%20Preview%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-819259%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F396637%22%20target%3D%22_blank%22%3E%40ctrembea%3C%2FA%3E%2C%20since%20you%20are%20targeting%20to%20SQL%20Server%202016%2C%20it%20looks%20like%20the%20Attunity%20Connector%204.0%20or%20the%20Oracle%20client%20is%20not%20installed%20correctly.%20Does%20the%20same%20project%20work%20using%20SSDT%20before%20version%2015.8%3F%20Previously%20we%20had%20customer%20encountering%20same%20issue%20due%20to%20the%20Oracle%20client%20is%20not%20installed%20correctly%2C%20the%20oci.dll%20is%20not%20able%20to%20be%20found%20since%20it%20was%20not%20installed%20under%20client%5Cbin%20folder%20somehow.%20You%20can%20check%20with%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsysinternals%2Fdownloads%2Fprocess-explorer%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Eprocess%20explorer%3C%2FA%3E%2C%20after%20executing%20the%20package%2C%20do%20not%20stop%20debugging%2C%20find%20dtsdebughost.exe%20in%20process%20explorer%20to%20see%20if%20oci.dll%20is%20loaded%20or%20not%2C%20and%20%3CFONT%20style%3D%22background-color%3A%20%23ffffff%3B%22%3EAttunitySSISOraAdapters.dll%3C%2FFONT%3E(Attunity%20connector%20dll)%20is%20also%20required%20to%20be%20loaded.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F382819%22%20target%3D%22_blank%22%3E%40frugecn%3C%2FA%3E%2C%20let%20me%20confirm%20with%20driver%20provider%20to%20see%20if%20LDAP%20is%20supported%20and%20get%20back%20to%20you%20later.%20Thanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-820301%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Connector%20for%20Oracle%20is%20released%20for%20SQL%20Server%202019%20Preview%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-820301%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F396637%22%20target%3D%22_blank%22%3E%40ctrembea%3C%2FA%3E%2C%20do%20you%20have%20both%20the%2032-bit%20and%20the%2064-bit%20Oracle%20clients%20installed%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-822201%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Connector%20for%20Oracle%20is%20released%20for%20SQL%20Server%202019%20Preview%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-822201%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F382819%22%20target%3D%22_blank%22%3E%40frugecn%3C%2FA%3E%2C%20confirmed%20that%20LDAP%20is%20not%20supported%20by%20the%20driver.%20Is%20it%20a%20blocking%20issue%20for%20you%3F%20We%20may%20request%20the%20enhancement%20if%20there%20is%20strong%20need.%20Thanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-822929%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Connector%20for%20Oracle%20is%20released%20for%20SQL%20Server%202019%20Preview%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-822929%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F338877%22%20target%3D%22_blank%22%3E%40Zoe_Luo%3C%2FA%3E%2C%20there%20is%20a%20work%20around%2C%20but%20because%20I%20can't%20use%20the%20same%20format%20between%20the%20Attunity%20Driver%20and%20the%20new%20driver%2C%20it%20will%20make%20it%20much%20more%20difficult%20to%20maintain%2C%20especially%20when%20they%20change%20dns%20names%20but%20not%20OID%20aliases.%26nbsp%3B%20Can%20we%20request%20the%20enhancement%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-823539%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Connector%20for%20Oracle%20is%20released%20for%20SQL%20Server%202019%20Preview%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-823539%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20have%20both%2032bit%20and%2064bit%20oracle%20clients%20installed.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F382819%22%20target%3D%22_blank%22%3E%40frugecn%3C%2FA%3E%2C%20at%20the%20moment%20our%20only%20choice%20is%20to%20say%20with%20SSDT%2015.8.0%20as%20we%20are%20targeting%20SQL%20Serve%202016%20and%20our%20oracle%20connectivity%20is%20using%20LDAP%20which%20I%20don't%20think%20the%20organiation%20will%20move%20away%20to%20TNS.%20We%20would%20like%20to%20upgrade%20to%20the%20latest%20version%20of%20SSDT%20to%20make%20use%20of%20the%20fixes%20especially%20around%20SSAS%20Tabular.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20we%20could%20request%20an%20enhancement%20to%20support%20LDAP%20that%20would%20be%20appreciated%20as%20it%20is%20blocking%20as%20from%20upgrading%20SSDT.%20Thanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-828438%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Connector%20for%20Oracle%20is%20released%20for%20SQL%20Server%202019%20Preview%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-828438%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F382819%22%20target%3D%22_blank%22%3E%40frugecn%3C%2FA%3E%2C%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F396637%22%20target%3D%22_blank%22%3E%40ctrembea%3C%2FA%3E%2C%26nbsp%3B%3CFONT%20style%3D%22background-color%3A%20%23ffffff%3B%22%3Edriver%20provider%20was%20incorrect%20about%20LDAP%20support%20before.%20It%20is%20actually%20supported.%20We%20are%20working%20on%20investigating%20why%20your%20scenario%20does%20not%20work.%20Will%20update%20when%20we%20have%20a%20conclusion.%20Thanks.%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-830853%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Connector%20for%20Oracle%20is%20released%20for%20SQL%20Server%202019%20Preview%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-830853%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F382819%22%20target%3D%22_blank%22%3E%40frugecn%3C%2FA%3E%2C%20could%20you%20please%20enable%20odbc%20tracing%20in%20ODBC%20data%20source%20administrator%2C%20use%20OID%20alias%20to%20connect%20and%20share%20us%20trace%20logs%20about%20connection%20failure%3F%20So%20we%20can%20further%20investigate%20the%20detailed%20error.%20Thanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-830862%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Connector%20for%20Oracle%20is%20released%20for%20SQL%20Server%202019%20Preview%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-830862%22%20slang%3D%22en-US%22%3E%3CDIV%20class%3D%22lia-message-author-with-avatar%22%20dir%3D%22ltr%22%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%23333333%3B%20display%3A%20inline-block%3B%20font-family%3A%20%26amp%3Bquot%3B%20segoeui%26amp%3Bquot%3B%2C%26amp%3Bquot%3Blato%26amp%3Bquot%3B%2C%26amp%3Bquot%3Bhelvetica%20neue%26amp%3Bquot%3B%2Chelvetica%2Carial%2Csans-serif%3B%20font-size%3A%2014px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20padding-top%3A%2010px%3B%20text-align%3A%20left%3B%20text-decoration%3A%20none%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20vertical-align%3A%20top%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%22%3E%3CSPAN%20class%3D%22UserName%20lia-user-name%20lia-user-rank-Occasional-Visitor%20lia-component-message-view-widget-author-username%22%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20%26amp%3Bquot%3B%20segoeui%26amp%3Bquot%3B%2C%26amp%3Bquot%3Blato%26amp%3Bquot%3B%2C%26amp%3Bquot%3Bhelvetica%20neue%26amp%3Bquot%3B%2Chelvetica%2Carial%2Csans-serif%3B%20white-space%3A%20nowrap%3B%22%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F396637%22%20target%3D%22_blank%22%3E%40ctrembea%3C%2FA%3E%2C%20you%20mentioned%20that%20the%20connection%20only%20fails%20when%20executing%20the%20package%2C%20right%3F%20In%20this%20case%2C%20it%20is%20not%20the%20LDAP%20support%20issue.%20Then%20package%20targeting%20to%20SQL2016%2C%20Attunity%20connector%20will%20be%20used%20at%20runtime.%20So%20it%20must%20be%20Attunity%20connector%20required%20environment%20is%20not%20set%20correctly.%20Can%20you%20use%20%3CA%20style%3D%22background-color%3A%20transparent%3B%20box-sizing%3A%20border-box%3B%20color%3A%20%23146cac%3B%20font-family%3A%20%26amp%3Bquot%3B%20segoeui%26amp%3Bquot%3B%2C%26amp%3Bquot%3Blato%26amp%3Bquot%3B%2C%26amp%3Bquot%3Bhelvetica%20neue%26amp%3Bquot%3B%2Chelvetica%2Carial%2Csans-serif%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-decoration%3A%20underline%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsysinternals%2Fdownloads%2Fprocess-explorer%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Eprocess%20explorer%3C%2FA%3E%26nbsp%3B%20to%20check%20the%20dll%20loading%20as%20I%20mentioned%20above%3F%20Thanks.%20%26nbsp%3B%26nbsp%3B%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-837164%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Connector%20for%20Oracle%20is%20released%20for%20SQL%20Server%202019%20Preview%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-837164%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20running%20VS2017%20SSDT%20v15.9.12%20on%20SQL%202017%20Integration%20Services.%3C%2FP%3E%3CP%3EI%20have%20the%20Oracle%20Client%20and%20the%26nbsp%3BMicrosoft%20Connector%20Version%205.0%20for%20Oracle%20by%20Attunity%20targeting%20SQL%20Server%202017%20both%20installed.%3C%2FP%3E%3CP%3EShould%20I%20be%20seeing%20see%20the%26nbsp%3B%20red%20Icon%20like%20I%20did%20in%20prior%20version%20for%20SQL%202012%3F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F130108i8329FFBA6830961D%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EIn%20SQL%202017%20with%20SSDT%20v015.9.12%2C%20I%20am%20not%20seeing%20the%20red%20icon%20on%20the%20connectors.%26nbsp%3B%20Is%20that%20normal%20now%20with%20the%26nbsp%3B%3CSPAN%3EMicrosoft%20Connector%20for%20Oracle%20included%20in%20SSDT%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-837930%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Connector%20for%20Oracle%20is%20released%20for%20SQL%20Server%202019%20Preview%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-837930%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F303403%22%20target%3D%22_blank%22%3E%40ckallingerAAH%3C%2FA%3E%2C%20yes%2C%20in%20new%20SSDT%2C%20the%20icon%20is%20changed%20and%20should%20be%20like%3A%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20151px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F130166iA9AF8D282567E4C6%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22connectors.png%22%20title%3D%22connectors.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CDIV%20id%3D%22tinyMceEditorclipboard_image_1%22%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FLINGO-BODY%3E
Microsoft

Microsoft Connector for Oracle  is the replacement of Attunity Oracle Connector starting from SQL Server 2019 and now it is released for preview. Microsoft Connector for Oracle provides compatibility with Attunity Oracle Connector in functionality and performance. Packages designed with Attunity Oracle Connector can run with Microsoft Connector for Oracle without any changes.

 

Microsoft Connector for Oracle is supported in:

 

  1. SQL Server 2019

User can download Microsoft Connector for Oracle V1.0 (SQL Server 2019) - Preview for executing Oracle packages in SQL Server 2019. For Microsoft Oracle Connector, Oracle client is not required.

 

  1. SQL Server Data Tools (SSDT)

Microsoft Connector for Oracle has is shipped in SSDT for VS 2017 since version 15.9.0, as well as in SSIS projects for VS 2019. Users do not need extra installation of Oracle connector when designing packages targeting SQL Server 2019.

 

Using Oracle Connector in SQL Server Data Tools (SSDT) 15.9.x for VS 2017 or SSIS Projects for VS 2019

Microsoft Connector for Oracle has been shipped in SSDT for VS 2017 since 15.9.0 and SSIS Projects for VS 2019. User can use Microsoft Connector for Oracle to design packages targeting to SQL Server 2019 and pre-2019.

Design new SSIS packages

Open SSDT 15.9.x, Oracle components can be found in SSIS Toolbox, under Common Category.

1.png

And in Connection Managers, Oracle connection manager is displayed with type “ORACLE”.

2.png

Microsoft Connector for Oracle provides similar user experience with Attunity Oracle Connector. User can design new packages based on previous experience.

 

In design time, no matter which SQL Server version the project is targeting, no extra dependency is required to be installed. If user wants to use TNS service name in tnsnames.ora for connecting to Oracle Server, there are a few ways to achieve this:

 

  1. Install Oracle client and create tnsnames.ora in network\admin under Oracle client path. This is exactly the same with Attunity Oracle connector.
  2. Create tnsnames.ora under any local directory and add a TNS_ADMIN system environment variable which value is the tnsnames.ora directory path.
  3. Create tnsnames.ora under any local directory and set the direct path to OracleHome property in Oracle connection manager advanced editor.

 

Open and Execute existing SSIS packages

Existing SSIS packages which have been designed with Attunity Oracle Connector will be automatically upgraded to use Microsoft Connector for Oracle. The icons will be changed as well.

 

After successfully opening existing packages, users can redesign or execute package, or change the target SQL Server version for the project.

 

Execute SSIS packages

Execute packages targeting SQL Server 2019

If the project is targeting SQL Server 2019, there is no extra dependency for execution. Oracle client is not required. User can directly execute and debug package.

 

Execute package targeting Pre-SQL Server 2019

If the project is targeting Pre-SQL Server 2019, corresponding Attunity Oracle Connector and Oracle client are required to be installed on the SSDT machine for package execution.

 

Attunity Oracle Connector download links:

The required Attunity Oracle Connector and Oracle client platform version depends on project debug config, as the picture shown.  

3.png

If Run64BitRuntime is set to True, x64 version Attunity Oracle Connector and Oracle client are required to be installed.

If Run64BitRuntime is set to False, x32 version Attunity Oracle Connector and Oracle client are required to be installed.

 

Some FAQs:

 

  1. Exception from HRESULT: 0xC0011001 when opening existing package

It is a known issue in SSDT 15.9.0 and 15.9.1, when package uses features like Expressions in the connection manager. User can remove Expressions as a workaround. The issue will be fixed in next SSDT release (15.9.2).

 

  1. Cannot connect to Oracle Server

When using TNS service name in tnsnames.ora, user may encounter this error if the environment is not set right. There are few ways to fix:

  1. Add TNS_ADMIN to system environment variable, which value is the path of tnsnames.ora file.
  2. Set OracleHome and OracleHome64 in Oracle connection manager to tnsnames.ora path in x86 and x64 Oracle client respectively.
  3. Use format [//]host[:port][/service_name] in the TNS service name field in connection manager to connect instead.

 

  1. Exception deserializing the package "Value does not fall with the expected Range" when running package

This will happen in package execution if package is targeted to pre-SQL Server 2019, and corresponding Attunity Oracle Connector is not installed. Just install the corresponding Attunity connector to mitigate the error.

33 Comments
Occasional Visitor

Thi is really a cool , so now SQL2019 can cun any Oracle Packages using connector? 

Microsoft

@BhavinSQL SQL 2019 can now run previous versions of SSIS packages that have Attunity Oracle connectors. 

Regular Visitor

Can connect to only one Oracle Server. With all others received errors in dataflow component. Although connection itself successfully verifies with TNS name, login and password.

 

Error Validation error. Data Flow Task: Data Flow Task: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "M1" failed with error code 0xC0014009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. Package.dtsx 0


Error Validation error. Data Flow Task: Package: There was an error trying to establish an Open Database Connectivity (ODBC) connection with the database server. Package.dtsx 0

Microsoft

@AnatoliS ,thanks for trying Oracle connector. Can you help confirm that, does the test connection success in connection manager for the Servers which has DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER error? And is the working server using same connection method with others? The connection can be configured with TNS names, and [//]host[:port][/service_name] format. Did you installed Oracle client? Do you have NAMES.DIRECTORY_PATH setting in sqlnet.ora under Oracle client path? Thanks.

Regular Visitor

@Zoe_Luo, thank you for your involvement. Yes,  the connection test is OK for all the servers. Error appears in data flow task Oracle Source component during validation. Yes, all servers are using same connection method, only I change is TNS service name. Oracle clients, both 32 and 64 bits are installed. Attunity version in VS2017 with SSDTBI 15.8.0 works with all servers. In sqlnet.ora this setting is commented

SQLNET.AUTHENTICATION_SERVICES= (NONE)
#NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

Regular Visitor

with //server:port/service variant - the same effect

The only difference between servers as DBA told that working is SE edition, others EE

Microsoft

@AnatoliS , I just checked my server is EE as well, but not able to repro this error. Did you see a red flag on your Oracle source component in SSDT before executing the package?

Untitled.png

Regular Visitor

Yes, same as yours 

 

Annotation 2019-05-31 190656.png

Occasional Contributor

Please set Delay Validation property to True and check.

Microsoft

@AnatoliS , for better further investigation, I have sent you a message. Please have a check. 

Occasional Visitor

@Tim.Chen @Zoe_Luo - any chance of this being back-ported to 2017?  I'd love to remove the extra dependencies and slim down our ETL VM images by dropping the Attunity connector and Oracle client installs, but we're just now migrating from 2012 to 2017 since 2019 is still in CTP.

Frequent Visitor

I've recently updated to 15.9.2 for Visual Studio 2017.  I have all the Attunity Drivers install since 2.0 (2.0, 3.0, 4.0, 5.0).  When I load an SSIS project that is targeting SQL Server 2017, my project Oracle connection manager shows a red X and when I double click on it, it says Class not registered.  I uninstalled Attunity 5.0 and reinstalled it, but got the same error.  Any ideas how to solve that problem?

 

 

Microsoft

@frugecn , could you please have a screenshot about the errors? Thanks. 

Microsoft

@Bowers_Neil we currently do not have a plan to back port this to 2017. We will certainly consider this if more customers are asking for it. 

Frequent Visitor

@Zoe_Luo, unfortunately in my troubleshooting, I deleted the offending connection manager and re-added it.  I can't reproduce the class error at the moment.  I am finding, though, that even though I have the Oracle Client installed with a sqlnet.ora pointing to go to an LDAP lookup, the connection manager is not able to find the Oracle database.  It will work if I go //host:port/service_name.  If I upload the package to an SSIS Catalog that doesn't have the new Oracle Connection, will that even work?  Is it going to use the Attunity Drivers or the new Oracle Connection drivers when the Target Server is SSIS 2017?

Microsoft

@frugecn , if you upload the package to SSIS Catalog in SQL Server 2017, it will use Attunity Driver, same as today. The new Oracle connector supports only in SQL 2019 currently. When you say the connection manager is not able to find the Oracle database, were you using the TNSname to connect? If yes, did you try the options in the doc about setting TNS_MAIN or OracleHome? May I know how your sqlnet.ora and tnsnames.ora are configured? 

Frequent Visitor

@Zoe_Luo, we are not using tnsnames.ora to connect because there are too many to keep them synced in a tnsnames.ora file on all of the machines.

 

We have an ldap.ora file that points to our OID server and in the sqlent.ora it references LDAP first, then tnsnames.  I frankly don't even have a tnsnames.ora file on my box.

 

sqlnet.ora

names.directory_path=(ldap,tnsnames)

diag_adr_enabled=on
sec_protocol_error_trace_action=alert
sec_protocol_error_further_action=delay,2
sec_max_failed_login_attempts=2
sqlnet.encryption_server=requested
sqlnet.encryption_types_server=(aes256,aes192,aes128,3des168,3des112)
sqlnet.encryption_client=requested
sqlnet.encryption_types_client=(aes256,aes192,aes128,3des168,3des112)
sqlnet.expire_time=10
sqlnet.inbound_connect_timeout=5

ldap.ora

DEFAULT_ADMIN_CONTEXT = "dc=anywhere,dc=com"
DIRECTORY_SERVERS= (oid.anywhere.com:4545:4546)
DIRECTORY_SERVER_TYPE = OID
 
Microsoft

@frugecn , what was the value you set to TNS Service Name when you cannot connect to the server?

clipboard_image_0.png

Occasional Visitor

I have also recently updated to SSDT 15.9.2 with VS2017 and receive the following error when executing the package :-

 

  • Error: OCI error encountered. ORA-12154: TNS:could not resolve the connect identifier specified

 

I have Attunity Drivers installed 4.0 and 5.0 (x64) installed targeting SQL Server 2016 and using LDAP 

 

The strange thing is the test connection in design time succeede but fails when running in the IDE. Deploying to SSISDB Catalog sems to work as well.

 

Has anyone encountered this issue ?

 

Microsoft

@ctrembea , does the error happen when executing the package and targeting SQL Server 2016? Did you set Run64bitRuntime to true since you have X64 installed? Thanks.

Occasional Visitor

@Zoe_Luo, yes I had set the Rn64bitRuntime to true, but still get the error when executing th package.

 

 

 

Frequent Visitor

@Zoe_Luo, Sorry, I've been out of pocket the last few weeks.  For my TNS Service Name I use one of the Aliases available in OID.  So like Appprd1.

 

@ctrembea, will using //ServerName:port/ServiceName work?  I think that's the right syntax.  That's the only way I could get it to work.  It is definitely not able to query using the LDAP.ora settings from what I can see.

Occasional Visitor

thanks @frugecn  I had setup the TNS Service name using //Servername:port/Servicename. and clicking on test conection worked, it is just when I execute the package it fails

 

Microsoft

@ctrembea , since you are targeting to SQL Server 2016, it looks like the Attunity Connector 4.0 or the Oracle client is not installed correctly. Does the same project work using SSDT before version 15.8? Previously we had customer encountering same issue due to the Oracle client is not installed correctly, the oci.dll is not able to be found since it was not installed under client\bin folder somehow. You can check with process explorer , after executing the package, do not stop debugging, find dtsdebughost.exe in process explorer to see if oci.dll is loaded or not, and AttunitySSISOraAdapters.dll (Attunity connector dll) is also required to be loaded.

 

@frugecn , let me confirm with driver provider to see if LDAP is supported and get back to you later. Thanks.

Frequent Visitor

@ctrembea, do you have both the 32-bit and the 64-bit Oracle clients installed?

Microsoft

@frugecn , confirmed that LDAP is not supported by the driver. Is it a blocking issue for you? We may request the enhancement if there is strong need. Thanks.

Frequent Visitor

@Zoe_Luo, there is a work around, but because I can't use the same format between the Attunity Driver and the new driver, it will make it much more difficult to maintain, especially when they change dns names but not OID aliases.  Can we request the enhancement?

Occasional Visitor

We have both 32bit and 64bit oracle clients installed.

 

@frugecn, at the moment our only choice is to say with SSDT 15.8.0 as we are targeting SQL Serve 2016 and our oracle connectivity is using LDAP which I don't think the organiation will move away to TNS. We would like to upgrade to the latest version of SSDT to make use of the fixes especially around SSAS Tabular.

 

If we could request an enhancement to support LDAP that would be appreciated as it is blocking as from upgrading SSDT. Thanks

 

Microsoft

@frugecn@ctrembeadriver provider was incorrect about LDAP support before. It is actually supported. We are working on investigating why your scenario does not work. Will update when we have a conclusion. Thanks.

Microsoft

@frugecn , could you please enable odbc tracing in ODBC data source administrator, use OID alias to connect and share us trace logs about connection failure? So we can further investigate the detailed error. Thanks.

Microsoft
@ctrembea , you mentioned that the connection only fails when executing the package, right? In this case, it is not the LDAP support issue. Then package targeting to SQL2016, Attunity connector will be used at runtime. So it must be Attunity connector required environment is not set correctly. Can you use process explorer  to check the dll loading as I mentioned above? Thanks.   
Frequent Visitor

I am running VS2017 SSDT v15.9.12 on SQL 2017 Integration Services.

I have the Oracle Client and the Microsoft Connector Version 5.0 for Oracle by Attunity targeting SQL Server 2017 both installed.

Should I be seeing see the  red Icon like I did in prior version for SQL 2012?

clipboard_image_0.png

In SQL 2017 with SSDT v015.9.12, I am not seeing the red icon on the connectors.  Is that normal now with the Microsoft Connector for Oracle included in SSDT?

 

Microsoft

@ckallingerAAH , yes, in new SSDT, the icon is changed and should be like:

connectors.png