Hi,

I am really new to SQL 2005 and SSIS and I have created a simple SSIS
package using the wizard, but am wanting to make the ConnectionString
location come from a variable as the filename that I am importing
changes on a regular basis.

This is a simple flat file import so what I am hoping to do is keep the
base location for the file the same all the time and just change the
actual file name whenever I do the import. The task will hopefully be
part of a bigger stored procedure so want as little interaction from
the user/calling code as possible.

If anyone can help me it would be appreciated.

Thanks

Simon