SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Migrating from SQL server 2000 to 2005


Migrating from SQL server 2000 to 2005

Author
Message
archan.arch
archan.arch
Valued Member
Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)

Group: General Forum Members
Points: 56 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 2005Hehe

Please help..

Thank you
archana
Henrico Bekker
Henrico Bekker
SSCertifiable
SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)

Group: General Forum Members
Points: 7278 Visits: 5012
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.

....

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
archan.arch
archan.arch
Valued Member
Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)

Group: General Forum Members
Points: 56 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
Henrico Bekker
Henrico Bekker
SSCertifiable
SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)

Group: General Forum Members
Points: 7278 Visits: 5012
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.

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
archan.arch
archan.arch
Valued Member
Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)

Group: General Forum Members
Points: 56 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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search