How to convert binary file to text file in ssis or in SQL server.

Question

How to convert binary file to text file in ssis or in SQL server.

$agar

SSC-Addicted

Points: 427
More actions
June 21, 2013 at 7:49 am

#276632

How to convert binary file to text file in ssis package and i want to load it into the table.

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

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

Eugene Elutin SSC Guru Points: 59322 More actions · Answer 1

What binary file?

_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help[/url]

$agar SSC-Addicted Points: 427 More actions · Answer 2

Any kind of binary data which have to convert into text type.

Eugene Elutin SSC Guru Points: 59322 More actions · Answer 3

You cannot convert "any kind" of binary file into text file.

Binary file may contain any type of data in any format.

_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help[/url]

sturner SSC-Insane Points: 22411 More actions · Answer 4

text (character) data can be stored in a binary (or varbinary) data column. If its valid ASCII or Unicode encoded text it can be "converted" to char or text using Cast or Convert.

If the data is actually binary (like a pdf or word doc or something like that) you will need to write a program to do it.

The probability of survival is inversely proportional to the angle of arrival.