Krishna,

Could you be more specific with your requirements?

Baskar B.V (8/10/2010)

---

We...

T-SQL statement host_name() can be used to detemine the workstation name.

In your rsreportserver.config...

<Authentication>

<AuthenticationTypes>

<!--RSWindowsNegotiate/-->

<RSWindowsNTLM/>

</AuthenticationTypes>

</Authentication>

this will disable the handshaking (the credentials prompt) that used to appear while accessing any reports.

cheerz to Natalie:-):-):-)

In such scenario's it is best to delete the RDL's already deployed on report server and re-deploy them again.

Baskar B.V (8/6/2010)

---

Other option is to declare the variable as type "Object".

Then you have convert it back to string and store that in a string variable in an activex script...

Use a File System Task and all imports of file objects should be made on disk rather than SQL Server.

Abhit,

The problem is of Windows User authentication (NTLM Security policy)

Natalie,

It is difficult to understand your problem. Could you be more specific?

First of all the .RDL files you create using BIDS or Report Model use the DataSource Property....you may want to have a look at the RDL file once.

So, go ahead...

Shiv,

Certainly you are missing a File connection string.

Ron it's easier to understand. I believe you should try one yourself.

For example: Provide an incorrect connection string and catch/handle the error.

OnTaskFailed or OnWarning and many other events are availble and might be used as and when need arises.

Guru,

What is it that you wish to achieve?

Why are you using a dll to create a SQL script?