Viewing 6 posts - 1 through 6 (of 6 total)
I just remembered something to tell you
before importing data from excel source into SQL server,change whole excel file as General format.
This was a real headache for me months before.But this...
February 4, 2010 at 5:25 am
First import data as varchar or nvarchar into Temp table
then convert and insert data into real table,
this should solve your problem.
February 4, 2010 at 5:22 am
i have found a solution for this,actually i found my mistake.
i changed the connection from oracle provider for ole db to microsoft oledb provider for oracle :w00t:
what a silly mistake...
February 1, 2010 at 6:28 am
surya-434952 (1/29/2010)
I guess u need change the column data type to text or ntext if your using sql server 2005 onwardsHope this will solve ur problem
Thanks,
Surya
I tried this with advanced...
January 29, 2010 at 4:33 am
Ratheesh.K.Nair (5/12/2009)
Use thisalter schema schema1 transfer schema2.table_name
this worked.
thanks a lot 🙂
May 12, 2009 at 1:57 am
Ryan Naude (1/14/2009)
Thanks, I will give that a try and see what happens.
So could you try it?
I use a similar system, get enourmous data from oracle to sqlserver.but IF SSIS...
January 23, 2009 at 2:37 am
Viewing 6 posts - 1 through 6 (of 6 total)