question

aRookieBIdev avatar image
aRookieBIdev asked

Using Script Component as Destination in SSIS!!!

Hi , I have a situation where I need to validate the file structure of a text file. I am reading the text file using a file reader source and I am doing a row by row validation using a scriptcomponent as destination. My doubt is what happens to all the data.Is it trashed or loaded in the RAM? Is it okay for me to do this?I have heard of trash destination, but i am not supposed to use 3rd party tools. Kindly suggest me if it is acceptable to do this.
ssisscriptflat-file
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.