Hi, I am new to SSIS . I have just learnt to create a SSIS package through Data Flow Task. Using a Excel Source and a OLE BD Destination. Now i want that when i create a package while i migrate my data from Excel to DB i want to create a Error table as well . Please help. I tried taking one more OLE DB Destination, mapping it with the red line(ie error from excel source)But i couldnt succeed. Please let me know how to write errors. And Whne i am rumming the same package again. The Excel file data gets doubled into DB. How can i prevent that too . Thanks & Regards, Bhavika

I tried taking one more OLE DB Destination, mapping it with the red line(ie error from excel source)But i couldnt succeed. Please let me know how to write errors. What kind of error handling you want to implement? And Whne i am rumming the same package again. The Excel file data gets doubled into DB. How can i prevent that too . It should be simple..rt? Already there is data in the table (because of the previous execution). When you will reexecute the package the data will be duplicated. If you want to check this you can use an execute sql task to truncate the table before the data flow task execution begins.Nitesh Rai- Please mark the post as answered if it answers your question

Thanks Nitesh. But can you put a more light on how to "Execute sql task " nto truncate the table. As i said i am new to SSIS so dont know much. And about error handling, Just if any error occurs in the process when i upload data from Excel to DB , on any error just want it to Get inserted into Error table or so.Thanks & Regards, Bhavika

There is a task called EST.. there you have to write a SQL query to Truncate your table. and for logging the error, there are 2 ways.. 1: SQL server logging 2: custom logging Let us TRY this | My Blog :: http://quest4gen.blogspot.com/

Thanks a Lot ...... M tryingThanks & Regards, Bhavika