SSIS re-validation of metadata
Database
1
Posts
1
Posters
0
Views
1
Watching
-
Hi all. I have a massive SSIS job that transfers data between databases. Each of these tables has a separate data flow task. When I change the connection string for the source database, SSIS wants to refresh the metadata, so I have to go into each task individually and refresh the metadata, which is pointless and time-consuming. My question is... Is there any way I can do this more efficiently? Is there a select all/refresh metadata anywhere which I can use? Thanks in advance for any help.
Smokie, this is not 'Nam. This is bowling. There are rules. www.geticeberg.com