Importing text file fails

I try to import a tab separated text file into sql server 2005 using the import guide. But when running the job I get the error message

Error 0xc02020c5: Data Flow Task: Data conversion failed while converting column "Column 19" (67) to column "Column 19" (404). The conversion returned status value 2 and status text "The value could not be converted because of a potential loss of data.".
(SQL Server Import and Export Wizard)

The column 19 which reported a problem contains this information:
?searchroot=/_gen_/txt/&template=std.htm&use=prospect&intref=1_26067

However what is mysterious is that if I open the file in notepad or Excel and resave it again the job runs perfectly. This is not a way we could make it work later on since it's an automatic job that will run each night on a new text file.

The text file is sent from Norway to Sweden - and I use ANSI latin 1 when importing.

Please help someone!

BjrnWhat datatype you have on column 19 destination table?|||I use string [DT_STR] with a column width of 500

/Bjrn|||

Quote:

Originally Posted by gulllet

I use string [DT_STR] with a column width of 500

/Bjrn

...And I'm using the locale Swedish. Saving in Notepad or Excel is done in ANSI.

/Bjrn

Importing data from oracle 10g to SQL Server

Hi,

I created SQL Server package and schedule the job. SQL Server allows us to connected different database for e.g. for oracle using "Oracle Provide for OLD DB" to retrieve our database. A link is create between this database which move the data to SQL Server. I'm sure there is no issues in the link, as I'm using it to retrieve several oracle database which contains both Arabic and English data.

But after Importation it is showing Junk values. Please advise me what step I should take next.

Regards

Azeem

Did you already pump the data in a table ? Did you make sure the data table can hold unicode data (data types have to be of type NVARCHAR / NCHAR or a similiar data type supporting Unicode, look in the BOL concnering types which support storing unicode with the N at the beginning)

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

You may need to alter your collations on the SQL Server side for unicode fields to ensure that they are appropriate for the text you are storing. Books online has more information about collations and unicode data.

|||

Hi Azeem,

Would you be able to provide more information or a sample of what you mean under "junk values"? Also - the collation and the nchar/nvarchar ideas mentioned above are definitely required prerequisites in this case.

HTH,
Jivko Dobrev - MSFT
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Azeem Anzari wrote:

Hi,

I created SQL Server package and schedule the job. SQL Server allows us to connected different database for e.g. for oracle using "Oracle Provide for OLD DB" to retrieve our database. A link is create between this database which move the data to SQL Server. I'm sure there is no issues in the link, as I'm using it to retrieve several oracle database which contains both Arabic and English data.

But after Importation it is showing Junk values. Please advise me what step I should take next.

Regards

Azeem

You are getting character conversion you need to use Nvarchar for the Arabic column and use Arabic collation, you should also know Lam-Alef glyphs Arabic code pages does not exist in SQL Server you may need to use VS2005 to use Advanced save as option. Post again if you still need help.

http://msdn2.microsoft.com/en-us/library/ms144250.aspx

http://msdn2.microsoft.com/en-us/library/ms180175.aspx

Importing data from oracle 10g to SQL Server

Hi,

I created SQL Server package and schedule the job. SQL Server allows us to connected different database for e.g. for oracle using "Oracle Provide for OLD DB" to retrieve our database. A link is create between this database which move the data to SQL Server. I'm sure there is no issues in the link, as I'm using it to retrieve several oracle database which contains both Arabic and English data.

But after Importation it is showing Junk values. Please advise me what step I should take next.

Regards

Azeem

Did you already pump the data in a table ? Did you make sure the data table can hold unicode data (data types have to be of type NVARCHAR / NCHAR or a similiar data type supporting Unicode, look in the BOL concnering types which support storing unicode with the N at the beginning)

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

You may need to alter your collations on the SQL Server side for unicode fields to ensure that they are appropriate for the text you are storing. Books online has more information about collations and unicode data.

|||

Hi Azeem,

Would you be able to provide more information or a sample of what you mean under "junk values"? Also - the collation and the nchar/nvarchar ideas mentioned above are definitely required prerequisites in this case.

HTH,
Jivko Dobrev - MSFT
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Azeem Anzari wrote:

Hi,

I created SQL Server package and schedule the job. SQL Server allows us to connected different database for e.g. for oracle using "Oracle Provide for OLD DB" to retrieve our database. A link is create between this database which move the data to SQL Server. I'm sure there is no issues in the link, as I'm using it to retrieve several oracle database which contains both Arabic and English data.

But after Importation it is showing Junk values. Please advise me what step I should take next.

Regards

Azeem

You are getting character conversion you need to use Nvarchar for the Arabic column and use Arabic collation, you should also know Lam-Alef glyphs Arabic code pages does not exist in SQL Server you may need to use VS2005 to use Advanced save as option. Post again if you still need help.

http://msdn2.microsoft.com/en-us/library/ms144250.aspx

http://msdn2.microsoft.com/en-us/library/ms180175.aspx

Importing data from oracle 10g to SQL Server

Hi,

I created SQL Server package and schedule the job. SQL Server allows us to connected different database for e.g. for oracle using "Oracle Provide for OLD DB" to retrieve our database. A link is create between this database which move the data to SQL Server. I'm sure there is no issues in the link, as I'm using it to retrieve several oracle database which contains both Arabic and English data.

But after Importation it is showing Junk values. Please advise me what step I should take next.

Regards

Azeem

Did you already pump the data in a table ? Did you make sure the data table can hold unicode data (data types have to be of type NVARCHAR / NCHAR or a similiar data type supporting Unicode, look in the BOL concnering types which support storing unicode with the N at the beginning)

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

You may need to alter your collations on the SQL Server side for unicode fields to ensure that they are appropriate for the text you are storing. Books online has more information about collations and unicode data.

|||

Hi Azeem,

Would you be able to provide more information or a sample of what you mean under "junk values"? Also - the collation and the nchar/nvarchar ideas mentioned above are definitely required prerequisites in this case.

HTH,
Jivko Dobrev - MSFT
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Azeem Anzari wrote:

Hi,

I created SQL Server package and schedule the job. SQL Server allows us to connected different database for e.g. for oracle using "Oracle Provide for OLD DB" to retrieve our database. A link is create between this database which move the data to SQL Server. I'm sure there is no issues in the link, as I'm using it to retrieve several oracle database which contains both Arabic and English data.

But after Importation it is showing Junk values. Please advise me what step I should take next.

Regards

Azeem

You are getting character conversion you need to use Nvarchar for the Arabic column and use Arabic collation, you should also know Lam-Alef glyphs Arabic code pages does not exist in SQL Server you may need to use VS2005 to use Advanced save as option. Post again if you still need help.

http://msdn2.microsoft.com/en-us/library/ms144250.aspx

http://msdn2.microsoft.com/en-us/library/ms180175.aspx

Importing AS 2000 cube into SSAS 2005

Is there any way to import a cube created in AS 2000 into SSAA 2005? If not a direct import is there any way to make that job easier? Any suggestions/pointer/comments would be helpful.

I have a lot of AS 2000 cubes and I am really sick of that development environment!

You can use the Migration Wizard (search for MigrationWizard.exe in the SQL installation folder, or right click on the server node in SQL Management Studio and use 'Migrate ...'). The wizard requires AS2000 to be running and can generate a migration script (that can be later run on AS2005 with SQL Management Studio) or can migrate directly to AS2005.

You cannot restore AS2000 backup files (.cab) on AS2005.

Adrian Dumitrascu