Issue with loading data into table created in previous task

• nat_s

  Old Hand

  Points: 306

  More actions

  September 24, 2009 at 8:04 am

  #136306

  Hi,

  I'm having some issues. My first task creates a bunch of tables I need for my package. The second task loads data into one of these newly-created tables. How do I select the table from the list of tables when it doesn't yet exist? I can't map the columns unless a table is selected but I can't select the table. Is there some way to do this? In my OLE DB Destination task, I'm using Data Access Mode: table or view. Is this incorrect? Please help.

• Phil Parkin

  SSC Guru

  Points: 247180

  More actions

  September 24, 2009 at 8:57 am

  #1058080

  The problem you are having is that the table needs to exist before you can create the required mapping meta data.

  But there is a way round this:

  Allow the build task to happen, then do your mappings.

  Then set delay validation = true & delete the tables, then try the package again.

  ---