The latest articles on DEV Community by COZYROC (@cozyroc). https://dev.to/cozyroc https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Forganization%2Fprofile_image%2F933%2F110723cc-c1b4-4568-9b27-053eb80b72a1.png https://dev.to/cozyroc en Alex Biks Fri, 23 Aug 2019 08:48:06 +0000 https://dev.to/cozyroc/reinventing-ssis-scripting-with-javascript-cozyroc-1k37 https://dev.to/cozyroc/reinventing-ssis-scripting-with-javascript-cozyroc-1k37 <p>SSIS is a fantastic platform for automating your ETL scenarios. It provides many useful adapters and transformations out of the box. Additionally, when you need to handle anything out of the ordinary, you can create a script in C# or VB.NET. You can harness the full power of .NET Framework there and meet any special requirement.</p> <p>Still, everyone who has used SSIS scripting knows there are several pain points with it:</p> <ul> <li>Upgrading scripts to the next SQL Server version is not an easy affair, as the scripts are early-bound to the current SSIS framework modules.</li> <li>The script code is compiled to intermediate language (CIL) and embedded as part of each package. This makes it very difficult to programatically set or change the script code in an SSIS package.</li> </ul> <h5> <a href="http://cozyroc.com/ssis/javascript-task" rel="noopener noreferrer">JavaScript Task</a> and <a href="http://cozyroc.com/ssis/javascript-component" rel="noopener noreferrer">JavaScript Component</a> enable the automation of any custom logic in the Control Flow and the Data Flow of an SSIS package, via JavaScript scripting. Their purpose is similar to the standard Microsoft Script Task and Microsoft Script Component, but they aim to further simplify the development and maintenance of SSIS scripts. </h5> <p><a href="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fthepracticaldev.s3.amazonaws.com%2Fi%2F7qh0gmmtkkuqak3a4wjw.jpg" class="article-body-image-wrapper"><img src="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fthepracticaldev.s3.amazonaws.com%2Fi%2F7qh0gmmtkkuqak3a4wjw.jpg" alt="Alt Text"></a></p> <h5> You can download JavaScript Task and JavaScript Component from COZYROC website <a href="http://cozyroc.com/ssis/javascript" rel="noopener noreferrer">http://cozyroc.com/ssis/javascript</a>. </h5> <p><a href="http://cozyroc.com/download" rel="noopener noreferrer">COZYROC SSIS+ Components Suite is </a></p> <ul> <li>Free for test and development within Visual Studio</li> <li>Support for SQL Server 2005, 2008, 2012, 2014, 2016, 2017, 2019</li> <li>200+ reusable components</li> </ul> <p>Full article: <a href="http://cozyroc.com/blog/reinventing-ssis-scripting-javascript" rel="noopener noreferrer">http://cozyroc.com/blog/reinventing-ssis-scripting-javascript</a></p> ssis javascript etl sqlserver