Click here to Skip to main content
15,936,709 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:

How to make dynamic connection:

scenario: bag is my folder name and i get daily one folder with name like
next day c:\bag\21-05-2005

How to load the it in sql server 2008


1 solution

Do you want to say like this ?

next day c:\bag\21-05-2011....?

If yes , then you can use the Script task to get the folder with the latest modified date using the same connection string.
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900