September 23, 2008 at 10:36 pm
Hi all,
Elementary question here, but I can't seem to find a straight answer.
When you're working in SSIS, often times you run into a situation where you need a destination for debugging purposes or to receive data (filtered or rejected rows, for instance) just so you don't have a dangling connection - a bit bucket if you will.
What do you use for that? I use a flat file, but that's kind of a pain, and not a great idea in some circumstances...
September 24, 2008 at 7:41 am
There's a custom component out there called the Trash Destination that you can download and use. Available here.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
September 24, 2008 at 8:25 am
You can also just use a derived column component. I often do that as I build a package and put a dataviewer on the pipeline so I can keep an eye on whats coming through without having to create a connection manager each time.
Kindest Regards,
Frank Bazan
September 25, 2008 at 10:26 am
Good answers - thanks a lot!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply