04 Error Handling in Data Flow Task SSIS

[@nivetha.meceskct6693]

Thanks for this video very much useful to prepare my interview

[@learnssis]

Nice to hear that you liked the video.

[@PaulLundgren1970]

Excellent tutorial. Very well presented, no time wasted, and very easy to replicate on our own.

[@learnssis]

Thank you so much Paul.

[@nanajama4537]

This was clear and very useful! Please continue making these videos.

[@learnssis]

Thank you Nana Jama, sure that's what the plan is. If you want to see how to handle errors in whole SSIS package then you can check this video kzbin.info/www/bejne/l324lJyubL2ag6M

[@abhijeetpatil9883]

Very clear and exact contents.👍👍👍 Pl improve on audio. sometimes it's really low

[@learnssis]

Thank you Abhijeet for your suggestion.

[@omelturk4609]

Thank You again! Very Good Work! I like your way of teaching!

[@learnssis]

Thanks so much for your kind words.

[@ashutoshverma9978]

Hi sir thank you for useful information , Please help on below how to reject the whole file (so that no row including records also will not be loaded)if there is any error come in dataflow taks and then move that file to bad folder , and on success move it to archive Also errors will need to be logged somewhere and the next file should get processed, means if any bad file come reject it move it to bad folder log error the pick next file ...

[@Star-vg7ix]

very good coverage of this issue.

[@learnssis]

Thank you Star5 for your support.

[@koushaljha4507]

very well explained. Great

[@learnssis]

Thank you Koushal Sir, sab aapse hi seekha he.

[@ismail91s69]

Simply supebb explanation bro, thank u

[@learnssis]

Thank you Ismail.

[@alikhan-su2jj]

hi when i configure OLEDB Destination for error rows, all the data is going into that table, how can i fix it, can you help me please thanks

[@learnssis]

Take a look at this video, how to redirect the bad rows to another table. You would need to check each value to figure out why it is moving to errored record table. There might be issue with the data. kzbin.info/www/bejne/iHzCpHqffcyMjbM

[@ahimsapasalkar266]

Amazing videos sir But how can i get error description also in error table

[@saikrishnareddy6405]

Hi , I am importing 40 million rows from snowflake to sql server using ssis and the package taking 12 hours to complete the import. I am using linked server as source and sql server as destination. Snowflake server is created as Linked server in sql. Do you mind suggesting the best approach to import the data in fast manner. Thank you.

[@learnssis]

Sorry I never worked on snowflake, thus don't know how to pull data from it.

[@saikrishnareddy6405]

@@learnssis ho ok, but thanks for your reply,

[@ericsos101]

Hello, i am encountering this error in my ssis package:statement has been terminated.". An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "Cannot insert the value NULL into column 'ScreeningTool_fk', column does not allow nulls. INSERT fails.". what can i do to solve the issue?

[@learnssis]

This is a clear message that NULL value is getting inserted to column ScreeningTool_fk, try to provide some actual value for that column.

[@samirmeher4923]

Video is good and informative. Your voice in almost all the videos is bit low.

[@learnssis]

Thanks for your input. Yeah my voice specially in the older videos is slow and I have improved it over time for new videos I think it should be better.

[@simmi641]

How to solve package corrupt error???? Actually I cloned repo from tfs and from my local repository trying to open . dtsx package in vs professional 2013 i have ssdt 2013 also but error in loading package...it's giving ssis packages corrupt issue

[@learnssis]

Not sure what might be the reason, Can you share the error description here ?

[@simmi641]

@@learnssis The package failed to load due to error 0xC0011001 "The runtime object cannot be loaded from the specified XML node.this error

[@learnssis]

@@simmi641 Sorry, no idea.

[@filipesilva7924]

Hello Can you please help me with this error ?? Error: 0xC02020C4 at Data Flow Task, Source - "XXXXXXX" [6472]: The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020.

[@learnssis]

Is there some more error details available ?

[@filipesilva7924]

@@learnssis I can give you some more context. I'm trying to get about 300 000 rows from a DB2 DB table using a OLE DB Source object to get the data. But it is only getting about 27 000 records and then it stops fetching data from the DB2. Those 27.000 records are successfuly recorded into my SQL table. The next error I get is this one: Error: 0xC0047038 at Data Flow Task, SSIS.Pipeline: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on "Name of the OLE D Source" returned error code 0xC02020C4. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure.

[@learnssis]

@@filipesilva7924 Can you paste everything from output window ?

[@sathiyamoorthi9224]

Thanks Aqil

[@learnssis]

Glad you liked the video.

[@sathiyamoorthi9224]

Hi Aqil , Can you please upload the video, over all Package log based on job start time and end time.if its job success then status column populates Y or fail it populated N.

[@learnssis]

Sure Sathiya will create a video on this one as well.

[@sadafjahan2896]

Nice content.

[@learnssis]

Thank you.

[@1987Mrpankaj]

How to know for which column and values error getting.

[@learnssis]

Hi, in the SSIS_Bad_Rows table there is a column ErrorColumn which is containing the ColumnId for which it is failing and column Id Number can be found in SSIS's Data Flow Task: select the task component that generates the error, Advanced Editor, 'Input and Output Properties' tab, External Columns Properties. Thanks.

[@Stormraught]

Thanks!

[@learnssis]

Thank you so much Stormraught for your support. Although you actually don't need to pay, if you are viewing my channel then its more than enough for me.

[@muralimuthyala1965]

Thank you

[@learnssis]

You are welcome.

[@darrylw99]

But no error description, you have to guess.

[@learnssis]

It shows the error description.

[@darrylw99]

why do you get all the information concatenated to a csv instead of all of the rows as individual fields

[@learnssis]

@@darrylw99 I think you can see this video for your question kzbin.info/www/bejne/iHzCpHqffcyMjbM

[@darrylw99]

You can't see a description as with this video. No idea what the error is