I need advice from you guys.
we have two clients like client A & client B
Client A has prepared the ETL using SSIS fully component based.
(like Lookup, Merge join, conditional split, for each loop, execute sql task(only for delete the records)
Client B has prepared the ETL using SSIS fully query based
(like they have done using query in OLEDB source in command line for JOIN, subquery, derived table like that).
Guys please help on this
which one is good practise
what are all the questions we need to ask Client B like why they use lot query instead of components
please help me "what are the possible questions" both the scenarios
View Complete Post