Showing posts with label fire. Show all posts
Showing posts with label fire. Show all posts

Friday, March 23, 2012

Need DTS/VBScript guru

I am trying to write a DTS package at work that uses a loop to fire a query off against a different server/database at each loop iteration. Prior to the execute SQL task , I use ActiveX (VBScript) to change the Catalog and DataSource of the connection (created by drag and drop if icon). My Execute SQL task selects @.@.servername and getdate() just as a dummy query to make sure I am actually pointed at a different server.

While testing the properties of the connection using global variables and msgbox shows that the database (catalog) and server (data source) ip address is being changed, the result returned is always from the first server. I feel like I need to disconnect the connection object, change the parameters and then reconnect to the new server but there doesn't appear to be anyway to do this.

Anyone out there able to successfully change a connection object inthis manner??I figured it out myself but just in case anyone else has this problem:

In order to use activeX to change a connection object DataSource/Catalog (server/database) from one SQL server to another one (different physical box) via ActiveX Script task you must set the RESUABLE property to 0 rather than the value -1 as mine had defaulted to. Now it all works like a charm...

Monday, February 20, 2012

Navigationbar when using http://servername/ReportServer/...

I have a button insida an application that fire up Explorer and send the user to http://servername/ReportServer/myreport......&MyParameter=AValue

I read that the ReportServer path was required instead of Reports in case parameters were sent in the URL. But when I use this path (ReportServer) I don't get the navigationbar at the top (with home, My Subscriptions, My Settings etc).

Is there any way of sending parameters via the URL and still have the navigationbar at the top?

regards

Andreas

Do you understand my question or should I be more specific?

regards Andreas