Migrating from SQL server 2000 to 2005

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Brian Knight » Migrating from SQL server 2000 to 2005

Migrating from SQL server 2000 to 2005

Rate Topic

Display Mode

Topic Options

Author

Message

archan.arch

Posted Sunday, August 30, 2009 12:13 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, November 11, 2009 2:16 AM
Points: 6, Visits: 39

Hi all,

Need help in upgradation from SQL Server 2000 to 2005.

I have migrated the DTS packages to SSIS.
My package loads from flat files (data files) to my database.
I am using BULK-INSERT statement.
I am using non-html format files for blk insert
My inp data contains spl characters
Looks something like this
12,180.oo
1,290.0

My destination table has been defined as "float"

I am facing the folowing error:Bulk load data conversion error (type mismatch or invalid character for the specified codepage)

Cannot change the datatype to varachar.

There is no problem while loading in 2000 with the same data and destination as float. But facing the error in 2005 Hehe

Please help..

Thank you
archana

Post #779610

Henrico Bekker

Posted Monday, August 31, 2009 1:42 AM

SSCommitted

Group: General Forum Members
Last Login: Monday, June 10, 2013 11:15 PM
Points: 1,878, Visits: 2,704

Hi

Try inserting a conversion step in you package. Doesnt sound like you are using float data as the source?
With flat Files, you can also specify the conversion in the import (destination page) step.

....

----------------------------------------------
Msg 8134, Level 16, State 1, Line 1
Divide by zero error encountered.

Post #779728

archan.arch

Posted Monday, August 31, 2009 3:34 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, November 11, 2009 2:16 AM
Points: 6, Visits: 39

hi

Thanks for the reply...
But can you suggest any changes which can be done without adding conversion stage.
Can't change the design... Sad

Any idea how this can be done????

Thank you
Archana

Post #779753

Henrico Bekker

Posted Monday, August 31, 2009 4:07 AM

SSCommitted

Group: General Forum Members
Last Login: Monday, June 10, 2013 11:15 PM
Points: 1,878, Visits: 2,704

Hi, the flat file source you are using, is it a normal text file,or perhaps csv?

Rerun your job and look for a column name that is giving the issue.
I know you will have issues dumping txt to float as well. i.e. string type characters.

I had a similar issue once, but resolved it by changing the source data, and the output column format from float to nvarchar.

Awaiting your reply.

----------------------------------------------
Msg 8134, Level 16, State 1, Line 1
Divide by zero error encountered.

Post #779768

archan.arch

Posted Monday, August 31, 2009 5:54 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, November 11, 2009 2:16 AM
Points: 6, Visits: 39

hi..

Mine is a tab delimted file.
Yep We can do by changing the source data or by changing the column ' s datatype.
I have tried this but i dont have the liberty changing either of them.

Any other option would be helpful

Thank you
Archana

Post #779814

« Prev Topic | Next Topic »

Permissions