question

Peter001 avatar image
Peter001 asked

Error Rows Handle in Script Task SSIS

Hello All techie, may someone please help me on this. I have lots of text files in a folder location. Say for an example Company.txt, Code.txt. and inserting all these files to tables similar to the file structure. using **SCRIPT TASK** in **SSIS** For eg:- Company file to Company table and Code file to Code table. but i am trying to have some mechanism to handle error rows, something if error occur on rows than that rows move to error table. can anyone suggest how can we achieve inside script task. Thanks
ssisssis2012
1 comment
10 |1200

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

nidheesh.r.pillai avatar image nidheesh.r.pillai commented ·
Hi - Any specific reason why "Script Task: is being used rather than a "Data Flow Task" which would have been very efficient in handling error rows as well?
4 Likes 4 ·

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.