ssis question 1

[FALCONSEYE]

I am working on my first Integration Services project. The idea is to import two excel files. My question is how do i define the data source so that the excel file name and location are dynamic?
any links or any suggestions will be appreciated.
thanks

http://www.jetansolutions.com

 

[SQLDenis]

Use a script task and change it on the fly

example

Dim theDate As DateTime = DateTime.Now()

        Dim theHour As String = theDate.ToString("HH")
        Dim FILE_NAME_IN As String = "\\someserver\devshare\WM\ba" + theDate.ToString("ddMMyy") + theHour + "xls"
        Dts.Connections("ExchangerateFile").ConnectionString = FILE_NAME_IN

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions

 

[Gadall]

Or use a For Each loop container and set it to enumerate for files, and point it at the directory that holds the files you want to process.

 

[FALCONSEYE]

Thanks for the responses. It seems like I have to do a little reading on visual basic .net. Any recommendations for a book on vb and ssis?

http://www.jetansolutions.com

 

[SQLDenis]

Take a look at Extending SSIS 2005 with Script

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions

 

[FALCONSEYE]

thank you sir!

http://www.jetansolutions.com