August 2010 UG Scheduled
After a big wonderful event conducted last month we are back on our normal UG sessions. Please go-ahead and register for the event, hope to see all the faces again.
Posts Tagged ‘chennai sql server user group’
May 2010 UG Presentation Material
We have conducted UG on 29th of May 2010 and it’s nice to see peoples around the room. You can download the presentation materials and scripts used during the presentation to play with it. Incase if you need any clarification you are welcome to contact the presenter.We know this is too late since we are busy with SQL Code Camp we are not able to upload it at the earliest.
February 2010 UG Scheduled
September 2009 Month Meeting Scheduled
We are back again for this months UG session. We have a slight change in timing for this week UG due to non-availability of conference room at our usual timings.
Venue: Microsoft Training centre, Radhakrishnan Salai
Landmark: Opposite to President hotel
Timings: 9:30AM to 12:30PM
Date: September 19th 2009
August Month Meeting Presentation Materials
The Chennai SQL Server UG for the month of August was held on 22nd of this month, refer this link for the details. It was a great learning experience and a good space for SQL networking. There were two sessions.
Engin Ardıç
| #
Thank you for nice article! That’s so helpful for me.
VidhyaSagar
| #
Sure will plan something when you come here
Mohamed Kabiruddin
| #
Hi Vidhysagar & Team,
I am happy to hear that the SQL Server User Group in Chennai is active and going strong. I came across your blog and wanted to attend one of your user group meetings.
I am basically a Chennai-ite and work as a Microsoft BI Consultant in Australia. I am an active member of PASS SQL Team in Australia and have also presented for PASS SQL Saturdays in Australia. I visit Chennai almost every year for holidays and I would love to attend one your sessions. I am happy to speak on any particular topic of interest and discuss case studies on some of the projects and the industry in Australia as well.
I recently presented on “Agile BI with SQL Server 2012″ for PASS. I am coming down to Chennai this August 2013 for a fortnight. Please feek free to get in touch.
Cheers,
Mohamed Kabiruddin
admin
| #
@aj — Both the scripts are same. In my example I’m passing the output value to a variable. In your example you aren’t passing it instead you make the task failure or success.
ajssis
| #
You are creating a lot of extra steps that are not required in the Script task. You fail to see the line right after your code that is
Dts.TaskResult = (int)ScriptResults.Success;
The opposite of this is
Dts.TaskResult = (int)ScriptResults.Failure;
The code you should be using is
// Check if the file exists
if (File.Exists((string)(Dts.Variables["FilePath"].Value)))
{
Dts.TaskResult = (int)ScriptResults.Success;
}
else
{
Dts.TaskResult = (int)ScriptResults.Failure;
}
If the file exists then the Script task result will be “Success”. If the file does not exist the Script task results will be fail.
Then all you do is set the Success direction flow (the green line) to go to your data flow task. If the result is Failure then the Failure direction flow (the red line) will go to your Update error task. Be sure to RIGHT-CLICK the direction flow and select “Failure” from the pop-up menu.