EzAPI - SSIS Set EzOleDbDestination Error output configuration

Viewed 77

I am creating a C# Program to generate a SSIS package, does anyone know how to set the ErrorOutput property of an EzOleDbDestination object to "Redirect Row"?

Edit :

EzOleDbDestination db_dest = new EzOleDbDestination(dataFlow)
                    {
                        Name = "Destination " + File_Name,
                        Connection = oldb_connection,
                        Table = "[dbo].[" + File_Name + "]"

                    };
                    EzOleDbDestination db_dest_clean_error = new EzOleDbDestination(dataFlow)
                    {
                        Name = "Destination " + File_Name + "_CleanError",
                        Connection = oldb_connection,
                        Table = "[dbo].[" + File_Name + "_CleanError]"
                    };
                    db_dest.AttachTo(file_source);
                    db_dest_clean_error.AttachTo(db_dest);
                    db_dest.LinkAllInputsToOutputs();
                    db_dest_clean_error.LinkAllInputsToOutputs();
                    dataFlow.AttachTo(Sql_Create);
                    package.SaveToFile("C:\\Users\\LGuerin\\Desktop\\Package_" + Engagement + ".dtsx"); ;

enter image description here

1 Answers

enter image description here

These two lines make it work, Thank you billinkc for your answers!

Related