I would like to say thank you to all of those that attended my webinar on using C# scripts in SSIS. I had a lot of fun putting together examples for that presentation. There were a few things I could not cover due to time, but I think it went well. I didn?t receive a lot of questions, so below are the questions I did get, along with the answers. I have also uploaded the SSIS project along with the Powerpoint presentation and the all the scripts that I used. You can download them from the files page. Look for the file called Scripting Project.zip.
If you missed the webinar, you can view the recording here.
Questions from the webinar?
Q: Can you explain in more detail the difference between readonly variable vs readwrite?
A: Really the only difference is that a variable you select as ReadOnly is locked and cannot be assigned a value in the script. RearWrite variables, however, will accept values assigned in the script.
Q: Would a script component be more efficient than a derived column component, i.e., for millions of records?
A: That is a tough one. Ultimately, It will depend on what you are doing in the script. If you are manipulating fields in millions of records, the script component will more than likely be a little slower than the derived column. It also depends on how the code the written.
Q: Can C# tasks be used to pop up a form and request user input?
A: It does have the capability, but it only works when running in BIDS. If a package contains scripts that generate objects looking for user input (message boxes, forms, etc.), and it is deployed, that package will fail if it is executed.