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.