Created Excel files dynamically in SSIS

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Business Intelligence » Created Excel files dynamically in SSIS

Created Excel files dynamically in SSIS

Rate Topic

Display Mode

Topic Options

Author

Message

chaseurpuli

Posted Friday, November 09, 2012 1:35 PM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, April 30, 2013 4:03 PM
Points: 20, Visits: 65

Can we load the data from multiple flat files (located in different folders) into multiple excel files (NOT excel sheets) using SSIS? Is there a way to create one excel file for each flat file dynamically? Please help! Thanks in advance.

Post #1383222

Koen Verbeeck

Posted Monday, November 12, 2012 12:52 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 9:06 AM
Points: 9,367, Visits: 6,465

If all the flat files have the exact same structure: yes. Use a For Each Loop with a dataflow inside and expressions on the connection managers.

If they don't have the same structure: no. It's not possible. You'd need to create seperate dataflows for each flat file.

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence

Post #1383530

« Prev Topic | Next Topic »

Permissions