SSIS conditional split

• Gordon Meyer

  SSC Enthusiast

  Points: 182

  More actions

  September 5, 2006 at 8:32 am

  #153171

  Hi,

  I would like to output to different (ideally dynamically created) sql tables based on the value of a column in a dataset.

  eg. A column is called 'weeknum' and defines which week table that particular row should output to. The week table may or may not exist at the time.

  If I could read the value of 'weeknum' into a user variable that would be great because I could then use that variable to define the output table name, problem is Im not sure if that is possible.

  What Ive tried so far is on Control Flow have for each loop with collection of Variable Enumerator. The variable is called user::weeks and has value "select distinct(weeknum) as weeknum from weektable". I then have a mapping to user:: OneWeekInLoop starting at index 0 (cannot be changed). Both are defined as data type String and are in scope.

  The first error I get is:Error: ForEach Variable Mapping number 1 to variable "User:: OneWeekinLoop" cannot be applied.

  Help is appreciated.

  Thx.

  Gordon Meyer

   

• September 8, 2006 at 8:00 am

  This was removed by the editor as SPAM

• Pieter Olivier

  SSC Rookie

  Points: 45

  More actions

  February 6, 2007 at 4:44 am

  #687981

  I get exactly the same error in my project package, the irony is when i test it in a test package it works.

  Then I decided to build around my test package that works and lo and behold, the moment the foreach container has to kick off i get the same error

  Error: ForEach Variable Mapping number 1 to variable "User::GLTRANNO" cannot be applied.

   

  I am so tired of this

  Help

  Pieter