{"id":55,"date":"2007-07-05T19:16:52","date_gmt":"2007-07-05T19:16:52","guid":{"rendered":"http:\/\/www.nukeitmike.com\/blog\/2007\/07\/05\/SQLAndODBC.aspx"},"modified":"2007-07-05T19:16:52","modified_gmt":"2007-07-05T19:16:52","slug":"sql-and-odbc","status":"publish","type":"post","link":"https:\/\/blog.nukeitmike.com\/index.php\/2007\/07\/05\/sql-and-odbc\/","title":{"rendered":"SQL and ODBC"},"content":{"rendered":"<p>I was trying to figure out how to get some data from an ODBC source and put it into SQL, and found a post with an interesting possible answer:&nbsp;<\/p>\n<blockquote>\n<p><em>Recently, I&nbsp;discovered an issue&nbsp;with SQL Server Integration Services (SSIS)&nbsp;regarding how the Execute SQL Task item handles returning a result set to the control flow.&nbsp;Lets start by demonstrating&nbsp;an existing issue with the Execute SQL Task using ODBC then I&#8217;ll present a solution. First, create a new DSN that points to the database using the ODBC Data Sources Administrator (Control Panel | Administrator Tools | ODBC Data Sources).&nbsp;If&nbsp;you are only dealing with SQL Server you can still&nbsp;test this out by&nbsp;creating a DSN that uses the SQL Server ODBC&nbsp;driver.<\/em><\/p>\n<p><a href=\"http:\/\/blogs.simplifi.com\/brucet\/archive\/2006\/01\/27\/668.aspx\">Sql Server Integration Service (SSIS) Execute SQL Task ODBC Result Set Bug\/Workaround<\/a><\/p>\n<\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>I was trying to figure out how to get some data from an ODBC source and put it into SQL, and found a post with an interesting possible answer:&nbsp; Recently, I&nbsp;discovered an issue&nbsp;with SQL Server Integration Services (SSIS)&nbsp;regarding how the Execute SQL Task item handles returning a result set to the control flow.&nbsp;Lets start by&hellip; <a class=\"more-link\" href=\"https:\/\/blog.nukeitmike.com\/index.php\/2007\/07\/05\/sql-and-odbc\/\">Continue reading <span class=\"screen-reader-text\">SQL and ODBC<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[17,32,36],"tags":[],"class_list":["post-55","post","type-post","status-publish","format-standard","hentry","category-microsoft","category-sql","category-visual-studio","entry"],"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_likes_enabled":true,"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/pcW544-T","_links":{"self":[{"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/posts\/55","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/comments?post=55"}],"version-history":[{"count":0,"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/posts\/55\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/media?parent=55"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/categories?post=55"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.nukeitmike.com\/index.php\/wp-json\/wp\/v2\/tags?post=55"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}