{"id":1010775,"date":"2020-01-23T17:02:38","date_gmt":"2020-01-23T22:02:38","guid":{"rendered":"https:\/\/mkncreations.com\/site\/?p=1010775"},"modified":"2020-01-23T17:02:42","modified_gmt":"2020-01-23T22:02:42","slug":"insert-variable-value-from-ssis-package-to-sql-table","status":"publish","type":"post","link":"https:\/\/mkncreations.com\/site\/2020\/01\/insert-variable-value-from-ssis-package-to-sql-table\/","title":{"rendered":"Insert Variable value from SSIS package to SQL table"},"content":{"rendered":"<p>If you are trying to insert SSIS variable values into a SQL table here is one way of doing this:<\/p>\n<p>1. Create &#8220;Execute SQL Task&#8221;<\/p>\n<p>2. Under General on the left hand side panel enter the following to SQLStatement:<\/p>\n<blockquote><p>CREATE TABLE dbo.myTable (<br \/>\n[variable1] [varchar](100) NULL,<br \/>\n[variable2] [varchar](100) NULL<br \/>\n)<\/p>\n<p>INSERT INTO myTable(variable1,variable2) values(?, ?)<\/p><\/blockquote>\n<p>3. Under Parameter Mapping on the left hand side panel add the 2 variables under Variable Name. Direction should be set to Input on both. Data Type would be VARCHAR. Parameter Name should be 0 for the first variable and 1 for the second one. Parameter Size should be set to -1 on all<\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you are trying to insert SSIS variable values into a SQL table here is one way of doing this: 1. Create &#8220;Execute SQL Task&#8221;&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[192],"tags":[194,50,196,193,108,49,197,195],"class_list":["post-1010775","post","type-post","status-publish","format-standard","hentry","category-ssis","tag-insert","tag-sql-2","tag-sqltable","tag-ssis","tag-table","tag-tsql","tag-values","tag-variable"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/mkncreations.com\/site\/wp-json\/wp\/v2\/posts\/1010775"}],"collection":[{"href":"https:\/\/mkncreations.com\/site\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mkncreations.com\/site\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mkncreations.com\/site\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mkncreations.com\/site\/wp-json\/wp\/v2\/comments?post=1010775"}],"version-history":[{"count":1,"href":"https:\/\/mkncreations.com\/site\/wp-json\/wp\/v2\/posts\/1010775\/revisions"}],"predecessor-version":[{"id":1010777,"href":"https:\/\/mkncreations.com\/site\/wp-json\/wp\/v2\/posts\/1010775\/revisions\/1010777"}],"wp:attachment":[{"href":"https:\/\/mkncreations.com\/site\/wp-json\/wp\/v2\/media?parent=1010775"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mkncreations.com\/site\/wp-json\/wp\/v2\/categories?post=1010775"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mkncreations.com\/site\/wp-json\/wp\/v2\/tags?post=1010775"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}