BrianHawkinsTech

  • Increase font size
  • Default font size
  • Decrease font size
Home Development
Development

How to add Simple Error Alerting to an SSIS package

E-mail Print PDF
User Rating: / 1
PoorBest 

If you using SSIS to move data around, you may have jobs where error notifications can't wait until the next day.  It is extremely simple to add email/paging/text alerts to your SSIS package.  Here is how to add simple error alerting to your SSIS package.  Note this process is detailed for the MS SQL 2005 version of SSIS.

1.  Click in the open space in the Control Flow designer.

 2.  Click the Event Handlers tab in your SSIS package.

 SSIS_Alert_1

 

 

How to add Simple Logging to an SSIS Package

E-mail Print PDF
User Rating: / 1
PoorBest 

If you using SSIS to move data around, you will probably want to log package start/stop times and any errors that occur. This is much easier to setup than you might.  The first time you run a package with logging enable, SSIS will even create the log table for you! It just requires create table permission in the database you choose.  So without further ado, here is how to add simple logging to your SSIS package.  Note this process is detailed for the MS SQL 2005 version of SSIS.

1) Open package and right-click in the open space of the Control Flow tab.  Click Logging…

 SSIS_Logging_1

 

ASP.NET Menu control doesn't display properly in Chrome/Safari

E-mail Print PDF
User Rating: / 1
PoorBest 

There is an issue with the current versions of Chrome and Safari browsers that can cause the ASP.NET menu control to not render properly.  If you are interested in understanding the how and why behind this, there is a great forum post here that describes the issue in more detail.  If you are like me and need to resolve the issue now so your site displays properly, here is a quick fix for the problem.

You need to put the following code into the Load event of your page's (or master page's) code behind file:

If Request.UserAgent.IndexOf("AppleWebKit") > 0 Then

      Request.Browser.Adapters.Clear()

End If

There may be other solutions to this issue, but this appears to be one of the simpler fixes.  Hope this helps!

 

Get quick, free feedback on your website design

E-mail Print PDF

I recently came across a great site called FiveSecondTest.com.  The site has a basic free service where you can get some basic visitor feedback.  The free service includes feedback about where the user clicks and what they remember about your site.  There are also more detailed services available if you wish to register and buy credits.  If you are working on a new website design, I would definitely recommend spending a few minutes to get some user feedback.  I submitted a few of my sites to this service and was surprised by some of the feedback I received.  Check it out here.

 

Preparing your MS SQL database for use with ASP.NET Membership Provider

E-mail Print PDF
User Rating: / 1
PoorBest 

The ASP.NET Membership provider by default, will use a SQL Express database.  But if you want to use a database on an external SQL Database, you must prepare it.

This method uses Visual Studio 2008 (.NET 3.5) but will also work with ASP.NET 2.0.  It assumes you have already created a database(empty) and user name.

1)Go to Start Menu>Programs>Microsoft Visual Studio 2008>Visual Studio Tools>Visual Studio 2008 Command Prompt

2)You will enter the following command(with the appropriate values)

aspnet_regsql.exe -U UserName -S ServerNameOrIp -d DatabaseName -A m

3)Doing this creates all necessary tables and objects in your database to support the asp.net membership provider.  

4)After preparing the database, you are ready to add the connection string to you web.config.

 

For more information on using the ASP.NET Membership Provider, see the MSDN article here.  

 
  • «
  •  Start 
  •  Prev 
  •  1 
  •  2 
  •  3 
  •  4 
  •  Next 
  •  End 
  • »


Page 1 of 4

Recommended Web Hosting

hawkinstech150x150ad

Advertiser Links


Free Stuff!

Visit my Advertisers



LinkShare  Referral  Program

Newsflash

This site has been migrated to the new and improved HawkinsTech Hosting platform.  As part of this migration I have decided to upgrade and redesign the site.  I hope you found the new BrianHawkins Tech site to be more usable and helpful!