Can't Find ConfigEdit

I installed the ConfigEdit XML editor mentioned in Kirk Haselden's great Integration Services book. But I can't use it unless I can find it! It's nowhere to be found in the Start menu or BIDS or right-click menus or inside projects. The book assumes you know where to go to open the editor. I'll be the first to eat crow if it's somehwere obvious. ConfigEdit installs to %ProgramFiles%\SSIS\Package Configurations Editor. I wouldn't call that obvious.|||

jaegd wrote:

ConfigEdit installs to %ProgramFiles%\SSIS\Package Configurations Editor. I wouldn't call that obvious.

The setup executable prompted me for the location to save it to... So, yes, it is obvious.

Did you guys run (do you have) SetupConfigEdit.msi dated 12/27/2005?|||

Thanks jaegd, got it!

Phil, the date of my SetupConfigEdit.msi is 12/27/2005, but I don't recall getting a prompt. It's possible I was surrounded by distractions at the time or I may have installed it and didn't have time to try it right away. In any case, it would have been helpful to mention the default location in the book. Oops, I'm supposed to be eating crow...

|||

Sorry folks... :(

What can I say. It wasn't like, my day job or something...

Hopefully, you get some facility from the utility!

K

|||

Kirk, if you wrote merely the best SSIS book out there (IMHO) in your spare time then I'm even more amazed. I'll be one of the first in line (or online) if you ever do a 2nd Edition. That's because I use this book a lot and would always want the latest version--something I can't say for most of the tech manuals on my shelf.

ConfigEdit is just what the doctor ordered when using XML package configurations. Without it I'd be stuck using a text editor right now. Yuk. It would be nice to have such a utility built in to SSIS...

Can't export report to CSV,XMl correctly, sql 2005 reporting service

Hi all,

I am developing reports using sql2005 report service. I can export reports in excel and pdf format, but can't export to csv and xml correctly.

The exported csv and xml files only contain some thing like the textbox,..., but no report content are there.

Anybody can help? thanks in advance.

BTW, all reports are matrix, is martrix can cause some issues?

Hi,

For most items on your report, you can define how it needs to be rendered to XML. For example the xml output for an item in a matrix can be set as follow:

select the item in the matrix|||

Thanks, Greert.

Your reply is really helpful. Now I know how to export report in xml format. But, how about CSV? I still can't export report to csv.

Thanks again

|||

Hi,

The same goes for CSV. For example if you set the Output of a column to No, you will see that the column is not included in the CSV file.

Greetz,

Geert

Geert Verhoeven
Consultant @. Ausy Belgium

My Personal Blog

|||Hi Geert,

Thanks a lot.

When I set th output of a column to yes, it works. Before, the the output of column was set to Auto.