OLE DB Source Dynamic

Question

OLE DB Source Dynamic

krypto69

SSChampion

Points: 13604
More actions
November 9, 2016 at 5:55 am

#331851

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?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

Eirikur Eiriksson SSC Guru Points: 182911 More actions · Answer 1

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.

😎