Hi Brian, thanks for the response.

tns ping works from SQL SERVER box to the oracle server that is mentioned in the tns names file.

i think I can create a linked...

Thanks Andy, let me try this method you suggested  , keep posted

Thanks for replying back, I'll take a look at the suggestion

thank you I will try that

Thanks for all the help, I'll try this out.

This is how I get data in CSV format : As you can see the rows are not aligned to proper columns above

That's nice points you said. I was trying to automate this process using SQL Server agent job and selecting SSIS, once I have my export package saved. I tried using...

Thanks I will try that. This issue seems with only using excel 2007. If I select excel 2016 (while exporting) on another machine I don’t see this happening.

So appears I...

I am exporting data to excel , attaching the screen shot for reference. The defaults are selected while exporting..and the source is a query. The column type that comes automatically...

Hi, I used the export wizard for SSMS. This helps but some how I see a single quote in front of the columns - like 'ts

How can I remove this...

Thanks for the response I will check them

Hi Jeffrey, the user would then collect this data from the shared location and prepare report

Thanks a lot appreciate it

I feel that this database the repository database must be on the web application server where DPA is installed

I do not see any new database, I was also referring to the steps for registering a SQL server instance from the guide by solar winds

Which says below ==>

Oracle Repository...