SSIS Issue with Excel source

I've been doing a bit of SSIS (the data transformation technology formally know as DTS), and came across a nasty issue with using an Excel source to import data. The problem may not actually lay with SSIS - the Excel Source in SSIS uses Jet under the hood, and the problem could rest entirely with Jet.

The problem occurs where you have a sparsely populated column - SSIS/Jet will only sample a certain number of rows (I think it is configurable in the registry somewhere) to determine the type of the data held in the column. Say, for arguments sake, only 20 rows are sampled and no data is found. The type of the data will default to a string. If row 21 contains a numeric type or a date, this row will be silently ignored and treated as a null. This is a pretty crappy default behaviour - silently ignoring data that you are spending a lot of time (and clients money) to import. You have been warned!

Anyhow, here's the solution, enjoy:

1. Going to the Excel Connection Manager, I changed the Connection Strings to: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=H:\BillingReport\Upload.xls;Extended Properties="EXCEL 8.0;HDR=YES;IMEX=1"

MouseLight - spotlight around your cursor And ScreenLink - draw on screen

Overview: Sometimes it's difficult to tell an audience to look at a particular area of the screen. Whether its for a product demo, presentation, screencast or a lecture, this problem still exists. MouseLight tries to eliminate this problem. MouseLight puts a "spotlight" around your cursor and dims the surrounding area which enables your audience to effortlessly follow your path of movement on the screen.

Download



Overview: ScreenInk makes it possible to annotate, mark, and jot right on your screen. With several tools, such as highlighters and arrows, you can get your point across easily. This product is packed with a multitude of features, which are neatly arranged to avoid clutter. This version is the first release on CNET Download.com.

Download

Multi Skype Messanger

Run multiple Skype accounts

If you have Windows XP Pro, you can create and run more than one copy of Skype on your computer.

This lets you switch between accounts, or even chat to yourself.

To do this you will need at least one other Windows account

Follow the step's mentioned below

1 Go to Start, Control Panel, User Accounts. Load Skype as normal.

2.Then right-click the Skype shortcut holding the shift key and select Run As



3.Enter the user name and password of the other account and a second version of Skype will load.

Multi Google talk Messanger

Follow the Step's below

1.Righclick on the Google talk shorcut on the desktop.



2.Replace the text in target textbox with
“c:\program files\google\google talk\googletalk.exe” /nomutex



3.Click Ok

Debugging Stored Procedures in Visual Studio 2005

Follow the step's mentioned below

1.The first thing you want to do is add a data connection in the Visual Studio 2005 Servers windows. Right click on "Data Connections" and click on "Add New Connection":

2.Enter the required connection info in the "Add Connection" dialog and click "Test Connection" to test the connection. If that succeeds, click OK:



3.After you add the data connection you will be able to see the connection in the Data Connections tree:
We're going to debug "uspgetbillofmaterials" in this example (any proc will do, it really doesn't matter what proc YOU use). Drill down until you can see the proc you're debugging under the "Stored Procedures" folder:



4.Right click on the proc and click "Open". You will see the proc code in the code window:

"Now we debug"

5.Now that we've figured out how to open the proc we're going to get into actually debugging it. Right click on the proc and click "Step Into Stored Procedure":

6.A window with all of the parameters for the proc will pop up:

Notice it says "The stored procedure ... REQUIRES the following parameters:" That means you are REQUIRED to fill in the values. Otherwise the debugger will quit right away. That said; click the OK button to step into the procedure. The debugger will automatically stop execution on the first line of code in the stored procedure. When the debugger has stopped execution you'll see a yellow arrow to the left of the line of code:

7.Depending on how you have your Visual Studio settings you will click either F8 (VB) or F11(C#) to go to the next line of code. The debugger will execute the previous line of code and move to the next line

Debugging of Javascript in Visual studio

A) Open Internet Explorer, Tools menu -> Internet Option Dialog box.
- Click on Advance Tab.
- Clear the checkbox: Disable Script Debugging(Internet Explorer)
- Clear the checkbox: Disable Script Debugging(Other)


B) Use the keyword debugger in your script as breakpoint from where you want to start debugging.

XML documentation file for comments

For the spelling mistake I have downloaded a Visual Studio free add-in.Download

Steps to install this add in.

Spell checker now supports text verification in:

• HTML style comments <-- HTML -->
• ASP.NET server side comments: <%-- ASP.NET --%>
• Java Script, C# and C++ comments: // C++ style comments
• CSS and C style comments: /* C style comments */
• VB and VBScript style comments: 'This is VB comment

1. Close all the instance of the visual studio.
2. Install the Add-in.
3. Open the Visual Studio IDE, and open a page ex.-“html file or Class file.”, in which you want to check the spelling mistakes.
4. Click on Tools Menu, you will found “Spell Check”. Just Click on it.
5. If there is any spelling mistakes in the page, it will underling the word and also provides a suggestion list.
6. After Installing this add-in, in case if you are unable to find the Spell Check option under Tools Menu, please Apply the following steps.
7. Open the command prompt, Go to the Add in installation folder and run this command: regsvr32 vsspellchecker.dll

Find out more information about the spell checker @ http://blogs.msdn.com/mikhailarkhipov/archive/2007/12/12/spell-checker-for-html-asp-net-jscript-vb-c-css-and-c.aspx

sql server addons Free tools

SSMS Tools Pack - an add-in with lots of IDE options (Query Execution history, regions, debug sections, CRUD stored procedures creation, new query templates, running custom scripts from Object explorer's context menu) for SQL Server Management Studio and SQL Server Management.

Data Scripter - generates insert statements for a table

SQLDBSearch V2.0.0 (Freeware)

- With SQL Query Analyzer (SQL Server 2000) you can only search an object by its name.
- With SQL Server Management Studio (SQL Server 2005) the Filter option is very limited.
- Sp_depends can provide many irrelevant results since SysDepends table could be out off sync.

SQLDBSearch is a small and visual tool that is intended to fix this limitation and helps SQL Server developers and DBA to find objects that might be affected when they implement a database change. SQLDBSearch can find an object by its name or content in a specified database or the whole server.

The tool supports SQL Server 2005 and 2000 and requires Microsoft .Net Framework 2.0

Click here to download the tool
Click here to see some snapshots

Database Design principals & Normalization

Sample script to learn about database design principals.
1.Normalization concepts
2.creating database.

Normalization Database

Normalization queries

sql server new features

Sample script for

1. using comman type expression (CTE)
2. Pivot
3. cross apply
4. row_number
   
5. rank
6. dense_rank
7. top
8. Try/Catch Error Handling
9. FOR XML PATH
10. view
    
11. function

sql server new features

sql server selecting data

Sample script for selecting data. selecting data

Sql server Samples

Script for creating Northwind Database. Northwind

Script for creating Pubs Database. Pubs

Minimize Ram usage upto 70%

Simpye-minimize each application that u are currently not working on by
clicking on the Minimize button & u can increase the amount of available RAM by a substantial margin.
Depending upon the number and type of applications you use together, the difference can be as much as 50 percent of extra RAM.

online radio stations

Following is a list of online radio stations:

RadioTeental ==> http://www.bhejafry.net/liveradio.php?name=Station%202

BollywoodMusic FM USA ==> http://38.99.95.6:80

Guyana FM Radio ==> http://ibiza.broadstreamer.com:7090/

Radio Nimbooda ==> http://87.98.216.140:80

Mast Radio ==> http://64.72.127.206:8000

24/7 Oldies and Newies – Hindi (very good) ==> http://72.9.238.242:5555/live

Desi Music 24x7 ==> http://208.76.99.114:6293/

ApnaRadio - USA ==> http://www.apnaradio.com/live/listen64.pls

BombayBeats ==> mms://bb.1.fm/bbfm128k?MSWMExt=.asf

All work with Windows media player. Just open wmp and hit Cntrl+U and then paste the URL in dialog box and WOOOOOOOOF!!!! It works by streaming music directly to ur sys.....

What more u can add these to playlist so that u do not have to copy paste again and again.....

ENJOY!!!!!!!

Microsoft Extends Second Shot offer through June 30

Second Shot has been extended through June 30, 2008!

You can still get a free second chance to pass your Microsoft IT Professional, Developer, or Microsoft Dynamics certification exam with the "Second Shot" offer from Microsoft Learning and Prometric. Due to popular demand, Second Shot has been extended through June 30, 2008. Register for this offer before your next exam and receive a free exam retake if you don't pass on your first try.



· Sign up now http://go.microsoft.com/?linkid=8155858.

· Read frequently asked questions about this offer http://go.microsoft.com/?linkid=8155859.

Customers who have already registered for the offer will receive a separate e-mail with more information about the extension.

If you don't already have a certification strategy, consider one of the new Microsoft Certified Technology Specialist (MCTS) certifications--many requiring just one exam each--to demonstrate your skills on the newest technologies from Microsoft.



· Learn more about MCTS certifications http://go.microsoft.com/?linkid=8155860.

Create and publish your blog posts from MS Word directly.

Microsoft word is very flexible as compared to other previous versions. Even it has made the life of bloggers much easier. Blogger now no need to work twice. Earlier many bloggers including me also used to write a post on MS word and then used to copy and paste to blogger.com .Many of us blog like this and many of us directly scribe on blogger.com.But Microsoft has introduced a very nice feature in Word 2007.It has got the ability to publish directly to a blog and many more.You can use Microsoft Word to publish to Blogger, wordpress, Windows Live Spaces. You can refresh the list for the updated list available. You can also specify other blogging services.

To create a new blog entry, you need to click the Microsoft Office button situated at top left corner of the word2007 and click New. Double-click new blog entry.


You can now create your blog post. You can even insert pictures, links, etc. You need make sure you enter a title in the Post title box before publishing it.

To publish your blog post from Microsoft Word, click Publish in the Publish section of the Blog Post ribbon. To save your blog post as a draft in your blog account, click the arrow which is situated beside the Publish button and select Publish as Draft.You can even publish a document to a blog by clicking the MS Office button Click Publish and select Blog. Enter a title for your blog post and click Publish on the Blog Post ribbon as shown in screenshot.

When you create a post and before submission it will ask you to register for your account. If you have accounts with blogger.com then select blogger and enter username and password.

To register your blog account, first create a new blog post in Word. Then click Manage Accounts in the Publish section of the Blog Post ribbon.

Click New. Select your blog account provider; if it isn't listed, select Other. Click Next.

In the next dialog box, enter the information for your blog account. Click OK. Now you are ready to create a post and do blogging directly from MS word2007.

Now you can use Blogger right within Microsoft^® Word. Just download and install the Blogger for Word add-in and a Blogger toolbar will be added to Word allowing you to:

• Publish to your blog
• Save drafts
• Edit posts

Download

Download Social Music, Video & More

Orbit Downloader, leader of download manager revolution, is devoted to new generation web (web2.0) downloading, such as video/music/streaming media from Myspace, YouTube, Imeem, Pandora, Rapidshare, support RTMP. And to make general downloading easier and faster.

Orbit Downloader: is an excellent download manager that has the unique ability to download streaming media (audio and video, as well as flash SWF) from video sharing and other sites.

Orbit Downloader improves your Internet connection not only by making it faster and more reliable, but also by providing you with a more comfortable way to download Youtube videos, streaming content and even files from free hosting sites. It hardly uses any system resources and is perfectly embedded into your favourite web browser.

Social site downloading is the main appeal of this program. It supports HTTP(S), FTP, Metalink, RTSP, PNM, MMS, NSS, RTMP, embedded video from sites like YouTube, music from sites like Pandora, and files from sites like Rapidshare. It works with Internet Explorer, Firefox, Opera, Netscape, and Maxthon. Freeware.

• Make Youtube video download more smoothly!
• More Efficient mirrors selection algorithm and faster download sources!
• Maximum possible download speed, up to the fastest download manager!
• Download social music and video include Youtube, Pandora, Myspace easily
• Support all streaming media protocol include RTMP/ MMS/ RTSP

Download