I might be blind, but I don\'t see how to CREATE the script component. I\'m not asking why do an asynchronous, how 开发者_运维技巧to work with it, etc. I just want to know how to add it to my package,
Got it working - Posted My solution below but will like to know if there is better way Hello All I am trying to create Domain Event for a newly created (after migration) domain object in my database
I havea table with 48 fields, i am filtering some data and need to use a script component( i need this for 10 of the fields in which i am actually changing the data)on the other 38 fields I only want
Is it possible to abort the processing of a row in the ProcessInputRow method? I\'m doi开发者_运维技巧ng some data validations with the incoming CSV data in this function. I\'m setting the row values
In my Script Component, am trying to execute Stored Procedure => which return multiple rows => of which need to generate output rows.
I need to load Dimensions from EDW Tables (which does maintain historical records) and is of type Key-Value-Parameter.
I have a SSIS 2008 script component which is setup as a transfo开发者_如何学Crm (so it has an input and output), and what I want to do is take 1 row in an input and optionally output multiple rows.