August 26, 2010 at 1:25 pm
I have a foreach loop that looks for a file called Acceller*.csv because it could be Acceller08102010.csv or Acceller07012010.csv, basically has a date on the end.
I wana take that variable FileName and pass it to a script task, I have done this where it passes to dataflow
but didn't know if there was a way to send to script task.
Thanks, Stacey
August 26, 2010 at 1:37 pm
Just make sure that the variable is in scope for the script task. When you start the script task, the code shows you how to reference variables. You will need to put the variable into either the read-only variables property, or the read-write variables property of the script task to be able to read or read/change the variable.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply