Viewing 15 posts - 91 through 105 (of 360 total)
thanks for the reply
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
July 11, 2012 at 12:28 pm
Thanks for the reply. But I have already installed the MAS90 driver. And already configured the DSN.
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
July 10, 2012 at 12:02 pm
Thanks Gail and Gullimeel
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
July 9, 2012 at 12:59 pm
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...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
June 18, 2012 at 12:18 pm
Thanks for the replies guys...it was really helpful...the move was smooth.
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
June 16, 2012 at 7:46 pm
Also, the old server is a SQL Server 2008 R2 and the new one has 2008 r2 Sp1
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
June 15, 2012 at 12:56 pm
anthony.green (6/13/2012)
whats the definition of the source table?
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...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
June 13, 2012 at 9:17 am
My Bad.
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
June 13, 2012 at 8:56 am
Anthony Looking at the DDL of the destination the ID column appears to be identity column.
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
June 13, 2012 at 8:55 am
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...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
June 13, 2012 at 8:52 am
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 =, !=, <, <= , >,...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
June 13, 2012 at 8:38 am
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...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
June 13, 2012 at 7:53 am
thadeushuck (6/12/2012)
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),
...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
June 12, 2012 at 3:55 pm
I think I figured it out. Thanks much for your help.
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
June 12, 2012 at 3:39 pm
thadeushuck (6/12/2012)
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...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
June 12, 2012 at 3:05 pm
Viewing 15 posts - 91 through 105 (of 360 total)