Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Migrating from SQL server 2000 to 2005 Expand / Collapse
Author
Message
Posted Sunday, August 30, 2009 12:13 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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

Please help..

Thank you
archana



Post #779610
Posted Monday, August 31, 2009 1:42 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 6:20 AM
Points: 1,904, Visits: 2,823
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
Posted Monday, August 31, 2009 3:34 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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...

Any idea how this can be done????

Thank you
Archana
Post #779753
Posted Monday, August 31, 2009 4:07 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 6:20 AM
Points: 1,904, Visits: 2,823
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
Posted Monday, August 31, 2009 5:54 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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 »

Add to briefcase

Permissions Expand / Collapse