OLE DB Source Dynamic

• krypto69

  SSChampion

  Points: 13606

  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?

• Eirikur Eiriksson

  SSC Guru

  Points: 182947

  More actions

  November 9, 2016 at 9:58 am

  #1911444

  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.