Steps to create multiple text files from column of SQL Table:
1. Create Three variable including one Object Data Type.
2. Create Execute SQL Task and select Full Result Set, Write Distinct values of column in SQL Statement.
3. Select Object Data type variable in Result Set.
4. Drag For Each Loop Container and select ForEach ADO Enumerator and select Object Data type variable, and select Name variable in Variable mapping.
5. Drag DFT and read data from OLEDB source to Flat File Destination
Create one sample text document to get path during the configuration of Flat File Destination.
6. Write Expression in File File Connection Manager for Connection String property and Change the delay validation property.

свернуть