Gurus I am at my wits end.
I cant find anything online to help resolve this error and its probably something so simple. Your help is greatly appreciated.
This is running from sql2005 and inserting into sql2008
The error I am receiving is
Insert Error: Column name or number of supplied values does not match table definition.
CREATE TABLE [M].[tablename](
[column1] [int] IDENTITY(1,1) NOT NULL,
[column2] [int] NULL,
[column3] [varchar](50) NULL,
[column4] [datetime] NULL,
[column5] [date] NOT NULL
) ON [PRIMARY]
--SET IDENTITY_INSERT server.[M].[tablename] ON
insert into opendatasource ('SQLNCLI',
'Data Source=REMOTESERVER;USER ID = User; PASSWORD=User')
VALUES ('column2', 'column3' ,GETDATE(),'column5')