You may see the above error if you are using the SQL server Destination in your SSIS package. Sql server Destination cannot be used in packages that access a SQL Server database on a remote server. Instead use the OLEDB destination. Things to note for SQL Server Destination a. It offers the same speed as [...]
Jan
17
2010
17
2010
Sep
8
2009
8
2009
Problem with SQL Server numeric data : Error converting data type varchar to numeric.
Today I stuck with an interesting problem of converting number data in Varchar fields to numeric datatypes. I have created the following sample data The data in the table contains Decimal and scientific values in varchar format as shown in the figure below. Now when I tried to convert the above values to numeric as [...]
Jun
22
2009
22
2009
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value
The Error Occurs when the input is date and the given day values are not in the range of the expected days for a given month(1-31) For eg. You cannot specify the date parameter as Feb 31 2009 since february only has 28 days in a non-Leap year and it throws the above error.
Apr
6
2009
6
2009
Null value is eliminated by an aggregate or other SET operation
The Problem occurs when an aggregate function(max,sum,avg..) exists on null values. Trying to get rid of the null values may be the solution but in certain cases..you may need the extra data relying on the null values. So whats the solution? Append set ANSI_WARNINGS OFF on the beginning of the sql statement. When using the [...]
Feb
24
2009
24
2009
“Set identity_insert on” errors for more than one table
I was trying to remove the Identity inserts for 4 tables all at once but I keeping getting errors like Cannot remove the Identity insert on table 2 as the table1 already has identity insert on. So after digging into the MSDN I was surprised to see the following lines “At any time, only one [...]
