Tag Archives: Data flow task

SSIS, SSAS and SSRS(MSBI) interview questions: – Explain Data Flow Tab and Data Flow Task in SSIS?

When we think about creating any SSIS package, after we open the SQL server data tools or Business Intelligence development studio we will landed into SSIS designer window. As you can see SSIS designer contains many tabs at the top. … Continue reading

Posted in Uncategorized | Tagged , , , , , , , , , | 1 Comment

SQL Server interview questions: -Can you explain architecture of SSIS (SQL Server integration services)?

The complete SSIS architecture comprises of 8 components. Data flow task: – It defines source, mapping and transformation. It defines the core ETL process. Control flow task: – This section helps to define logic and invoke task like data flow … Continue reading

Posted in Uncategorized | Tagged , , , , , , , , | Leave a comment