I'm not sure why, other than i would have thought that the pipeline (inputrowbuffer) is handling the rows, ones at a time, and your logic to capture/hold the entire matrix...

What Lutz has described can also be done within SSIS also. Look at your flat file destination, and modify the settings for what character/s strings should be enclosed in.

I think i may have misunderstood the issue. When you say

When I am trying to export data from a SQL Server View onto a .csv file using the data...

Is the problem really that you're seeing different entity Nums between your SQL (dev?) environment and the production target environment? If so, are the record counts identical between the...

With a CSV (or any separated file), there is nothing to change, this is how it works 🙂

If you truly want a file that aligns the data (say when viewed...

Unless the data you're exporting is *exactly* the same length as the headers for the columns, you're never going to 'align' the headers with the data in the rows. ...

I know that they won't tell you what the target DB is, but can they confirm that the target field data type is integer (big or std)? Th enumbers...

It's technically feasible, in the end it's XML to XML. Unlikely you'll find any commercial utilities to do it though - RDL is inherently a format that is used...

Further to Greg's point, this post[/url] shows the config file and where to change it...

JC7,

After dropping your ftp task on the canvas:

- on the general tab, set the connection

- on the File Transfer tab, set

- the operation to...

Use an expression to set the file (name) that you want the FTP task to retrieve 🙂

um, why? Before I did any work on this, I would ask if the users intend to, say, export the SSRS report to PDF? Maybe i'm missing something...

Hey Sunny,

It might make it easier for ppl to help you with this issue if you post the MDX from both reports - that is, the MDX before the 2...

Parthi,

The steps are quite clear in the MSDN document. If this didn't work for you, you're going to need to post some more information about error messages, actions you've...

Your overall architecture is a little unclear to me but, assuming you only have the one windows user account accessing the service, but several connections being created (one per user...