Forum Discussion

ssmith266's avatar
ssmith266
New Contributor
5 years ago
Solved

SQL Table into Excel File

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 e...
excel
pipeline
sqlserver
transform
  • ssmith266's avatar
    ssmith266
    5 years ago

    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's avatar
igormicev
Contributor
5 years ago

Note that you’ll have to additionally handle data result sets that are bigger than 100MB, the limit size for files in SLDB.

/Igor