SSIS Tutorial Scenario:
How to export all the tables to Flat files dynamically from SQL Server Database in SSIS Package
You are working as SQL Server Integration Services(SSIS) developer. You need to create an SSIS Package that should create flat files for all the tables from a database dynamically. There should be one file for each table and it should be created with date-time.
Link to script used in the video
check out for free Technology Tutorials /Interview Questions
SQL Server Integration Services(SSIS) Tutorial
SQL Server Reporting Services (SSRS) Tutorial
SQL Server / TSQL Tutorial
SQL Server DBA Tutorial
Team Foundation Server
Microsoft Dynamics AX