- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-02-2020 12:06 PM
I have a pipeline that I am working on that requires data to be extracted and transformed in SQL Server (completed) and should be loaded into a single excel file. I cant seem to get my data into an excel file.
Has anyone completed a similar load, if so, how? What snaps and order did you use?
In my research I have seen a lot of articles about excel to DB but not the other way around.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-04-2020 06:28 AM
Thank you for the reply Robin, fortunately I was able to work through the issue. Your approach is correct - In the picture below I have a Netezza DB (JDBC Execute Snap) Table that I am select everything from, an excel formatter snap and a file writer snap.
.
![robin robin](https://iaudz84835.lithium.com/legacyfs/online/avatars/1X/ac75dc68e9e35db0ac6a3ea0485dad4243ef2c7e.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-03-2020 02:54 PM
@ssmith266 Do you know the SQL query you wish to execute that will return the data to be put into the Excel file?
Normally I would anticipate a user using the SQL Server Execute Snap, the Excel Formatter Snap, and a File Writer Snap to complete this task.
Perhaps you can please share what you tried so far and I can try to assist you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-04-2020 06:28 AM
Thank you for the reply Robin, fortunately I was able to work through the issue. Your approach is correct - In the picture below I have a Netezza DB (JDBC Execute Snap) Table that I am select everything from, an excel formatter snap and a file writer snap.
.
![igormicev igormicev](https://iaudz84835.lithium.com/legacyfs/online/avatars/2X/5/595e89338218a026f89254b51bbf2bfe8ab9519a.jpeg)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-05-2020 02:24 PM
Note that you’ll have to additionally handle data result sets that are bigger than 100MB, the limit size for files in SLDB.
/Igor
![](/skins/images/A5F8D4F9CE9DD11234D129690E6DC828/responsive_peak/images/icon_anonymous_message.png)