Null values in Text Qualifier Error Issue

Question

Post reply

Null values in Text Qualifier Error Issue

viresh29

Ten Centuries

Points: 1111
More actions
May 27, 2014 at 9:23 am

#285869

Hello Folks,
I am working on SSIS Packages. I have raw files in which data is in text qualifier.
When I am trying to load files into database it's throwing me error when there is no values in text qualifier.
For Example. "Others","0","0"," "," "
If I have the value above in raw files. SSIS Package throwing me error in " " this column. Saying
Data Conversion failed.
Any help on this will be really appreciated.
Thanks:-)
Viresh
--------------------------------------------------------------------------
“ The future belongs to those who are virile, to whom it is a pleasure to live, to create, to whet their intelligence on that of the others. ”
— Sir Henri Deterding

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 1

Can you post the exact error?

At which transformation do you get the error?

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

viresh29 Ten Centuries Points: 1111 More actions · Answer 2

I am getting error at flat file connection.

[FF_SRC - Raw Data File [27]] Error: Data conversion failed. The data conversion for column "Time-UTC-Sec" returned status value 2 and status text "The value could not be converted because of a potential loss of data.".

This above error I am getting.

Thanks:-)

Viresh
--------------------------------------------------------------------------
“ The future belongs to those who are virile, to whom it is a pleasure to live, to create, to whet their intelligence on that of the others. ”
— Sir Henri Deterding

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 3

What is the data type of that column? You can check this in the advanced editor of the source.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

viresh29 Ten Centuries Points: 1111 More actions · Answer 4

I found out the problem.

In my destination database that empty space in column is int. so SSIS can't take empty space in " " as int. thats why I was getting error. If I change that column to varchar then My package is working fine.

Thanks:-)

Viresh
--------------------------------------------------------------------------
“ The future belongs to those who are virile, to whom it is a pleasure to live, to create, to whet their intelligence on that of the others. ”
— Sir Henri Deterding

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 5

Glad you found a solution. Thanks for posting back.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP