Friday, 17 December 2010

JQuery - BlockUI & asp:Button controls

Using the BlockUI Jquery library to create a Yes/No prompt on the click event of an asp:Button control



* There were problems copying/pasting the jQuery function into here - So I had to screenshot for now
<div><asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Button" /></div>

<div id="question" style="display:none; cursor: default"> <h1>Would you like to contine?.</h1> <input type="button" id="yes" value="Yes" /> <input type="button" id="no" value="No" /> </div>

Thursday, 2 December 2010

SSIS Web Service Task, Variables and Setting up the SQL Agent

One of the things i've found the most difficult to find any sort of good help on, is SSIS.
I intend to write up a few of the important things that ive found and that are not necessarily clear in any official Microsoft atricles or KBs.

I'll start off with one of the things that took me the longest to find - If you have an SSIS package, that contains a Web Service Task that expects parameters, how do you pass parameters to it in SSMS?

SQL Server Agent

Setting the Parameters/Variables to pass to the Web Service
 
In the Set Values tab in the Job Step Properties of the package, you can set the value of the package variables, which will be used to be passed as the parameters into the Web Service. In property path, add :

\Package.Variables[VarName].Value (Where VarName is the name of the variable defined in BIDS - In this case the variable I want to pass is UserID) into the Property Path column and and value you want to pass in the Value column