thanks for the reply

Thanks for the reply. But I have already installed the MAS90 driver. And already configured the DSN.

Thanks Gail and Gullimeel

Just tried it and it worked. Assuming you're using the gui, delete the log file that it automatically tries to create. Remove that, then attach just the .MDF and it...

Thanks for the replies guys...it was really helpful...the move was smooth.

Also, the old server is a SQL Server 2008 R2 and the new one has 2008 r2 Sp1

CREATE TABLE [dbo].[sourcetable](

[SiteID] [numeric](18, 0) NULL,

[SLXID] [varchar](50) NULL,

[PK90ID] [varchar](8000) NULL,

[ChannelID] [int] NULL,

[PlanCalls] [int] NULL,

[Monthly$] [money] NULL,

[OverageRate] [money] NULL,

[Activate] [varchar](50) NULL

) ON [PRIMARY]

GO

SET ANSI_PADDING...

My Bad.

Anthony Looking at the DDL of the destination the ID column appears to be identity column.

I am using an ssis package to do the insert. The query I am using is as below:

OLEDB Source with following code:

SELECT (SELECT

ROW_NUMBER() OVER(ORDER BY ID ) + 5 FROM...

Thanks for the reply Anthony. But I got the below error:

Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >,...

One of the columns has a type as unique identifier which accepst NULL values as well and I am using NULL as [columnname] to insert null as a hardcoded value...

thadeushuck (6/12/2012)

---

Something like this...

BEGIN TRY

INSERT INTO destinationTable

SELECT cast(substring(Column1,1,12) as nvarchar(12)),

cast(substring(Column2,1,10) as nvarchar(10)),

cast(Column3 as int),

...

I think I figured it out. Thanks much for your help.

thadeushuck (6/12/2012)

---

ETL = 3 steps.

1. Export to the target server. For this I would create your own copy of the source servers table structure and move records from source...