{"id":346,"date":"2016-01-28T14:00:58","date_gmt":"2016-01-28T13:00:58","guid":{"rendered":"http:\/\/sqlkover.com\/?p=346"},"modified":"2016-01-27T22:01:05","modified_gmt":"2016-01-27T21:01:05","slug":"reblog-building-the-script-component","status":"publish","type":"post","link":"https:\/\/sqlkover.com\/reblog-building-the-script-component\/","title":{"rendered":"Reblog: Building the Script Component"},"content":{"rendered":"

<\/p>\n

SQLKover update:<\/strong> For some reason, this was my\u00a0most popular blog post on the old LTD site. Over 110,000 views. People must be building them script components.\u00a0<\/em><\/p>\n

The problem<\/strong><\/p>\n

From time to time I have to script out some logic using a Script Component in a SSIS package. Business as usual for most developers, but since I hardly have a .NET background, it\u2019s always a very stressful experience (I may be over exaggerating a bit). Sometimes it happens I write a little piece of code with a small bug, it happens to the best of us.<\/p>\n

public override void Input0_ProcessInputRow(InputBuffer row)\n{\n    byte test = -1; \/\/ do something stupid here\n    \/\/ rest of the code\n}<\/pre>\nFor those who haven\u2019t noticed: you cannot store -1 in a byte. Anyway, the wonderful designer that is the Visual Studio shell fails to warn me of my little indiscretion. Leaving me with a script component that won\u2019t compile.<\/p>\n
<\/a>Yes, that\u2019s SSIS 2008 folks!<\/figcaption><\/figure>\nThe matching errors aren\u2019t helpful either.<\/p>\n<\/a><\/p>\n
The solution<\/strong><\/p>\n
The solution is elegant yet simple: we force the designer to tell us what\u2019s wrong by building the code inside the script component.<\/p>\n
<\/a><\/p>\n
This results in a blue squiggly being added to the code, together with a decent explanation.<\/p>\n
<\/a><\/p>\n
The moral of this story: if the script component is giving you a hard time, hit that build button!<\/p>\n
<\/p>\n<\/body>","protected":false},"excerpt":{"rendered":"
SQLKover update: For some reason, this was my\u00a0most popular blog post on the old LTD site. Over 110,000 views. People must be building them script components.\u00a0 The problem From time to time I have to script out some logic using a Script Component in a SSIS package. Business as usual for most developers, but since […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[5],"tags":[20,99,17,16],"class_list":["post-346","post","type-post","status-publish","format-standard","hentry","category-ssis","tag-reblog","tag-script-component","tag-ssis","tag-syndicated"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/sqlkover.com\/wp-json\/wp\/v2\/posts\/346","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sqlkover.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sqlkover.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sqlkover.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlkover.com\/wp-json\/wp\/v2\/comments?post=346"}],"version-history":[{"count":1,"href":"https:\/\/sqlkover.com\/wp-json\/wp\/v2\/posts\/346\/revisions"}],"predecessor-version":[{"id":354,"href":"https:\/\/sqlkover.com\/wp-json\/wp\/v2\/posts\/346\/revisions\/354"}],"wp:attachment":[{"href":"https:\/\/sqlkover.com\/wp-json\/wp\/v2\/media?parent=346"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlkover.com\/wp-json\/wp\/v2\/categories?post=346"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlkover.com\/wp-json\/wp\/v2\/tags?post=346"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}