I have previously written article how one can import a CSV file into a database table using SSIS package. This was a simple import operation when the CSV file structure corresponded to the table structure column-to-column. However SQL Server Integration Services is a very powerful tool that can be used for much more complex data import CSV operations.
SQL SERVER – Remove Cached Login from SSMS Connect Dialog – SQL in Sixty Seconds #049
One of the most annoying thing which I have personally come across is drop down list of Server Lists on Connect dialog in SQL Server Management Studio. Here are two of the cases when I want to delete something from SSMS Connect Screen: 1) Incorrect server name typed 2) Server…
Read More
SQLAuthority News – Excellent Experience at TechEd India 2013 Bangalore and Pune – Photo Journey
TechEd is the premier event from Microsoft and it is always pleasure to be part of the TechEd. This year I attended my fifth TechEd and I had presented at this event 4th time in the row. Presenting at TechEd is fun as there is a totally different level of…
Read MoreSQL SERVER – Tricks for Row Offset and Paging in Various Versions of SQL Server
Paging is one of the most needed tasks when developers are developing applications. SQL Server has introduced various features of SQL Server 2000 to the latest version of SQL Server 2012. Here is the blog post which I wrote which demonstrates how SQL Server Row Offset and Paging works in…
Read MoreSQL SERVER – Weekly Series – Memory Lane – #024
Here is the list of selected articles of SQLAuthority.com across all these years. Instead of just listing all the articles I have selected a few of my most favorite articles and have listed them here with additional notes below it. Let me know which one of the following is your…
Read MoreSQLAuthority News – HP Project Moonshot Interchangeable and Interlockable Servers with Elastically Scale NuoDB
HP has recently released a new product called Project Moonshot. For anyone interested in databases, server systems, or cloud computing, the description of this new option was intriguing. On its most basic level, Project Moonshot is a scalable server system, available in small units that are easy to enlarge and…
Read More
SQL SERVER – Fix : Error: 217 Implicit conversion from data type datetime to int is not allowed.
Just a day before I was working on some query and faced this error. As soon as I receive this, I realized that what I had done wrong and what I needed to fix. The suggestion demonstrated in the error message is to the point and accurate. Let us learn how to fix error 217 for Implicit conversion.