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!
Absolutely. Use raw files. That's exactly the sort of scenario that they are provided for.
-Jamie
|||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.
|||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
|||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!
|||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
|||Thanks everyone for your help!