Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Bhavika18
Starting Member
4 Posts |
 Posted - 2011-03-24 : 06:18:36
|
| 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 |
|
|
|
|
|
SSIS Package(Error File)