Hi

Jeff,

I came to forums after a long time and good to see you again.

Thanks for the response!

Do you know any work around on this, lets say i want it like this format;

Inside SSRS Report Item matrix(Desired Format). I need Offered as int data...

Is it real this can't be done? If this is true what is the reason behind this?

Thanks for the prompt response

yes, it has something to do with Proxy account?

If so , how do i work around?

Simon

EXEC MSDB.dbo.SP_SEND_DBMAIL

@profile_name = 'Reporting Team'

,@recipients = 'a@microsoft.com; ...

Using the SSIS default component, you cannot create the excel file on the fly, the file needs to be there and you need to specify the spreadsheet. If you desire...

When u create new flat file connection manager from General tab,use format as Ragged right from drop down option.Then move to column tab as you will see the image...

Is this the way the data is actually coming along?, i mean is the heading like unit is repeating itself through out the text file?

Hey

Jack

I was using that extra quoatation, after using just one as text qualifier , it worked perfect.

Thanks a lot, i guess sometime we just think too hard and undermine...

Hey

Paul

the data in the test.xls is kind of misrepresentation, i saved the original csv file in xls format since the forum did not gave me an option to attach csv...

hi

Jack

I use the double quote as " " in the text qualifier for flat file connection, still did not work

Thanks

simon

Hi

Jack

I have upload the attachment by saving it xls format because the forum did not let me upload the csv format and you can look at the office name field...

yes paul , i want to remove the comma inside the quoatiation

Thanks

Simon

Hi

Jack

Thanks for the quick response and the reason why i post in both the forum was because i was not sure where it will fit and i was in quite...

Hi

King

Awesome, it worked perfectly as i expected, thanks a lot

I appreciate all your work and hope to continue this thread if needed:D

Thanks

Simon