I am getting an error during export/import. My source and destination tables has "timestamp" datatype column.
Create table SourceTable (
Rowid numeric(10,0) identity,
Row_version timestamp null
create table DestTable (
Rowid Numeric(10,0) identity,
Row_version timestamp NULL
I get the following error:
Error 0xc0202048: Data Flow Task: Attempting insertion into the row version column "row_version". Cannot insert into a row version column.
(SQL Server Import and Export Wizard)
Thanks in advance
I tested the above scenario in BIDS 2008 against SQL Server 2005 Sp2. I was able to create an SSIS package using Import/Export wizard and excuted the package without any error message. I found my data has been copied too.
Table def (being same for source and dest.)
/****** Object: Table [dbo].[DestTable] Script Date: 04/20/2009 12:42:51 ******/
(10, 0) IDENTITY(1,1) NOT NULL,
How did you use the export/import wizard? as the name is spelled out as Row_version, I would not think it would conflict with the reserve word "rowversion"