Variable from a text file table

• cdavidson 21612

  SSC Enthusiast

  Points: 140

  More actions

  October 22, 2011 at 11:38 am

  #259152

  I have a flat file and since I brought the text into a table in the SSIS package, is there a way in SSIS to read a certain column and then a certain row and bring that into a variable? If so, how do you do it? I am stumped and running into a brick wall. Please help!!!

• prvmine

  SSCertifiable

  Points: 7007

  More actions

  October 22, 2011 at 12:51 pm

  #1398383

  this link was helpful to me

  http://www.mssqltips.com/sqlservertip/1443/integration-services-script-task-to-dynamically-build-package-variables/