handling row length in SSIS

• Vladimir Kievsky-369224

  SSC Veteran

  Points: 218

  More actions

  February 1, 2007 at 6:00 am

  #116188

  I have created a SSIS package in BIDS for loading data from text file. I have bad rows where the last column is absent, and I need to reject those. The rows supposedly should have fixed length, and the way to solve this, as I see it, is to redirect rows to good/bad  destinations based on row length.<script></script>

  I see nothing in BIDS data flow components expressions or system variables handling row lenth. So come a Script task. I saw the Row object in samples of VB.Net scipts, and it has size property, which may be a solution.

  Can you help with a sample of routine doing that? Also, is there any web site with a good reference to all VB.Net classes, their methods and properties?

  Thanks in advnce

  Vladimir Kievsky

• Bill McDonough

  Grasshopper

  Points: 16

  More actions

  February 2, 2007 at 7:35 am

  #687414

  One way to do this is a script task. In the script, you'll have something like this:

          Public Overrides Sub ProcessInputRow(ByVal Row as rowInBuffer)

   

  In that function, you can use this to get or test row length:

      Row.FullRow.Length

   

  Hope this helps.

   

  Bill

   

   

• Vladimir Kievsky-369224

  SSC Veteran

  Points: 218

  More actions

  February 3, 2007 at 10:52 am

  #687636

  Thanks. I was able to go by using RaggedRight. Still, it was tricky: I needed to set row delimiter, it is a property without value by default.

   

• sankar.krish

  Grasshopper

  Points: 17

  More actions

  July 23, 2013 at 12:08 am

  #1634760

  Have considered using Len function in ssis ? Just curious .

• Phil Parkin

  SSC Guru

  Points: 247158

  More actions

  July 29, 2013 at 3:22 am

  #1636561

  Bill McDonough (2/2/2007)

  ---

  One way to do this is a script task. In the script, you'll have something like this:

  PublicOverrides Sub ProcessInputRow(ByVal Row as rowInBuffer)

  In that function, you can usethis toget or test row length:

  Row.FullRow.Length

  Hope this helps.

  Bill

  You are referring to a Script Component. Script Tasks are valid only in control flows.

  ---