SSIS 2005 push csv import errors to a table

I have created a package to import rows into a table from a CSV flat file. Everything works great. But now I have to push any rows that fail to import to the staging table into a error taable so that I can report which rows failed. I have been successful in pushing those error rows to another flat file but I would like to push to a table if possible.
gcrickmanVP Information Technology ServicesAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jason Yousef, MSSr. BI  DeveloperCommented:
Just redirect the error rows to another OLEDB destination. a
0
Jason Yousef, MSSr. BI  DeveloperCommented:
Also if you want to redirect the OLEDB destination errors, this article talks about that

http://agilebi.com/jwelch/2008/09/05/error-redirection-with-the-ole-db-destination/
0
gcrickmanVP Information Technology ServicesAuthor Commented:
in your first post how did you add your destination columns to error output line?
When I open the OLE DB DEstination for the Error Output I see this?
 Image
So I can't seem to mapp the columns correctly and no way to add the columns
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

Jason Yousef, MSSr. BI  DeveloperCommented:
You do that from the flat file source, as in my screen shot and it'll redirect the error rows to the RED output and just connect a normal OLEDB source and map the columns to your separate table.
0
Jason Yousef, MSSr. BI  DeveloperCommented:
0
gcrickmanVP Information Technology ServicesAuthor Commented:
This is what I see when I click on the OLE DB destination when mappnig the columns.
I think the reason is that the data flow is only sending those three columns and not the source tables columns.
 oledb destination columns
0
gcrickmanVP Information Technology ServicesAuthor Commented:
Ok, so you destination table is holding those three columns. I think I get that now.
I was hoping that the destination table would hold the entire row data that errored out from the source. Is there a way I can see that?
0
Jason Yousef, MSSr. BI  DeveloperCommented:
No, because it;s an error column, or truncated column, means it task cannot read it, that's why no way to see it.

and it's the same in 2008 too, hopefully they can fix that or get a way around it.

But you could get the error rows ,out of the OLEDB destination because it's already in the pipe.
0
Jason Yousef, MSSr. BI  DeveloperCommented:
Ok, i'm thinking again, and I think the only way around it, is to read the file using a script component, that way you could redirect the whole rows to another output.
0
gcrickmanVP Information Technology ServicesAuthor Commented:
Cold you explain how I would get the error rows out of the OLEDB destination.
0
Jason Yousef, MSSr. BI  DeveloperCommented:
that's the rows that didn't make it to the database for any reason, due to constraints or such

check that
http://agilebi.com/jwelch/2008/09/05/error-redirection-with-the-ole-db-destination/
huslayer-509973.flv
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
gcrickmanVP Information Technology ServicesAuthor Commented:
Thank you so much. You have been really helpful. I am sure that I will have further questions with this project I am working on.
0
Jason Yousef, MSSr. BI  DeveloperCommented:
Sure, anytime...

Also you could e-mail me at huslayer@hotmail.com when you post a question so I can get on it right away...

Thanks
Jason
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.