August 11, 2014 at 1:39 pm
I need to get a stored proc (which does return a result set) out to a pipe-delimited text file. The text file should be CREATED at run-time, according to a set folder path, and then MMDDYYHHMMSS.txt as the file name.
I've been researching this but every road I read leads to creating a new flat file connection in data flow. When I do this and walk through the steps, the entire UI of the Flat File Connection Manager Editor makes it seem as if you are supposed to be giving the specs of an EXISTING file, which I am not - I want it created at run-time. So I have no columns, or preview, etc.
What am I misunderstanding here or missing?
August 11, 2014 at 4:01 pm
I was able to solve this because eventually I realized that I needed to drag a flat file destination, not a flat file source. Seems obvious, but the article I had read had a typo apparently and I was too new to realize I was reading misinformation. 🙂
August 12, 2014 at 12:50 am
ipisors (8/11/2014)
I was able to solve this because eventually I realized that I needed to drag a flat file destination, not a flat file source. Seems obvious, but the article I had read had a typo apparently and I was too new to realize I was reading misinformation. 🙂
The devil is in the details 😀
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply