Monthly Archives: January 2012

Execute SQL Server Agent Job Task – SSIS 2012

Posted on January 31, 2012 by

Executing SQL Agent jobs is very simple with Execute SQL Server Agent Job Task in SSIS 2012. SSIS 2012 got a new task that helps us to execute jobs store in the SQL Server Agent. Implementation Step 1: Create a … Continue reading →

Posted in SQL Server, SSIS | Tagged , , , | 1 Comment

SSIS Event Handling

Posted on January 27, 2012 by

Events are used to alert users or administrators of any application. A complete application should have proper event handling mechanism. SSIS has this feature to raise an event with user defined message to give more meaningful information about the operation. Event Description FireCustomEvent … Continue reading →

Posted in SSIS | Tagged , , , | Leave a comment

Execute T-SQL Statement Task – SSIS 2012

Posted on January 26, 2012 by

Execute T-SQL Statement Task in SSIS 2012 helps us to write and execute TSQL statements inside the SSIS package instead creating it in database. It save a lot of developer’s time and help to manage code in one place. Execute … Continue reading →

Posted in SSIS | Tagged , , | Leave a comment

NASA On The Internet

Posted on January 23, 2012 by

I believe these links may not relevant to SQL Server. But, NASA may be using SQL Server to store their data for our future. Just browse these links and explore our universe. NASA Homepage http://www.nasa.gov NASA History http://www.nasa.gov/history Space Flight … Continue reading →

Posted in Uncategorized | Tagged | Leave a comment

Keep your Password Encrypted in database using PwdEncrypt and PwdCompare functions

Posted on January 20, 2012 by

Application might need to store user login information in SQL Server database. of course, we can easily store it in a table with varchar column. But, any authorized user can view this information and may get exposed to others too … Continue reading →

Posted in Security, SQL Server | Tagged , , , , , | Leave a comment