Passing a variable to a table

• andrew 82282

  SSC Veteran

  Points: 206

  More actions

  February 13, 2013 at 10:16 am

  #289282

  Hi All

  I'm importing a number of tables with SSIS. I have a variable Filename used to select each individual file.

  I want to copy the value of this variable to a SQL table FilesImported each time a file is selected.

  I've added an execute SQL Task in the for loop container with the code

  INSERT INTO

  dbo.FilesImported

  SELECT

  + @[User::FileName]

  This isn't copying the value of the variable to the table.

  Any help would be appreciated.

• Orlando Colamatteo

  SSC Guru

  Points: 182279

  More actions

  February 13, 2013 at 12:30 pm

  #1587620

  andrew 82282 (2/13/2013)

  ---

  Hi All

  I'm importing a number of tables with SSIS. I have a variable Filename used to select each individual file.

  I want to copy the value of this variable to a SQL table FilesImported each time a file is selected.

  I've added an execute SQL Task in the for loop container with the code

  INSERT INTO

  dbo.FilesImported

  SELECT

  + @[User::FileName]

  This isn't copying the value of the variable to the table.

  Any help would be appreciated.

  That text cannot go into the SQLStatement field directly. You'll need to use an Expression. See the Expressions tab in the Execute SQL Task properties. Try setting the SqlStatementSource property to an Expression that looks like this:

  ="INSERT INTO dbo.FilesImported SELECT '" + @[User::FileName] + "';"

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato