Cообщество разработчиков на платформе Microsoft >
Форумы
>
SQL Server Integration Services
>
Exporting a table into multiple text files based on rows
Exporting a table into multiple text files based on rows
- Hi,
First of all, I'm very bad at SSIS and has hardly never used it, so bear with me.
I have this table, with about 8 million rows in SQL Server, and I would like to split it into four different text files, with about 2 million rows per file. I'm thinking conditional split, but I do not know how I can base the export on how many rows that is processed. Can anyone help me...?
Ответы
- In order to do that, you'll need to add some kind of a row count to your extracted data. You have a few choices:
1. The SQL RANK function.
2. A Script component that will number your rows.
3. A custom Row Numbering component.
Then you can Conditional Split your rows based on that row number.
- Помечено в качестве ответаYao-Jie Tang - MSFTMSFT, Модератор19 июня 2009 г. 9:02
Все ответы
- In order to do that, you'll need to add some kind of a row count to your extracted data. You have a few choices:
1. The SQL RANK function.
2. A Script component that will number your rows.
3. A custom Row Numbering component.
Then you can Conditional Split your rows based on that row number.- Помечено в качестве ответаYao-Jie Tang - MSFTMSFT, Модератор19 июня 2009 г. 9:02
