Dundas Question

Are there more opportunities to use expression-based chart configuration with the Dundas charts? With the default charts, you are most limited to hard-coding your chart.

With Dundas, can you choose 3D or 2D based on an expression?

Can you choose chart styles based on expressions (e.g. cones verse bars)?

Can you choose chart types based on expressions?

Thanks,

Michael

Still hoping for an answer on this.|||

Shouldn't you just check this out at the source? Their docs are online

http://support.dundas.com/OnlineDocumentation/RSChart/webframe.html

You'd see some cool stuff, for example

http://support.dundas.com/OnlineDocumentation/RSChart/CodeEditor.html

Something tells me you can't switch chart type programmatically, and therefore not by expression, though.

>L<

dtutil and xml configuration file

Hi,

Im loading the packages with a dutil-batch from the file-system into the sqlserver.

All the packages have xml-configuration-file.

for %%f in (*.dtsx) do dtutil /FILE %%f /COPY SQL;%%~nf /DestServer server /QUIET

When I try to run the packages in the sqlserver environment there is no configuration file found.

Is there a possibility to transfer also the link to the xml-configuration-file xml-configuration-file with dtutil?

Thanks Gerd

Moving to a better forum|||Try using the DTSDeployment utility to deploy packages that reference configuration files. The deployment utility will allow you to specify where to put the config files and will update the packages accordingly.|||

Hi

I am also in the same boat. I dont want to use deployment utility as I want to create a batch file. adminstrator will use this batch file to deploy on prod server.

I have configuration file that needs to be deployed on server along with package. please tell me if it possible or please give me work around for this.

|||You can specify the location of the configuration file when you run the package by using the /ConfigFile switch of DTEXEC.

dtutil and xml configuration file

Hi,

Im loading the packages with a dutil-batch from the file-system into the sqlserver.

All the packages have xml-configuration-file.

for %%f in (*.dtsx) do dtutil /FILE %%f /COPY SQL;%%~nf /DestServer server /QUIET

When I try to run the packages in the sqlserver environment there is no configuration file found.

Is there a possibility to transfer also the link to the xml-configuration-file xml-configuration-file with dtutil?

Thanks Gerd

Moving to a better forum|||Try using the DTSDeployment utility to deploy packages that reference configuration files. The deployment utility will allow you to specify where to put the config files and will update the packages accordingly.|||

Hi

I am also in the same boat. I dont want to use deployment utility as I want to create a batch file. adminstrator will use this batch file to deploy on prod server.

I have configuration file that needs to be deployed on server along with package. please tell me if it possible or please give me work around for this.

|||You can specify the location of the configuration file when you run the package by using the /ConfigFile switch of DTEXEC.

dtutil and xml configuration file

Hi,

Im loading the packages with a dutil-batch from the file-system into the sqlserver.

All the packages have xml-configuration-file.

for %%f in (*.dtsx) do dtutil /FILE %%f /COPY SQL;%%~nf /DestServer server /QUIET

When I try to run the packages in the sqlserver environment there is no configuration file found.

Is there a possibility to transfer also the link to the xml-configuration-file xml-configuration-file with dtutil?

Thanks Gerd

Moving to a better forum|||Try using the DTSDeployment utility to deploy packages that reference configuration files. The deployment utility will allow you to specify where to put the config files and will update the packages accordingly.|||

Hi

I am also in the same boat. I dont want to use deployment utility as I want to create a batch file. adminstrator will use this batch file to deploy on prod server.

I have configuration file that needs to be deployed on server along with package. please tell me if it possible or please give me work around for this.

|||You can specify the location of the configuration file when you run the package by using the /ConfigFile switch of DTEXEC.

DTSConfig SourceSafe

When adding a SSIS DTSX package solution to Sourcesafe the SSIS Package Configuration file (.DTSConfig) is not included. We are using sourcesafe version 6.0d and Visual Studio 2005 Team Edition for Developers.It has to be added manually.|||Thanx for your feedback. I understood that. I don't agree with the fact that it shouldn't be automated. Think of a multi property config file with 100 or so lines. I realize that the configuration is machine specific, but would not want to reenter those 100 lines if a system was lossed.|||You should file a bug report on Microsoft Connect (or join an existing one - there was another post about this a while back that may have resulted in a bug report). I tend to agree with you, I'd like to have the option to include it automatically. Just not sure how you would work around the machine specific nature of the configurations.

DTSConfig SourceSafe

When adding a SSIS DTSX package solution to Sourcesafe the SSIS Package Configuration file (.DTSConfig) is not included. We are using sourcesafe version 6.0d and Visual Studio 2005 Team Edition for Developers.It has to be added manually.|||Thanx for your feedback. I understood that. I don't agree with the fact that it shouldn't be automated. Think of a multi property config file with 100 or so lines. I realize that the configuration is machine specific, but would not want to reenter those 100 lines if a system was lossed.|||You should file a bug report on Microsoft Connect (or join an existing one - there was another post about this a while back that may have resulted in a bug report). I tend to agree with you, I'd like to have the option to include it automatically. Just not sure how you would work around the machine specific nature of the configurations.

dtsconfig file is binary?

Hello all,

I'm trying to easily change a value in 80 ssis configuration files from "localhost" to "myservername". I downloaded WinGrep to do this, but it's balking on some of the files, saying that they are binary files.

Does anyone know how to make the *.dtsconfig files NOT binary in SSIS?

Any suggestions GREATLY appreciated.

I won't go into the reason I have my servername in 80 places...

Andy

The .dtsconfig files are XML files - i.e. mostly text, but sometimes you need to be careful with the encoding (typically utf-8) to keep it valid XML. I have no experience with WinGrep, or why it thinks it is "binary". I would suggest using XML-aware tools to modify .dtsconfig.|||

Thanks for the tip Michael. Do you know if notepad is XML-aware? Because that's the only tool I used to edit them.

Also, I tried just creating a clean .dtsconfig file from the package configurations wizard and then pointing WinGrep at that file and I got the same thing, saying it was binary. I didn't modify it at all outside of the wizard.

|||The .dtsConfig file is a text file, in UTF-8 encoding. If you don't configure any localized (non-English) properties, UTF-8 is identical to ASCII encoding - in that case any text processor can work with it. Notepad can typically detect the encoding correctly even if you have non-English properties, so it should be OK in any case.

Again, I have no idea why WinGrep thinks it is binary, maybe because it is just one line.|||

Hi Michael,

You hit the nail on the head with that last sentence. I just put a carriage return in the file so it was more than 1 line and now WinGrep doesn't think it's binary anymore. Weird. Anyway to make it so that a configuration file is created on more than 1 line?

|||

Ok, so in order to make it so it's not just 1 line, in BI studio, with your config file open in then center pane and your cursor inside the file, go to Edit/Advanced/Format Document. This will format the document better as well as put it on more than 1 line. Now WinGrep has no problem.