What's the best way to do it in SSIS? RRS feed

  • Question

  • I am loading a lot of xls/csv files using a "Foreeach loop container".
    - There are a lot of rules for each column.
    - The loading of file should fail if any of the rules is not satisfied.

    Should I use Conditional Split for rule checking? How to fail the whole data flow task if a cell of data don't satisfy a rule?

    Wednesday, June 27, 2007 9:18 PM

All replies

  • BTW, I may have a lot of rules. What's the best way to manage the rules?
    Create a lot of VB.Net script functions? Can these functions be used by data flow transformation component? Any other approaches?
    Wednesday, June 27, 2007 9:24 PM
  • If you're going to maintain a bunch of VB.Net stuff, perhaps this should be coded entirely in VB.Net.  You'll have to edit the rules each time they change if you are going to use SSIS.
    Wednesday, June 27, 2007 9:28 PM
  • what type of the rules are?

    Will be modified?


    Wednesday, June 27, 2007 11:56 PM
  • Rules are used to find the problem data. There may have two sets of rules. One is used to count the problem rows. For example, there following rule may exist for column10.

    if column3='XYZ' then 
        column10 must be between 1 and 50 or null

    A update rule may update column10 to a value null if the above condition cannot be satisfied.
    Thursday, June 28, 2007 1:42 PM
  • In face, I am trying to similar a "rule engine".
    Thursday, June 28, 2007 3:13 PM