How to create a dynamic Path using SSIS

Fatehbourghoud
Fatehbourghoud used Ask the Experts™
on
HI ,

I need to set dynamicly the path to connect to an flat file , my path change daily
example :
C:\Business\SRCFILES\2010-10-19-1
C:\Business\SRCFILES\2010-10-20-1
C:\Business\SRCFILES\2010-10-21-1
the sequence colud change too in the same day
example :
C:\Business\SRCFILES\2010-10-19-1
C:\Business\SRCFILES\2010-10-19-2
 and if the sequence change , my connection take the path with the higher sequence

How can I set my path dynamicaly as specified above ?  please provide me a code or variable expression  

Thank's
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
In your connection property of the flat file, set the connection as expression to a SSIS variable. Then pass the path as ssis parameter.. Dont forget to set delayvalidation=true
regards,
Pedro

Author

Commented:
More details please about your solution

Thanks
Reza RadConsultant, Trainer

Commented:
what is the naming convention of files here? what is the last integer value in the name of files. you can use variables to generate filename dynamically and as Pedro said you can set it to flat file sources or other connections with expressions.
but for more details we need more information from you

Author

Commented:
answer complete

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial