Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Passing a filepath in a variable

Author  Topic 

nicky_river
Yak Posting Veteran

55 Posts

Posted - 2010-08-24 : 03:43:57
Hi,

Can anyone tell me how to pass a value to a variable in SSIS for eg,

'C:\Documents and Settings\varunj\My Documents'

I want to assign the value of the above path to a variable in SSIS.
How can I do this ?

and how do i pass this assigned variable to a datasource in SSIS ?

(I have taken an excel source as the data source)

Please can anyone provide me with the exact steps

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-08-24 : 07:17:37
didnt i give you detailed steps here?
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=149172

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -