This was a problem I racked my brains over for a while when I first started using SSIS. I found a few possible including using a File System task to copy a “Template” Excel file over the existing on, or generating unique files by appending the date.  I simply wanted to overwrite the existing data just like the Flat File Destination gives you that option.

My work around was as flows:

Create the Data flow the way you normally would, then go to the Control View Then add two Execute SQL Tasks before your data flow is called so it looks like this

Step 1: Add Execute SQL Task 1 to Control Flow

Step 1: Add Execute SQL Task 1 to Control Flow

Set both Execute SQL Tasks to use the Excel file

Step 2: Set Connection Manager

Step 2: Set Connection Manager

Set your first Execute SQL Task’s SQL Command drop your table which is also known as the sheet name of your Excel file.

Step 3: Drop Table

Step 3: Drop Table

Repeat step 3 on the second Execute SQL Command this time create your tables.

If you are new to SSIS or looking for some more advanced help, one of my favorite books is Professional Microsoft SQL Server 2012 Integration Services you should check it out.

Music is everywhere with today’s high speed internet is most home it is no wonder that music is even moving to the World Wide Web. Many radio stations allow you to stream their stations over the internet. Many websites have been developed around music, like www.jango.com, www.pandora.com, and www.last.fm. I recently released my second version of Jango Desktop and one of the features I implemented was the ability to look up lyrics. Before I started I was thinking about all the ways I could parse the lyrics out of an existing lyric’s websites database. During my searching I stumbled upon http://lyricwiki.org/. Here is a small description of LyricWiki from the website:

LyricWiki is a free site which is a source where anyone can go to get reliable lyrics for any song, from any artist, without being hammered by invasive ads.

At this point you are probably thinking to yourself the same thing I did “Great, but where do I start?” So today I am writing a step by step tutorial on how to use Lyric wiki in your .NET program.

Creating a simple lyric demo program:

Step 1 Create the Form

Step 1: Create the Form

Open visual studio and setup your form to look similar to mine.

Adding the web service:

Because LyricWiki offers a web service, you will want to add it to your program as a web reference. Right click on your solution and select add a web reference, or in .net 3.5 add a service reference -> then go to advance and add a web reference. The service’s URL is http://lyricwiki.org/server.php?wsdl you will want to add it like below if you press go you should see the available methods.

Adding a Web Reference

Adding a Web Reference

Writing the code:

Double click on your button on the form and let’s right some code to handle the lookup.

Add this to the top of your code:

using LyricsLookup.org.lyricwiki;

Then add this to the button clicked method:

private void LyricsButton_Click(object sender, EventArgs e)

{

LyricWiki wiki = new LyricWiki();

LyricsResult result;

string artist = artistTextBox.Text;

string song =   SongTextBox.Text;

if(wiki.checkSongExists(artist,song))

{

result = wiki.getSong(artist, song);

Encoding iso8859 = Encoding.GetEncoding("ISO-8859-1");

LyricsRichTextBox.Text = Encoding.UTF8.GetString(iso8859.GetBytes(result.lyrics));

}else{

StatusLabel.Text = "Lyrics not found in database";

}

}

Then run and test.

Download the full solution of LyricsLookup

 

New Way:

Facebook is constantly changing its layout. The new way to disable public search is to go to

  • Account – > Privacy Settings
  • In the lower left hand corner look for Apps and Websites
  • Edit your settings
  • Edit settings for the public search
  • Uncheck enable public search.

Old Way:

Login to Facebook and go to your privacy settings.

Privacy  Settings

Select the Search Settings

Search Settings

Uncheck:  “Create a public search listing for me and submit it for search engine indexing”

Public Search Listing

Edit:  As Dan pointed out in the comments. Make sure  your Search Visibility  is set to everyone for the “Create a public search listing” option to show up.

It may take a week or more for search engines to completely remove your listing from their indexes. However Facebook is a popular site so I am sure it gets index quite frequently.

So I just started testing out Adobe Photoshop CS4. I ran into a little problem to start with. Every new image I made would be solid black and  I could not see anything I was trying to do. When I first started using  the new version of Photoshop it gave me a message about implementing GPU processing. This was enough of a clue to get me started.

Steps to take to fix the black canvas:

Adobe recommends that you try to update your video drivers to support GPU processing, and if this works I would take this route as it will make Photoshop more powerful.

If that does not work try the following:

  1. Open  Photoshop go to Edit > Prefrences > Proformance.
  2. Then under GPU Settings uncheck Enabled OpenGL Drawing.
  3. A restart may be required, but I do not remember for sure.

Well that is what worked for me. I hope this helps others, because at the time when I Googled for a solution there was nothing.


So Digsby has been around for quite some time now. For those of you have not heard about Digsby or tried it, let me fill you in. Digsby is an instant messaging client that combines, emails, and social networking. This means you can have your AIM, GMail, and Facebook all in the same place. Until recently Digsby has been running great, however it would utilize a lot of memory. In it’s recent builds the developers have spent a lot of time optimizing the memory, and for that I am thankful and this is why I am writing this post, as a tribute to Digsby I am releasing some quick tips and tricks.

Skinning Digsby:

Digsby has some ultra cool skins and emoticons by default, however if you are looking for more. You can visit http://digsbies.org/ at this website you will find an assortment of downloads. Here you can find new skins, converstation themes, emoticons, and sounds.

Digsby Widget:

Digsby wants everyone to be able to communicate with you, even if they do not have an Instant message client themselves. Digsby has created a flash widget that can be embedded in just about any webpage. This will allow users to talk to you from a webpage such as facebook if you are online.

Digsby Log Converter:

Not from the developers of Digsby but, rather a man who calls himself UFGrayMatter, is a log converter. It allows you to convert your logs from other instant messaging clients such as Pidgin. It can be downloaded at http://www.logconverter.com

Shortcut Keys:

CTRL + TAB- Allows you to easily switch between tabs.
CTRL + ALT + TAB – allows you to scroll through the tabs in the reverse direction.
CTRL + UP ARROW – Recalls your last message typed, much like command prompt and unix based command line.

Please e-mail more I live by shortcut keys and will just keep a running thread here.