×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

How can we pass rejected rows to a table (Exception Handling)

How can we pass rejected rows to a table (Exception Handling)

How can we pass rejected rows to a table (Exception Handling)

(OP)
In my Mapping i have used 10 tables from two databases(in SQL SERVER)
I have some conditions on data which i have given in SQ trans i.e i have used two SQ's
1st SQ trans to join tables coming from one database A
2nd SQ trans to join tables coming from other database B
later i have used two exp's each for one SQ.
SQ1.uid(varchar)& SQ2.uid(char) to trim the spaces in EXP trans.
Later used JOINER trans to join SQ1.uid=SQ2.uid to join two database tables to get some rows into target.
After joinertrans, used EXP trans to define Hard-coded values & some conditions on fields,finally to target from EXP trans.

Now,if i want to handle all rejected rows, from which stage i need to collect the data???
i have defined conditions on data from SQ trans onwards & how can i add comments other transformations other than EXP trans,i have done it for EXP using COMMENTS button.

Is it important to add comments to transformations??

Could any one help me with Exception Handling.

RE: How can we pass rejected rows to a table (Exception Handling)

From whatever stage the rejection criteria is met. Usually that would be the last stage before the target insert/update. In your case it sounds like the last expression transformation.

I'm not clear on your comments question. I think all objects allow adding comments. You add comments where you think something needs to be explained to future readers/modifiers of your maps. I usually add comments in the individual ports doing the calculations/transformations, etc., rather than at the transformation level. You can use // to create a comment in the expression editor.

"I think we're all Bozos on this bus!" - Firesign Theatre jester

RE: How can we pass rejected rows to a table (Exception Handling)

(OP)
I have filtered the rows from SQ stage,the EXP before target gets all filtered rows where some expressions are only added in that stage to all row.So,how can i handle rows from diff transformations used before target????????

Thank you for reply
 

RE: How can we pass rejected rows to a table (Exception Handling)

Where do you expect the rejects to show up?

"I think we're all Bozos on this bus!" - Firesign Theatre jester

RE: How can we pass rejected rows to a table (Exception Handling)

Rejected rows into the target tables are automatically stored in a "bad" file as comma-delimited transactions.
Look for the folder structure Server\BadFiles - you should find a .txt file there.

RE: How can we pass rejected rows to a table (Exception Handling)

That's only for database errors or rejections in an update strategy. I believe he's talking about rejections based on his filter criteria (but I could be wrong... winky smile.

"I think we're all Bozos on this bus!" - Firesign Theatre jester

RE: How can we pass rejected rows to a table (Exception Handling)

Instead of a filter use a router transformation and write ' rejected' rows (or whatever fits the description) to their own target..

Ties Blom
 
 

RE: How can we pass rejected rows to a table (Exception Handling)

I agree - but the big q was at what point in the flow to do it at - so we're back to where are rejections expected?

You might have to have multiple routers and targets if you want to capture it at various states. Usually you would reject your data right before it goes to the target.

What are your requirements for this rejected data? Answer this and we can help you mo' bettah.

"I think we're all Bozos on this bus!" - Firesign Theatre jester

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close