{"id":440,"date":"2023-08-10T17:37:59","date_gmt":"2023-08-11T00:37:59","guid":{"rendered":"https:\/\/tmainc.net\/?p=440"},"modified":"2023-08-11T09:17:56","modified_gmt":"2023-08-11T16:17:56","slug":"import-as400-files-into-ms-sql-server","status":"publish","type":"post","link":"https:\/\/tmainc.net\/?p=440","title":{"rendered":"Import AS400 Files into MS-SQL Server"},"content":{"rendered":"\n<p class=\"has-text-align-left has-medium-font-size\"><strong>using SSMS Server Import and Export Wizard<\/strong><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>Step-by-Step using the SSMS SQL Server Import and Export Wizard to import AS400 files into SQL Server tables.\u00a0 Note:\u00a0 If you haven\u2019t already done so, see my instructions to correct the IBM Data Providers that are used by the Wizard <a href=\"https:\/\/tmainc.net\/wp-admin\/post.php?post=470\">(<\/a><a href=\"https:\/\/tmainc.net\/?p=470\">Correcting the IBM Data Provider Mapping Files<\/a><a href=\"https:\/\/tmainc.net\/wp-admin\/post.php?post=470\">).<\/a><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-16.png\"><img loading=\"lazy\" decoding=\"async\" width=\"638\" height=\"847\" src=\"https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-16.png\" alt=\"\" class=\"wp-image-457\" srcset=\"https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-16.png 638w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-16-226x300.png 226w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-16-100x133.png 100w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-16-150x199.png 150w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-16-200x266.png 200w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-16-300x398.png 300w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-16-450x597.png 450w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-16-600x797.png 600w\" sizes=\"(max-width: 638px) 100vw, 638px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-1.png\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"535\" src=\"https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-1.png\" alt=\"\" class=\"wp-image-442\" srcset=\"https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-1.png 624w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-1-300x257.png 300w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-1-100x86.png 100w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-1-150x129.png 150w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-1-200x171.png 200w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-1-450x386.png 450w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-1-600x514.png 600w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><a href=\"https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-2.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-2.png\" alt=\"\" class=\"wp-image-443\" style=\"width:627px;height:538px\" width=\"627\" height=\"538\" srcset=\"https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-2.png 624w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-2-300x257.png 300w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-2-100x86.png 100w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-2-150x129.png 150w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-2-200x171.png 200w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-2-450x386.png 450w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-2-600x514.png 600w\" sizes=\"(max-width: 627px) 100vw, 627px\" \/><\/a><figcaption class=\"wp-element-caption\">Figure 1 &#8211; After selecting the Source, click properties to set the connection information.&nbsp; <\/figcaption><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p class=\"has-button-color-color has-text-color has-medium-font-size\"><strong>Note: Test both IBMDA400 and IBMDASQL for speed.&nbsp; In my tests, IBMDASQL is much, much faster.<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-18.png\"><img loading=\"lazy\" decoding=\"async\" width=\"369\" height=\"473\" src=\"https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-18.png\" alt=\"\" class=\"wp-image-459\" srcset=\"https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-18.png 369w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-18-234x300.png 234w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-18-100x128.png 100w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-18-150x192.png 150w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-18-200x256.png 200w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-18-300x385.png 300w\" sizes=\"(max-width: 369px) 100vw, 369px\" \/><\/a><figcaption class=\"wp-element-caption\">Figure 2 &#8211; after entering the connection information, click the ALL tab to set the default Libraries.<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-19.png\"><img loading=\"lazy\" decoding=\"async\" width=\"369\" height=\"473\" src=\"https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-19.png\" alt=\"\" class=\"wp-image-460\" srcset=\"https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-19.png 369w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-19-234x300.png 234w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-19-100x128.png 100w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-19-150x192.png 150w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-19-200x256.png 200w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-19-300x385.png 300w\" sizes=\"(max-width: 369px) 100vw, 369px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-20.png\"><img loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"549\" src=\"https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-20.png\" alt=\"\" class=\"wp-image-461\" srcset=\"https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-20.png 640w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-20-300x257.png 300w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-20-100x86.png 100w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-20-150x129.png 150w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-20-200x172.png 200w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-20-450x386.png 450w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-20-600x515.png 600w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-6.png\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"535\" src=\"https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-6.png\" alt=\"\" class=\"wp-image-447\" srcset=\"https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-6.png 624w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-6-300x257.png 300w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-6-100x86.png 100w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-6-150x129.png 150w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-6-200x171.png 200w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-6-450x386.png 450w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-6-600x514.png 600w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-21.png\"><img loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"549\" src=\"https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-21.png\" alt=\"\" class=\"wp-image-462\" srcset=\"https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-21.png 640w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-21-300x257.png 300w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-21-100x86.png 100w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-21-150x129.png 150w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-21-200x172.png 200w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-21-450x386.png 450w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-21-600x515.png 600w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/a><figcaption class=\"wp-element-caption\">Figure 3 &#8211; Edit Mappings to review translations and PREVIEW to see a sample of translated results.<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-22.png\"><img loading=\"lazy\" decoding=\"async\" width=\"601\" height=\"506\" src=\"https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-22.png\" alt=\"\" class=\"wp-image-463\" srcset=\"https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-22.png 601w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-22-300x253.png 300w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-22-100x84.png 100w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-22-150x126.png 150w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-22-200x168.png 200w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-22-450x379.png 450w\" sizes=\"(max-width: 601px) 100vw, 601px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-23.png\"><img loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"549\" src=\"https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-23.png\" alt=\"\" class=\"wp-image-464\" srcset=\"https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-23.png 640w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-23-300x257.png 300w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-23-100x86.png 100w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-23-150x129.png 150w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-23-200x172.png 200w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-23-450x386.png 450w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-23-600x515.png 600w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-10.png\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"535\" src=\"https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-10.png\" alt=\"\" class=\"wp-image-451\" srcset=\"https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-10.png 624w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-10-300x257.png 300w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-10-100x86.png 100w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-10-150x129.png 150w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-10-200x171.png 200w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-10-450x386.png 450w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-10-600x514.png 600w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/a><figcaption class=\"wp-element-caption\">Figure 4 &#8211; Optionally save the SSIS package to run at a later time.<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-11.png\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"535\" src=\"https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-11.png\" alt=\"\" class=\"wp-image-452\" srcset=\"https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-11.png 624w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-11-300x257.png 300w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-11-100x86.png 100w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-11-150x129.png 150w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-11-200x171.png 200w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-11-450x386.png 450w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-11-600x514.png 600w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><a href=\"https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-12.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-12.png\" alt=\"\" class=\"wp-image-453\" style=\"width:625px;height:536px\" width=\"625\" height=\"536\" srcset=\"https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-12.png 624w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-12-300x257.png 300w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-12-100x86.png 100w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-12-150x129.png 150w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-12-200x171.png 200w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-12-450x386.png 450w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-12-600x514.png 600w\" sizes=\"(max-width: 625px) 100vw, 625px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-24.png\"><img loading=\"lazy\" decoding=\"async\" width=\"486\" height=\"582\" src=\"https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-24.png\" alt=\"\" class=\"wp-image-465\" srcset=\"https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-24.png 486w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-24-251x300.png 251w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-24-100x120.png 100w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-24-150x180.png 150w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-24-200x240.png 200w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-24-300x359.png 300w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-24-450x539.png 450w\" sizes=\"(max-width: 486px) 100vw, 486px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-14.png\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"535\" src=\"https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-14.png\" alt=\"\" class=\"wp-image-455\" srcset=\"https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-14.png 624w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-14-300x257.png 300w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-14-100x86.png 100w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-14-150x129.png 150w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-14-200x171.png 200w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-14-450x386.png 450w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-14-600x514.png 600w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-25.png\"><img loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"549\" src=\"https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-25.png\" alt=\"\" class=\"wp-image-466\" srcset=\"https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-25.png 640w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-25-300x257.png 300w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-25-100x86.png 100w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-25-150x129.png 150w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-25-200x172.png 200w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-25-450x386.png 450w, https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-25-600x515.png 600w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/a><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>using SSMS Server Import and Export Wizard Step-by-Step using the SSMS SQL Server Import and Export Wizard to import AS400 files into SQL Server tables.&#49824; Note:&#49824; If you havent already done so, see my instructions to correct the IBM Data &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"\" href=\"https:\/\/tmainc.net\/?p=440\"> <span class=\"screen-reader-text\">Import AS400 Files into MS-SQL Server<\/span> Read More &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[3,5,8,4,6,7],"class_list":["post-440","post","type-post","status-publish","format-standard","hentry","category-as400","tag-as400","tag-ibm-data-provider","tag-import","tag-iseries","tag-sql","tag-ssms"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Import AS400 Files into MS-SQL Server - TMA Inc.<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/tmainc.net\/?p=440\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Import AS400 Files into MS-SQL Server - TMA Inc.\" \/>\n<meta property=\"og:description\" content=\"using SSMS Server Import and Export Wizard Step-by-Step using the SSMS SQL Server Import and Export Wizard to import AS400 files into SQL Server tables.&#49824; Note:&#49824; If you havent already done so, see my instructions to correct the IBM Data &hellip; Import AS400 Files into MS-SQL Server Read More &raquo;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/tmainc.net\/?p=440\" \/>\n<meta property=\"og:site_name\" content=\"TMA Inc.\" \/>\n<meta property=\"article:published_time\" content=\"2023-08-11T00:37:59+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-08-11T16:17:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-16.png\" \/>\n<meta name=\"author\" content=\"tommanntma\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@tommanntma\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"tommanntma\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/tmainc.net\/?p=440\",\"url\":\"https:\/\/tmainc.net\/?p=440\",\"name\":\"Import AS400 Files into MS-SQL Server - TMA Inc.\",\"isPartOf\":{\"@id\":\"https:\/\/tmainc.net\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/tmainc.net\/?p=440#primaryimage\"},\"image\":{\"@id\":\"https:\/\/tmainc.net\/?p=440#primaryimage\"},\"thumbnailUrl\":\"https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-16.png\",\"datePublished\":\"2023-08-11T00:37:59+00:00\",\"dateModified\":\"2023-08-11T16:17:56+00:00\",\"author\":{\"@id\":\"https:\/\/tmainc.net\/#\/schema\/person\/acad32c532effdd19cc22f46fdf48f2b\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/tmainc.net\/?p=440\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/tmainc.net\/?p=440#primaryimage\",\"url\":\"https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-16.png\",\"contentUrl\":\"https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-16.png\",\"width\":638,\"height\":847},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/tmainc.net\/#website\",\"url\":\"https:\/\/tmainc.net\/\",\"name\":\"TMA Inc.\",\"description\":\"iSeries ERP Support\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/tmainc.net\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/tmainc.net\/#\/schema\/person\/acad32c532effdd19cc22f46fdf48f2b\",\"name\":\"tommanntma\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/tmainc.net\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c4b570895af95829f469fb812a9191b2?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c4b570895af95829f469fb812a9191b2?s=96&d=mm&r=g\",\"caption\":\"tommanntma\"},\"sameAs\":[\"https:\/\/tmainc.net\",\"https:\/\/x.com\/tommanntma\"],\"url\":\"https:\/\/tmainc.net\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Import AS400 Files into MS-SQL Server - TMA Inc.","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:\/\/tmainc.net\/?p=440","og_locale":"en_US","og_type":"article","og_title":"Import AS400 Files into MS-SQL Server - TMA Inc.","og_description":"using SSMS Server Import and Export Wizard Step-by-Step using the SSMS SQL Server Import and Export Wizard to import AS400 files into SQL Server tables.&#49824; Note:&#49824; If you havent already done so, see my instructions to correct the IBM Data &hellip; Import AS400 Files into MS-SQL Server Read More &raquo;","og_url":"https:\/\/tmainc.net\/?p=440","og_site_name":"TMA Inc.","article_published_time":"2023-08-11T00:37:59+00:00","article_modified_time":"2023-08-11T16:17:56+00:00","og_image":[{"url":"https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-16.png"}],"author":"tommanntma","twitter_card":"summary_large_image","twitter_creator":"@tommanntma","twitter_misc":{"Written by":"tommanntma","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/tmainc.net\/?p=440","url":"https:\/\/tmainc.net\/?p=440","name":"Import AS400 Files into MS-SQL Server - TMA Inc.","isPartOf":{"@id":"https:\/\/tmainc.net\/#website"},"primaryImageOfPage":{"@id":"https:\/\/tmainc.net\/?p=440#primaryimage"},"image":{"@id":"https:\/\/tmainc.net\/?p=440#primaryimage"},"thumbnailUrl":"https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-16.png","datePublished":"2023-08-11T00:37:59+00:00","dateModified":"2023-08-11T16:17:56+00:00","author":{"@id":"https:\/\/tmainc.net\/#\/schema\/person\/acad32c532effdd19cc22f46fdf48f2b"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/tmainc.net\/?p=440"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/tmainc.net\/?p=440#primaryimage","url":"https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-16.png","contentUrl":"https:\/\/tmainc.net\/wp-content\/uploads\/2023\/08\/image-16.png","width":638,"height":847},{"@type":"WebSite","@id":"https:\/\/tmainc.net\/#website","url":"https:\/\/tmainc.net\/","name":"TMA Inc.","description":"iSeries ERP Support","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/tmainc.net\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/tmainc.net\/#\/schema\/person\/acad32c532effdd19cc22f46fdf48f2b","name":"tommanntma","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/tmainc.net\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c4b570895af95829f469fb812a9191b2?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c4b570895af95829f469fb812a9191b2?s=96&d=mm&r=g","caption":"tommanntma"},"sameAs":["https:\/\/tmainc.net","https:\/\/x.com\/tommanntma"],"url":"https:\/\/tmainc.net\/?author=1"}]}},"_links":{"self":[{"href":"https:\/\/tmainc.net\/index.php?rest_route=\/wp\/v2\/posts\/440"}],"collection":[{"href":"https:\/\/tmainc.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tmainc.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tmainc.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tmainc.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=440"}],"version-history":[{"count":5,"href":"https:\/\/tmainc.net\/index.php?rest_route=\/wp\/v2\/posts\/440\/revisions"}],"predecessor-version":[{"id":488,"href":"https:\/\/tmainc.net\/index.php?rest_route=\/wp\/v2\/posts\/440\/revisions\/488"}],"wp:attachment":[{"href":"https:\/\/tmainc.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=440"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tmainc.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=440"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tmainc.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=440"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}