Hi,
Does anyone know if it is possible to point data that underwent the "merge join" transformation (in one data flow) to the following data flow I don't want to recreate all that merging, sorting and calling the same sources again in the following data flow if the data that I am using exists in the previous data flow. The merged data is simply too big to export to an excel file, so does anyone have any ideas Thanks!
Exporting data from a merge join from one data flow to another
AngiKL
Yes you need to specify a file and location. The type of the file is irrelevant. It doesn't even need to a filetype. Call it "C:\MyFile" if you want, it'll still work.
-Jamie
Adriann
Just use the 'Raw File Destination' component from SSIS toolbox to write the data stream to a file. Use the 'Raw File Source' component to open the file and access the data.
Frank
A Noble
Absolutely. Use raw files. That's exactly the sort of scenario that they are provided for.
-Jamie
_random
When you use the Raw File destination though, you need to specify a file name/location. What type of file should I create/use to link that raw file destination to
Thanks!
Fred de Lange
lagroue
What format can the "Raw Files" be in (excel, word, notepad, etc) or is it a .raw extension I'm not quite sure how to go about creating a file to use this type.....
Thanks.