Exporting data from a merge join from one data flow to another

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!

Export to PDF

It is possible to export 2 different report object to the same PDF file. I need to merge 2 or more report to the same pdf. I know its possible in Visual Fox Pro but i'm looking for this in C#.Net and I can't use a PDF Print Driver.Post this question at C# forum

Export to Excel - merge and centre issue

hi
I am exporting a report from SQL 2000 reporting services into excel and by
default all columns have merge and centre clicked. Can i change this so this
property is not checked which makes it easier for users to do things like
sorting etc.
Any help would be appreciated.
Thanks heaps
RidhimaIs this Excel export or CSV export? With CSV the default is Unicode which
Excel then merges (or doesn't split into different columns). In 2000 the
only thing you can do if this is the case is have a link the user clicks
that then uses jump to URL and you have it render in CSV ASCII. In RS 2005
you can configure it to export CSV in ASCII format as the default.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Ridhima Sood" <RidhimaSood@.discussions.microsoft.com> wrote in message
news:511E9718-8B0F-4A84-AF8D-71DA3598E104@.microsoft.com...
> hi
> I am exporting a report from SQL 2000 reporting services into excel and by
> default all columns have merge and centre clicked. Can i change this so
> this
> property is not checked which makes it easier for users to do things like
> sorting etc.
> Any help would be appreciated.
> Thanks heaps
> Ridhima