Executing rs utility.

Hi,

I have two doubts :

1. The rs Utility has 2 arguments : -u username & -p password.

Is there any way by which we can use encryption/decryption for these parameters ?

2. Is there any way by which we can specify a url which indicates the machine name where the rs utility should be executed.

As rs utility would be present only on the machine where Reporting Services are installed. A way to specify the machine name where the rs utility should be executed would be helpful.

Thanks in advance.

1. No, unless you have custom security extension that knows how to decrypt them

2. The utility takes serverURL parameter.

|||

Thanks for the replies.

1. Even if we have I have a custom security extension, the rs utility should know how to decrypt the username/password. Can you please explain in some detail of how to use custom security extension ?

2. The serverURL parameter which the utility takes is the reportServerURL. I was searching for scenario where in :The Reporting Services (rs utility) are installed on X machine and I want a way to say that execute the rs utility on the X machine from Y machine. Is there any way to do this.

|||

1. A custom security extension (aka Forms-based Authentication) allows you to replace the default SSRS Windows-based security model, as explained in more details here.

2. So, your question is how to get an exe to execute on another box when I start it locally? I don't think you can do this.

Execute StoreProcedue in SQL2000 every time i received a replay me

Hi,
how can i execute a StoreProcedue in SQL2000 every time i received a replay
message with a specific subject, and pass some arguments like the subject.
thank in advanced,
Renato Ribeiro
Hi,
1. Create a Task to execute stored procedure
2. Create a message (SP_ADDMESSAGE) to create the subject
3. Using the message ID and Task name create a alert using SP_ADDALERT
4. Trigger the message using RAISERROR statement.
This will automatically fire the Task to execute the stored procedure
Thanks
Hari
SQL Server MVP
"Renato Ribeiro" <RenatoRibeiro@.discussions.microsoft.com> wrote in message
news:FA8C6A92-CB30-46B1-A9B8-187F43927B4D@.microsoft.com...
> Hi,
> how can i execute a StoreProcedue in SQL2000 every time i received a
> replay
> message with a specific subject, and pass some arguments like the subject.
>
> thank in advanced,
> Renato Ribeiro
>

Execute StoreProcedue in SQL2000 every time i received a replay me

Hi,
how can i execute a StoreProcedue in SQL2000 every time i received a replay
message with a specific subject, and pass some arguments like the subject.
thank in advanced,
Renato RibeiroRenato
How do you receive a message?
Have a look into JOBS , for more details please refer to BOL.
"Renato Ribeiro" <RenatoRibeiro@.discussions.microsoft.com> wrote in message
news:33C23D3F-60D2-4591-874F-FA9FA730DED6@.microsoft.com...
> Hi,
> how can i execute a StoreProcedue in SQL2000 every time i received a
> replay
> message with a specific subject, and pass some arguments like the subject.
>
> thank in advanced,
> Renato Ribeiro
>

Execute Process Task Arguments

HI,

Is it possible to provide variables ( multiple variables ) in the arguments parameters of the Execute Process Task?

Thanks

Shafiq

You can use multiple command arguements in one task by using spaces to delimit arguements.

Thanks,
Loonysan

|||To use variables in the process arguments, use Expressions tab and define an expression for Arguments property. You can use multiple variables there.

Execute Process Task arguments

We are attempting to use SSIS execute process task.

In a cmd.exe session the executable runs with normal arguments:

mycmd < myscript.txt > foo.txt 2>error.txt

We have attempted to several permutations of this without success. We declared variables and assigned them to stdin, stdout, stderr. However, mycmd opens in the SSIS session as if no arguments have been supplied.

Is there some expression that is required to connect the stdin/out/err variables in the Arguments within Execute Process Task. The help/examples are terse.

Redirections using < and > are not arguments, they are special symbols treated by cmd.exe.

To get the same behavior from Execute Process Task, you'll need to read content of myscript.txt into a variable and redirect program input to this variable; redirect output and errors to two other variables, then after program ends save these variables into foo.txt and error.txt.

But the easiest way to solve it is to use the 'cmd.exe' as the task executable, and supply your command (/C mycmd < myscript.txt > foo.txt 2>error.txt) as agruments for cmd.exe (/C added to instruct cmd.exe to executed specified command).|||

Thanks! We somehow missed the /C switch and that solved the problem.

Loading myscript.txt into a variable for use by stdin seems a bit problematic in our situation since it could be several hundred lines long and contain a wide spectrum of characters related to regular expressions that just seem like the perfect opportunity to tip it over.

We may look at the use of variables in the argument and see if we can move the scrum ahead.

|||Hello.

I'm trying to use the "Execute Process" task to compress several ASCII files in a folder in one ZIP archive. The command line for it looks as follows:

c:\programme\7zip\7z.exe a -bd U:\Projekte\TFG\Software\Log_storage\SCD_Demo_isHASH_34.zip SCD_Demo_isHASH_*.log

The result file has size of 2 KB.

When I put this command in the "Arguments" property of the "Execute Process" component (with "/C" switch and cmd.exe as executable), I get an empty ZIP file. What could be a reason for it? Has anyone already experienced such behaviour?

Regards,
Andrey