Variable in File System Task

• Sam1980

  SSC Journeyman

  Points: 98

  More actions

  September 23, 2010 at 5:32 pm

  #238766

  Hi All,

  I need to grab the results of a select statement in a variable and there are more than 1 rows in the result, but just one column.

  I used oledb source and wrote a select statement there and then added a RECORDSET DESTINATION, and set variable(of type object) there. All is well till here. However, I need to use this variable in a File System Task in a For Each Loop. But the File System Task only expects string variables. Any other way of doing this?

  Any help would be truly appreciated.

  Thanks in advance.

• Raunak Jhawar

  SSCoach

  Points: 15701

  More actions

  September 23, 2010 at 9:49 pm

  #1226685

  Sam1980 (9/23/2010)

  ---

  Hi All,

  I need to grab the results of a select statement in a variable and there are more than 1 rows in the result, but just one column.

  I used oledb source and wrote a select statement there and then added a RECORDSET DESTINATION, and set variable(of type object) there. All is well till here. However, I need to use this variable in a File System Task in a For Each Loop. But the File System Task only expects string variables. Any other way of doing this?

  Any help would be truly appreciated.

  Thanks in advance.

  Create an object type variable and using the Script task convert it into necessary type and include the logic you wish to implement in FST in the script task itself

  Raunak J

• H4K

  Hall of Fame

  Points: 3374

  More actions

  September 24, 2010 at 1:10 am

  #1226738

  Hi,

  does the for each loop iterates based on the no. of rows from select statement you mentioned ??

  Regards,

  Amar

  BI Developer
  SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
  Please visit... ApplyBI