Script Task VS Script
Component :
While
both the objects provide scripting environments using the VSTA engine, yet
there are inherent differences in their purpose and functions. This is due to
their design architecture and the placement in development environment.
Ø
The
main difference of Script Task and Script Component is the way the script is
executed by both the objects. The Script Task executes the script only once for
each execution instance of the task, while the Script Component generally
executes the script for each row, as it applies the custom transformation on
each of the data row reads.
Ø
The
Script Task is available in the Control Flow task tab, while the Script
Component works in the pipeline or the Data Flow Task.
Ø
You
can choose Script Component as a Source, a transformation, or a destination. The
choice of function and the metadata and properties you configure in the editor
results in creation of different members of the base classes in the
auto-generated code. The Script Task does not provide any such facility, as the
code generated is always the same.
Ø
The
Dts property works with only the Script Task and it is not available in the Script
Component.
Ø
The
Script Task supports breakpoints while Script Component does not support
breakpoints.
Hi,
ReplyDeleteThe above article given a value points about Difference Between Script Task and Script Component. Differences between the Script Task and the Script Component. ... The Script component is configured on the Data Flow page of the designer and represents a source, transformation, or destination in the Data Flow task. Purpose. A Script task can accomplish almost any general-purpose task.
Very nice blog! I enjoy reading through your article post, I wanted to write a little comment to support you and wish you a good continuation. All the best for all your blogging efforts....
ReplyDeleteThe Script Component provides another area where programming logic can be applied in an SSIS package. Each Script Task is called only once within a Control Flow, unless it is in a looping control. The Script Component has to be higher octane because it is going to be called per row of data in the data stream. Here we have some stuff regarding script component and script task. This information is helpful to you.
Using the script component in SSIS
I think your blog is great information source & I like your way of writing and explaining the topics. Keep it up. if You Want More Details about MSBI Interview Question click here.
ReplyDeleteThank you for sharing such a nice and interesting blog with us. I have seen that all will say the same thing repeatedly. But in your blog, I had a chance to get some useful and unique information.
ReplyDeleteIELTS Coaching in chennai
German Classes in Chennai
GRE Coaching Classes in Chennai
TOEFL Coaching in Chennai
spoken english classes in chennai | Communication training
Thank you for sharing, I would like to add that the script task can validate important columns in the source data and skip records that contain invalid data to prevent them from being copied to the destination. For example, a script can assess the reasonableness of a postage amount and skip records with extremely high or low amounts.
ReplyDelete