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
30WAK_Cat
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
pogmothoin
Absolutely. Use raw files. That's exactly the sort of scenario that they are provided for.
-Jamie
Dan9057
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
Mahesh Bhosle
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.
Raccess
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!
Ana Elisa