Help creating SSIS

• rick.dickens

  Newbie

  Points: 3

  More actions

  July 10, 2014 at 8:56 am

  #290873

  I have a text file in an odd format that was created by a custom app for tracking serial numbers.

  The format is:

  ordernumber, numberofserial#s, serial1, serial2, etc...

  Example lines:

  1234, 2, 010101010101, 010101010102

  1235, 1, 010101010103

  1236, 4, 010101010104, 010101010105, 010101010106, 010101010107

  I need SSIS job to daily truncate table and repopulate with:

  order, serial

  order, serial

  1234, 010101010101

  1234, 010101010102

  etc...

  Any guidance appreciated.

  Oh this is in SQL 2008 but no SSIS forum here for 2008.

  Thanks!

• Evil Kraig F

  SSC Guru

  Points: 100851

  More actions

  July 10, 2014 at 12:55 pm

  #1728495

  Asynchronous script transform (google that phrase) to transform the input properly would be my recommendation here. You have a variable set of inputs you want to control for.

  The other option is delivery in full to a staging table, then use UNPIVOT and/or a UNION, followed by stripping out your NULL entries in T-SQL.

  ---

  - Craig Farrell

  Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

  For better assistance in answering your questions[/url] | Forum Netiquette
  For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
  Twitter: @AnyWayDBA