SSIS: Fuzzy lookup with dynamic configuration

1
votes

I have created SSIS package for fuzzy lookup.

enter image description here

I just want to know how to make each following properties dynamic passed to execute package for any database table's column.

  1. OLEDB_Source - Server, Database,Table and Column name.
  2. FL_Large_Data - Server, Database,Table and Column name.
  3. FL_Large_Data - Similarity threshold.
  4. OLE DB Destination - Server, Database and Table name.
1
sql-serverssissql-server-2008-r2
As @Yahfoufi indicates, you're asking how do I make all the internals of an SSIS package dynamic and that's not a feature of the product. The column metadata cannot change during execution - only at design time. You can change source/target names but the column names, their types, etc must remain consistent across runs – billinkc
@MAK i don't think you will get an answer other than the one you received. Yahfoufi's answer + billinkc comments are 100% true – Hadi

1 Answers

0
votes

Since you are aiming to use this package for different tables and columns (Maybe you can if you have a fixed and unified table structure), it cannot be achieved using expressions. You must automate the package creation in order to do that, you have many choices:

  1. Use BIML (Business Intelligence Markup Language )
  2. Use SQL Server DTS libraries
  3. Use some Wrapper libraries such as EzApi

For each one of the choices above, there are many tutorials found online, you can refer to them in order to create the package.