Create multiple flat files form Single SQL Server Table by Splitting Rows in SSIS Package - P182
Автор: TechBrothersIT
Загружено: 2016-04-12
Просмотров: 12168
Описание:
SSIS Tutorial Scenario:
How to Create multiple flat files form Single SQL Server Table by Splitting Rows in SSIS Package
Sometime we have tables with large of records. In one of the example, I created multiple flat files from single SQL Server Table by using distinct Column value. You can check the post here. If we have a column that can be used to divide the data, we can use that and create multiple flat files.
But we have a unique situation , we don't have any column in table that we can use to divide the records to multiple files. But we want to have a control how many records should be written to each file. Let's say we have a table with 5 million records and we want to create 5 files , a million records on each of the file. How we would do that?
This package can be used as template, By just changing the name of the table you can create files from any table, you will be able to define the type of file such as csv or txt. You can choose the file delimiter as well.
Link to script used in the video
http://www.techbrothersit.com/2016/04...
Check out http://www.techbrothersit.com/ 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
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке:
