I found the solution by changing the similarity and confidence variable names in the second fuzzy match. Thank you.

I found the solution by changing the similarity and confidence variable names in the second fuzzy match. Thank you.

Thank you for asking. I found the solution (from 40min to 1 min) by replacing all the script components with the other tools available in the data flow. But, only...

I am selecting the source table. I found the solution from one of the forums in which you only gave that we have to use distinct in the query to...

Thank you so much for the response. My source is a table.

Thank you for the response. I am taking a source table and splitting the data into multiple related tables. When I am using the script component at the place of...

Thank you for your response. I have tried different combinations. Nothing is working. I tried till 100000 for maxrows and 10485760 for size. Please let me know for any other...

No, is it the only solution? Thank you for your response.

Not many I guess. But, who ever is using is there any way that their account information (server name, uid, pswd ...) will be updated automatically. Thank you.

Thank you for the reply. I have created the config file with the password option:

\Package.Connections[sqldev01.lac.authenticom.com.AUTHENCustomer.rnayani].Properties[Password]" ValueType="String"><ConfiguredValue>test123</ConfiguredValue></Configuration><Configuration ConfiguredType="Property" Path="\Package.Connections[SQLDEV01.lac.authenticom.com.AUTHENCustomer.rnayaniADO].Properties[Password]" ValueType="String"><ConfiguredValue>test123</ConfiguredValue></Configuration></DTSConfiguration>

But, it is not executing at his end as the server name...

Thank you for the response. Lookup is required for the package but I want to know the flow of the data. In short I have the following tables which need...

Thank you for the reply. It is very useful. But, I found another easy process as I created a new ADO.NET connection to my database and connected through regular process....

Thank you so much for your response. I can't use UNION as I am not trying to combine same kind of data (Id in one and names in other one)....

I found that if I take any other exact match column with the existing one then it is showing the reference values as well as the threshold values. I don't...