{"id":910,"date":"2015-06-19T16:01:23","date_gmt":"2015-06-19T20:01:23","guid":{"rendered":"http:\/\/binaryworld.net\/blogs\/?p=910"},"modified":"2015-12-01T16:37:33","modified_gmt":"2015-12-01T21:37:33","slug":"reference-assembly-in-ssis-script-task-net-custom-assembly","status":"publish","type":"post","link":"https:\/\/binaryworld.net\/blogs\/reference-assembly-in-ssis-script-task-net-custom-assembly\/","title":{"rendered":"Reference Assembly in SSIS Script Task (.net Custom Assembly)"},"content":{"rendered":"

In this blog post I want to show how to reference custom .net Assembly in SSIS Script Task.<\/p>\n

Assume you want to use some JSON dll in your Script Task instead of this json connector<\/a>.<\/p>\n

Here are the steps.<\/p>\n

Add .net Assembly \u00a0(i.e dll) to GAC (Needed in SSIS Script Task)<\/h2>\n

using gacutil command. Make sure you assembly is signed with Strong Name<\/a><\/p>\n

To register\u00a03.5 Framework assembly<\/strong> use gacutil from below path:
\nC:\\Program\u00a0Files\u00a0(x86)\\Microsoft\u00a0SDKs\\Windows\\v7.0A\\Bin\\gacutil.exe
\nTo register 4.0 Framework assembly<\/strong> use gacutil from below path:
\nC:\\Program Files (x86)\\Microsoft SDKs\\Windows\\v7.0A\\Bin\\NETFX 4.0 Tools\\gacutil.exe<\/p>\n

Copy Assembly dll to SDK folder<\/h2>\n

After you GAC assembly you must Copy it to the following paths (NOTE: {version}<\/em> in below path can be 90,100,110,120,130 …)
\n90=SQL 2005,\u00a0 100=SQL 2008, 110=SQL 2010…. If you have 32-Bit machine then just copy to first path below.<\/p>\n

C:\\Program Files\\Microsoft SQL Server\\{version}<\/em>\\SDK\\Assemblies\\
\nC:\\Program Files (x86)\\Microsoft SQL Server\\{version}<\/em>\\SDK\\Assemblies<\/p>\n

\"SSIS
SSIS Script Task – Add reference to custom assembly – Copy to SDK folder<\/figcaption><\/figure>\n

Add\u00a0Assembly dll reference in SSIS Script Task<\/h2>\n
    \n
  1. open SSIS Script Task Editor<\/em><\/li>\n
  2. Add reference to Custom .net Assembly<\/strong> which we copied in the above step.\u00a0To add reference you have to browse dll which you want to use (e.g. \u00a0c:\\Program Files\\Microsoft SQL Server\\{version}<\/em>\\SDK\\Assemblies\\yourassembly.dll\u00a0)<\/li>\n
  3. Hit OK and Save.<\/li>\n<\/ol>\n
    \"SSIS
    SSIS Script Task – How to add reference to custom dll (assembly) in Script Editor<\/figcaption><\/figure>\n

    Now try to write some code and test your Script Task….<\/p>\n

    Hope this helps.<\/p>\n","protected":false},"excerpt":{"rendered":"

    In this blog post I want to show how to reference custom .net Assembly in SSIS Script Task. Assume you want to use some JSON dll in your Script Task instead of this json connector. Here are the steps. Add …<\/p>\n

    Reference Assembly in SSIS Script Task (.net Custom Assembly)<\/span> Read More »<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[29],"tags":[144,52,143],"yoast_head":"\r\nReference Assembly in SSIS Script Task (.net Custom Assembly) - BinaryWorld Blog<\/title>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/binaryworld.net\/blogs\/reference-assembly-in-ssis-script-task-net-custom-assembly\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"Reference Assembly in SSIS Script Task (.net Custom Assembly) - BinaryWorld Blog\" \/>\r\n<meta property=\"og:description\" content=\"In this blog post I want to show how to reference custom .net Assembly in SSIS Script Task. Assume you want to use some JSON dll in your Script Task instead of this json connector. Here are the steps. Add … Reference Assembly in SSIS Script Task (.net Custom Assembly) Read More »\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/binaryworld.net\/blogs\/reference-assembly-in-ssis-script-task-net-custom-assembly\/\" \/>\r\n<meta property=\"og:site_name\" content=\"BinaryWorld Blog\" \/>\r\n<meta property=\"article:published_time\" content=\"2015-06-19T20:01:23+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2015-12-01T21:37:33+00:00\" \/>\r\n<meta name=\"author\" content=\"Binary World\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Binary World\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/binaryworld.net\/blogs\/reference-assembly-in-ssis-script-task-net-custom-assembly\/\",\"url\":\"https:\/\/binaryworld.net\/blogs\/reference-assembly-in-ssis-script-task-net-custom-assembly\/\",\"name\":\"Reference Assembly in SSIS Script Task (.net Custom Assembly) - BinaryWorld Blog\",\"isPartOf\":{\"@id\":\"https:\/\/binaryworld.net\/blogs\/#website\"},\"datePublished\":\"2015-06-19T20:01:23+00:00\",\"dateModified\":\"2015-12-01T21:37:33+00:00\",\"author\":{\"@id\":\"https:\/\/binaryworld.net\/blogs\/#\/schema\/person\/77cf0a9a512dd22bff93c6a1b6374fe0\"},\"breadcrumb\":{\"@id\":\"https:\/\/binaryworld.net\/blogs\/reference-assembly-in-ssis-script-task-net-custom-assembly\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/binaryworld.net\/blogs\/reference-assembly-in-ssis-script-task-net-custom-assembly\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/binaryworld.net\/blogs\/reference-assembly-in-ssis-script-task-net-custom-assembly\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/binaryworld.net\/blogs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Reference Assembly in SSIS Script Task (.net Custom Assembly)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/binaryworld.net\/blogs\/#website\",\"url\":\"https:\/\/binaryworld.net\/blogs\/\",\"name\":\"BinaryWorld Blog\",\"description\":\"Tips and Tutorials for Microsoft SQL Server, SSIS, SSAS, Business Intelligence, C#, .net\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/binaryworld.net\/blogs\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/binaryworld.net\/blogs\/#\/schema\/person\/77cf0a9a512dd22bff93c6a1b6374fe0\",\"name\":\"Binary World\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/binaryworld.net\/blogs\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/eaea47799daa577835eb53e64dfd3e13?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/eaea47799daa577835eb53e64dfd3e13?s=96&d=mm&r=g\",\"caption\":\"Binary World\"},\"description\":\"Binary World is a Software Development company located in Atlanta, USA (since 2007). Binary World specialized in Business Intelligence, mobile, cloud computing and .Net Application Development.\",\"url\":\"https:\/\/binaryworld.net\/blogs\/author\/admin\/\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Reference Assembly in SSIS Script Task (.net Custom Assembly) - BinaryWorld Blog","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:\/\/binaryworld.net\/blogs\/reference-assembly-in-ssis-script-task-net-custom-assembly\/","og_locale":"en_US","og_type":"article","og_title":"Reference Assembly in SSIS Script Task (.net Custom Assembly) - BinaryWorld Blog","og_description":"In this blog post I want to show how to reference custom .net Assembly in SSIS Script Task. Assume you want to use some JSON dll in your Script Task instead of this json connector. Here are the steps. Add … Reference Assembly in SSIS Script Task (.net Custom Assembly) Read More »","og_url":"https:\/\/binaryworld.net\/blogs\/reference-assembly-in-ssis-script-task-net-custom-assembly\/","og_site_name":"BinaryWorld Blog","article_published_time":"2015-06-19T20:01:23+00:00","article_modified_time":"2015-12-01T21:37:33+00:00","author":"Binary World","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Binary World","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/binaryworld.net\/blogs\/reference-assembly-in-ssis-script-task-net-custom-assembly\/","url":"https:\/\/binaryworld.net\/blogs\/reference-assembly-in-ssis-script-task-net-custom-assembly\/","name":"Reference Assembly in SSIS Script Task (.net Custom Assembly) - BinaryWorld Blog","isPartOf":{"@id":"https:\/\/binaryworld.net\/blogs\/#website"},"datePublished":"2015-06-19T20:01:23+00:00","dateModified":"2015-12-01T21:37:33+00:00","author":{"@id":"https:\/\/binaryworld.net\/blogs\/#\/schema\/person\/77cf0a9a512dd22bff93c6a1b6374fe0"},"breadcrumb":{"@id":"https:\/\/binaryworld.net\/blogs\/reference-assembly-in-ssis-script-task-net-custom-assembly\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/binaryworld.net\/blogs\/reference-assembly-in-ssis-script-task-net-custom-assembly\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/binaryworld.net\/blogs\/reference-assembly-in-ssis-script-task-net-custom-assembly\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/binaryworld.net\/blogs\/"},{"@type":"ListItem","position":2,"name":"Reference Assembly in SSIS Script Task (.net Custom Assembly)"}]},{"@type":"WebSite","@id":"https:\/\/binaryworld.net\/blogs\/#website","url":"https:\/\/binaryworld.net\/blogs\/","name":"BinaryWorld Blog","description":"Tips and Tutorials for Microsoft SQL Server, SSIS, SSAS, Business Intelligence, C#, .net","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/binaryworld.net\/blogs\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/binaryworld.net\/blogs\/#\/schema\/person\/77cf0a9a512dd22bff93c6a1b6374fe0","name":"Binary World","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/binaryworld.net\/blogs\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/eaea47799daa577835eb53e64dfd3e13?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/eaea47799daa577835eb53e64dfd3e13?s=96&d=mm&r=g","caption":"Binary World"},"description":"Binary World is a Software Development company located in Atlanta, USA (since 2007). Binary World specialized in Business Intelligence, mobile, cloud computing and .Net Application Development.","url":"https:\/\/binaryworld.net\/blogs\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/binaryworld.net\/blogs\/wp-json\/wp\/v2\/posts\/910"}],"collection":[{"href":"https:\/\/binaryworld.net\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/binaryworld.net\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/binaryworld.net\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/binaryworld.net\/blogs\/wp-json\/wp\/v2\/comments?post=910"}],"version-history":[{"count":0,"href":"https:\/\/binaryworld.net\/blogs\/wp-json\/wp\/v2\/posts\/910\/revisions"}],"wp:attachment":[{"href":"https:\/\/binaryworld.net\/blogs\/wp-json\/wp\/v2\/media?parent=910"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/binaryworld.net\/blogs\/wp-json\/wp\/v2\/categories?post=910"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/binaryworld.net\/blogs\/wp-json\/wp\/v2\/tags?post=910"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}