vmtestoradg2:<\/p>\n
- \n
- IPI: 172.22.1.175<\/li>\n
- OS : Oracle Enterprise Linux (OEL)<\/li>\n
- Software : Oracle 11gR2<\/li>\n<\/ul>\n
![\"Blog_Julien-architecture\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog_Julien-architecture.png\")
<\/p>\nPrerequisites<\/h3>\n
Attunity connector dose not work with all version of SQL Server, be sure that all prerequisites are met.
\nThe connector does not support all types of data (~50%). Undermentioned is the array of the supported types :<\/p>\n\n
\u00a0<\/caption>\n \n\n Oracle Database Data Types<\/strong><\/span><\/td>\n SSIS Data Types<\/strong><\/span><\/td>\n<\/tr>\n \n VARCHAR2<\/span><\/td>\n DT_STR<\/span><\/td>\n<\/tr>\n \n NVARCHAR2<\/span><\/td>\n DT_WSTR<\/span><\/td>\n<\/tr>\n \n NUMBER<\/span><\/td>\n DT_R8<\/span><\/td>\n<\/tr>\n \n NUMBER (P,S)<\/span><\/td>\n DTNUMERIC(P,S)<\/span><\/td>\n<\/tr>\n \n DATE<\/span><\/td>\n DT_DBTIMESTAMP<\/span><\/td>\n<\/tr>\n \n RAW<\/span><\/td>\n DT_BYTES<\/span><\/td>\n<\/tr>\n \n CHAR<\/span><\/td>\n DT_STR<\/span><\/td>\n<\/tr>\n \n TIMESTAMP<\/span><\/td>\n DT_STR<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n <\/p>\n
Unsupported types:<\/p>\n
\n\n
\n Oracle Database Data Types<\/strong><\/span><\/td>\n SSIS Data Types<\/strong><\/span><\/td>\n<\/tr>\n \n LONG<\/span><\/td>\n Not Supported<\/span><\/td>\n<\/tr>\n \n LONG RAW<\/span><\/td>\n Not Supported<\/span><\/td>\n<\/tr>\n \n ROWID<\/span><\/td>\n Not Supported<\/span><\/td>\n<\/tr>\n \n User-defined type
\n<\/span>(object type, VARRAY, Nested Table)<\/span><\/td>\nNot Supported<\/span><\/td>\n<\/tr>\n \n REF<\/span><\/td>\n Not Supported<\/span><\/td>\n<\/tr>\n \n CLOB, NCLOB, BLOB, BFILE<\/span><\/td>\n Not Supported<\/span><\/td>\n<\/tr>\n \n UROWID<\/span><\/td>\n Not Supported<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n You have to use Microsoft SQL Server Enterprise Edition.
\nYou will need Microsoft Visual Studio or Business Intelligence Development Studio (BIDS) from SQL Server 2008, connector is not compatible with SQL 2005.
\nAn Oracle Client has to be installed and you have to define a TNS Service Name.<\/p>\nAttunity connector installation<\/h3>\n
\n\n
\n Rows<\/span><\/strong><\/span><\/td>\n OLE DB Provdier for Oracle<\/span><\/strong><\/span><\/td>\n Attunity Connectors<\/span><\/strong><\/span><\/td>\n Gain<\/span><\/strong><\/span><\/td>\n<\/tr>\n \n 500 rows<\/span><\/td>\n 164 ms<\/span><\/td>\n 152 ms<\/span><\/td>\n 7%<\/span><\/td>\n<\/tr>\n \n 1’000 rows<\/span><\/td>\n 212 ms<\/span><\/td>\n 207 ms<\/span><\/td>\n 2%<\/span><\/td>\n<\/tr>\n \n 2’500 rows<\/span><\/td>\n 243 ms<\/span><\/td>\n 232 ms<\/span><\/td>\n 4%<\/span><\/td>\n<\/tr>\n \n 5’000 rows<\/span><\/td>\n 294 ms<\/span><\/td>\n 274 ms<\/span><\/td>\n 7%<\/span><\/td>\n<\/tr>\n \n 7’500 rows<\/span><\/td>\n 341 ms<\/span><\/td>\n 307 ms<\/span><\/td>\n 10%<\/span><\/td>\n<\/tr>\n \n 10’000 rows<\/span><\/td>\n 544 ms<\/span><\/td>\n 475 ms<\/span><\/td>\n 13%<\/span><\/td>\n<\/tr>\n \n 50’000 rows<\/span><\/td>\n 1147 ms<\/span><\/td>\n 987 ms<\/span><\/td>\n 14%<\/span><\/td>\n<\/tr>\n \n 100’000 rows<\/span><\/td>\n 1947 ms<\/span><\/td>\n 1659 ms<\/span><\/td>\n 15%<\/span><\/td>\n<\/tr>\n \n 500’000 rows<\/span><\/td>\n 5513 ms<\/span><\/td>\n 4687 ms<\/span><\/td>\n 15%<\/span><\/td>\n<\/tr>\n \n 1’000’000 rows<\/span><\/td>\n 11264 ms<\/span><\/td>\n 9554 m<\/span><\/td>\n 15%<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n <\/p>\n
Here are two comparative diagrams of OLE DB Provider for Oracle and Attunity connector:<\/p>\n
1. Time\/Rows:<\/p>\n
![\"diagram_time\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/diagram_time.png\")
<\/p>\n2. Gain\/Rows:<\/p>\n
![\"diagram_gain\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/diagram_gain.png\")
<\/p>\nThe diagram shows that the more rows there are, the more performances are improved. the connector becomes very interesting starting from ~10’000 rows.<\/p>\n
The maximal gain is ~15% with 1’000’000 rows.<\/p>\n
Encountered problems and frequents errors<\/h3>\n
Even if Attunity connector is a very useful tool, you may encountered some errors.<\/p>\n
In this section, I have described the most commons errors. These errors are not specific to Attunity connector, so if you are accustomed to BIDS you may already know them.<\/p>\n
- \n
- Error : \u201c0xC0202071\u00a0<\/strong>at Data Flow Task(infraction action), SQL Server Destination [3600]: Unable to prepare the SSIS bulk insert for data insertion. \u201d\n
- \n
- Solution : Disable UAC (User Account Control) in the control panel.<\/li>\n<\/ul>\n<\/li>\n
- Error on OLE DB source and destination: “Cannot retrieve the column code page info on the OLE DB Provider. If the component supports the “DefaultCodePage” property, the code page from that property will be used. Change the value of the property if the current string code page values are incorrect. If the component does not support the property, the code page from the component’s locale ID will be used.”\n
- \n
- \u201cAlwaysUseDefaultCodePage\u201d must be set on “true” on OLE DB source and destination.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n
![\"032\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/032.png\")
<\/p>\n- \n
- Error: 0xC0209303<\/strong> and 0xC020801C<\/strong>.\n
- \n
- You have to run the package in 32 bit mode. In the properties of the project (accessible via Project menu), set \u201cRun64BitsRuntime\u201d on “false”.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n
![\"0033\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/0033.png\")
<\/p>\nConclusion<\/h3>\n
Attunity connector provides an improved performance even with few records. The gain is great if you have a lot of rows to transfer. The implementation is quite easy, so with minimal efforts you can gain a lot of time on your SSIS packages.
\nConsidering a gain of 500 rows, using these connectors is primarily interesting if you have a lot of data to transfer.<\/p>\nThe primary drawback is that the connector does not support all types of data, so be careful before using it. And as I have said before, you have to have Enterprise Edition, otherwise, you cannot use Attunity connector.<\/p>\n
- \n
- Coming soon: a benchmark with Microsoft SQL Server 2012 and Attunity connectors 2.0<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
Recently, at a customer site, I discovered the Attunity connector 1.1 for Oracle. The customer uses this connector to transfer data from Oracle to SQL Server using Integration Services (SSIS) and informed me that performances are greatly improved. So I decided to post a blog about this connector and perform a benchmark between Attunity connector and Microsoft OLE DB provider for Oracle.<\/p>\n","protected":false},"author":26,"featured_media":2542,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[197],"tags":[263,49,265],"type_dbi":[],"class_list":["post-2541","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-application-integration-middleware","tag-integration-services","tag-microsoft","tag-sql-server-2008"],"acf":[],"yoast_head":"\n
SQL Server: Attunity connectors for data transfer to Oracle - dbi Blog<\/title>\n<meta name=\"description\" content=\"Accelerate your data's transfer between Oracle and SQL Server with Attunity's connectors.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/sql-server-attunity-connectors-for-data-transfer-to-oracle\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server: Attunity connectors for data transfer to Oracle\" \/>\n<meta property=\"og:description\" content=\"Accelerate your data's transfer between Oracle and SQL Server with Attunity's connectors.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-attunity-connectors-for-data-transfer-to-oracle\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2012-05-02T02:55:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog_Julien-architecture.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1086\" \/>\n\t<meta property=\"og:image:height\" content=\"865\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Microsoft Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Microsoft Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-attunity-connectors-for-data-transfer-to-oracle\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-attunity-connectors-for-data-transfer-to-oracle\/\"},\"author\":{\"name\":\"Microsoft Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4\"},\"headline\":\"SQL Server: Attunity connectors for data transfer to Oracle\",\"datePublished\":\"2012-05-02T02:55:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-attunity-connectors-for-data-transfer-to-oracle\/\"},\"wordCount\":1191,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-attunity-connectors-for-data-transfer-to-oracle\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog_Julien-architecture.png\",\"keywords\":[\"Integration services\",\"Microsoft\",\"SQL Server 2008\"],\"articleSection\":[\"Application integration & Middleware\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-attunity-connectors-for-data-transfer-to-oracle\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-attunity-connectors-for-data-transfer-to-oracle\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-attunity-connectors-for-data-transfer-to-oracle\/\",\"name\":\"SQL Server: Attunity connectors for data transfer to Oracle - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-attunity-connectors-for-data-transfer-to-oracle\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-attunity-connectors-for-data-transfer-to-oracle\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog_Julien-architecture.png\",\"datePublished\":\"2012-05-02T02:55:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4\"},\"description\":\"Accelerate your data's transfer between Oracle and SQL Server with Attunity's connectors.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-attunity-connectors-for-data-transfer-to-oracle\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-attunity-connectors-for-data-transfer-to-oracle\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-attunity-connectors-for-data-transfer-to-oracle\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog_Julien-architecture.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog_Julien-architecture.png\",\"width\":1086,\"height\":865},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-attunity-connectors-for-data-transfer-to-oracle\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server: Attunity connectors for data transfer to Oracle\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4\",\"name\":\"Microsoft Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g\",\"caption\":\"Microsoft Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/microsoft-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Server: Attunity connectors for data transfer to Oracle - dbi Blog","description":"Accelerate your data's transfer between Oracle and SQL Server with Attunity's connectors.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/sql-server-attunity-connectors-for-data-transfer-to-oracle\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server: Attunity connectors for data transfer to Oracle","og_description":"Accelerate your data's transfer between Oracle and SQL Server with Attunity's connectors.","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-attunity-connectors-for-data-transfer-to-oracle\/","og_site_name":"dbi Blog","article_published_time":"2012-05-02T02:55:00+00:00","og_image":[{"width":1086,"height":865,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog_Julien-architecture.png","type":"image\/png"}],"author":"Microsoft Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Microsoft Team","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-attunity-connectors-for-data-transfer-to-oracle\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-attunity-connectors-for-data-transfer-to-oracle\/"},"author":{"name":"Microsoft Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4"},"headline":"SQL Server: Attunity connectors for data transfer to Oracle","datePublished":"2012-05-02T02:55:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-attunity-connectors-for-data-transfer-to-oracle\/"},"wordCount":1191,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-attunity-connectors-for-data-transfer-to-oracle\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog_Julien-architecture.png","keywords":["Integration services","Microsoft","SQL Server 2008"],"articleSection":["Application integration & Middleware"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-attunity-connectors-for-data-transfer-to-oracle\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-attunity-connectors-for-data-transfer-to-oracle\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-attunity-connectors-for-data-transfer-to-oracle\/","name":"SQL Server: Attunity connectors for data transfer to Oracle - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-attunity-connectors-for-data-transfer-to-oracle\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-attunity-connectors-for-data-transfer-to-oracle\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog_Julien-architecture.png","datePublished":"2012-05-02T02:55:00+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4"},"description":"Accelerate your data's transfer between Oracle and SQL Server with Attunity's connectors.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-attunity-connectors-for-data-transfer-to-oracle\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-attunity-connectors-for-data-transfer-to-oracle\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-attunity-connectors-for-data-transfer-to-oracle\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog_Julien-architecture.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog_Julien-architecture.png","width":1086,"height":865},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-attunity-connectors-for-data-transfer-to-oracle\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server: Attunity connectors for data transfer to Oracle"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4","name":"Microsoft Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g","caption":"Microsoft Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/microsoft-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/2541","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/26"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=2541"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/2541\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/2542"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=2541"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=2541"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=2541"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=2541"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
- Coming soon: a benchmark with Microsoft SQL Server 2012 and Attunity connectors 2.0<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
- You have to run the package in 32 bit mode. In the properties of the project (accessible via Project menu), set \u201cRun64BitsRuntime\u201d on “false”.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n
- Error: 0xC0209303<\/strong> and 0xC020801C<\/strong>.\n
- \u201cAlwaysUseDefaultCodePage\u201d must be set on “true” on OLE DB source and destination.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n
- Error : \u201c0xC0202071\u00a0<\/strong>at Data Flow Task(infraction action), SQL Server Destination [3600]: Unable to prepare the SSIS bulk insert for data insertion. \u201d\n
![\"001\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/001.png\")
<\/p>\n![\"002\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/002.png\")
![\"003\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/003.png\")
<\/p>\n![\"004\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/004.png\")
![\"005\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/005.png\")
![\"006c\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/006c.png\")
![\"007\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/007.png\")
![\"08\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/08.png\")
<\/p>\n![\"016b\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/016b.png\")
![\"019\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/019.png\")
<\/p>\n![\"021\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/021.png\")
<\/p>\n![\"022\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/022.png\")
![\"025b\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/025b.png\")
<\/p>\n![\"026b\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/026b.png\")
<\/p>\n![\"30\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/30.png\")
<\/p>\n![\"31\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/31.png\")
![\"0032b\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/0032b.png\")
<\/p>\n