Did you know that the PASS Summit is right around the corner? Well Ok it’s in November but The Early bird discount expires on June 30th! Now is the time to register for the Best SQL Server summit around! They have also just announced some of the sessions on the Summit Website I would suggest taking a look at them. In my opinion there’s nowhere you can get so much great training on SQL server and networking with more SQL Dba’s then the PASS Summit. This also will be our largest Summit ever and the 10th summit in PASS’s History!
I almost forgot the Keynote Speakers are listed also. Typically Keynote’s are not the best sessions of the conference for me but with Ted speaking on the future of SQL Server I think that’s not going to be one to miss. I also met and spoke with Tom Casey at a Ms event recently and I think that will be a great presentation he’s interested in everything about SQL Server and should be an excellent keynote speaker.
Check it out and Get Registered! I hope to see you there!
I think I’m writing this as much for my sake as for others. Since I continually forget this setting here is how you pass in Parameters into SP’s your calling in your Execute SQL tasks’s in SSIS. In particular for this one I’m passing date’s which is common.
When you have a Execute SQL Task to set the paratemer your passing in as a Variable in SSIS here’s the Steps i’ve been using.
Create the Variable in SSIS, SSIS>Variables>NewIcon> Give it a name and type it should be scoped most likely as the whole package. That does depend on your complexity of the package.
Add your Execute SQL Task> When entering your Stored Procedure use Question marks for the parameters seperated by a comma. Then hit the parameters button and in the parameter name use each variable name from the stored procedure in the same order as you have Them in the stored procedure. Choose the Variable that it corresponds to on the other side. So you might see this.
From here hit Ok and you should have your parameters set to the proper information.
Hope that helps!