SSIS SCENARIO

  • 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...:-)

  • 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

  • Hi

    I want in SSIS Package,can u tell me which transformation should use:-)

  • 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