krypto69 (11/9/2016)
Hi,I created an SSIS package that uses an OLE DB Source - pointed to a DBF file.
Problem is the name of my DBF changes.
The files will always have the same columns.
How do I change my package to accept the different file and table name in the ole db source?
Create a data connection, use the method of your choice (parameter/script task/file system task) to retrieve the file name and plug it into the connection string using an expression.
😎