February 28, 2012 at 12:30 am
hi all,
IN SSIS i need to do below job i have a source and 2 target on contains clear data another with error data
If my Error table has more than one record then my job has to stop
can any one help on this...:-)
February 28, 2012 at 1:52 am
What do you mean with "job"?
Do you mean an SSIS package or a SQL Server Agent job?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 28, 2012 at 8:47 am
Hi
I want in SSIS Package,can u tell me which transformation should use:-)
February 28, 2012 at 1:22 pm
First let me guess your question.
You have a source (flat file, OLE DB, ODBC, Excel, Access, cave paintings, ... nothing is really specified)
and 2 targets (again, flat file, OLE DB, ...). I think I understood that one of those targets is for clean data and the other is for error handling, right?
So, data comes in and if one record is written to the "error target" the package has to stop. Correct?
How does this data come in? Are you using a dataflow, an Execute SQL Task, an Execute Process Task, a script task, ...?
What with the rows that are already been written to the "clean target"? Should they remain where they are, or should they be rolled back?
You need to be a little more specific when asking a question and provide us much information as you can.
Please read the links in my signature on how to ask questions on the forums and apply that knowledge. People will be able to help you much faster.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply