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 the Bulk [...]
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 below it [...]
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.
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 same in SSIS [...]
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 table in [...]
My Twitter Feed
