Is there a way to refresh an OLE DB destination with coloum mappings after removing coloums from the OLE DB source
SQL query without deleting and creating it from the beginning ?
Currently the old coloums remain in the mappings, and the only way I see is to remove and create, but this does not seem to be the efficient way.
I just trying to choose the need table in OLEDB destination again and that seems refreshes the mapping.
Best Regards,Uri Dimant SQL Server MVP,
MS SQL optimization: MS SQL Development and Optimization
MS SQL Blog:
Large scale of database and data cleansing
Remote DBA Services:
Improves MS SQL Database Performance
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?