DCSIMG
Flat File - Yaniv Mor

Yaniv Mor

On SQL Server and Business Intelligence

Browse by Tags

All Tags » Flat File (RSS)
SSIS – Making the Text File Destination Dynamic
One of the data flow destination objects in SSIS is the Flat File destination object. You use this destination object when you export data from a source (SQL Server, Oracle, or anything else for that matter) to a flat file. This can come handy when you maintain an Operational Data Store (ODS) in a Data Warehouse environment and you need to store data in text files before loading it to the Data Warehouse database for example or when you need to distribute a segment of data to the outside world in...