How To Convert Hexadecimal File Formats?

May 19, 2000

Dear SQL folks,

We have files from an event log in a DEC Alpha server and we would like to create a database program to import these files and then be able to read and query the info in them.

These files contain information such as error codes about the machine that the Alpha controls. They also contain time stamps. I am told that these files are hexidecimal.

Someone mentioned in passing that if we use MSaccess as the database, we would first have to write a program to convert these files to a format that Access can understand.
But, we were told that SQL7 has Add-ins that comes on the CD that can convert these files to a format that SQL7 can then understand.

Does anyone know if this is true..and how difficult is file conversion to accomplish?

If anyone thinks that they might be able to help us, I can sent them a small sample of the hex files
Thank you in advance

View 1 Replies


ADVERTISEMENT

Convert Images To Hexadecimal

Jan 5, 2006

Hello guys,
Have any one tried to convert an image to a hexadecimal string, and saving it to sql server?
Thanks..

View 3 Replies View Related

How Can I Convert Decimal To Hexadecimal

Mar 14, 2006

Hi!!!!!


I'm looking for a SQL FUnction that convert a decimal to Hexadecimal and

Hexadecimal to decimal data.

I know the way to convert for. But not with a SQL Function. certainly I

need to know How to express an Exponential Function.


Thank's.

View 2 Replies View Related

Convert Or Cast HexaDecimal To Bigint

Aug 21, 2006

Hi ,

I have a hexadecimal string value. I want to convert it to Bigint in Sql Server 2005.

The Hexadecimal value is '0x000000000000000F'.

How is it possible to convert into Bigint.

Please help me

Thanks in advance

Srinivas





View 6 Replies View Related

Convert Hexadecimal Value To Real Data Type

Aug 29, 2006

Hi ,

I want to convert hexadecimal to numeric data type. Using directly Cast or Convert function is not working.

Please suggest an alternative how to retrieve the numeric value of binary data .

Thanks in advance

Regards

Srinivas Govada

View 1 Replies View Related

DTA Package Handling Multiple File Formats

Jul 23, 2005

Hi,Currently we get data from more then 200 different sources and all ofour vendors provide data in different file formats. The problem is wehave more then 100 DTS packages now and the maintainance is verydiffucult.Every time our vendor changes the format we have to change in multipleDTS packages.Is anybody know what would be the right way of reducing the no. of DTSpackages.The type of file formats we get are .xls .txt .dat .csv etc. and .txt& .dat files comes with different delimitters. The # of columns alsovaries from file to file. Is it possible to have a DTS package whichcan handle diff file formats and loads data into a staging table andfrom there based of the source of the file we can move data intorespective tables & columns.We are using SQL SERVER 2000Thanks in advance.Subodh

View 2 Replies View Related

Date Formats From OLE DB Source (SQL) To Flat File Destination

Oct 23, 2007



I am bring a date from a OLE DB Source (SQL Command) as [select cast(convert(varchar,getdate(),101) as varchar(10))] to a Flat File Destination (CSV File). The data in the source is show as "1/1/2007", which is how I need it to display in the file. The flat file defaults to showing the data as "1/1/2007 00:00:00." I did change the destination field to a String, and still, I geting the timestamp. I tried using a data conversion transformation, and I am getting bargage data when converting the date to a string.

Can any one give me insight on how to populate a date into a comma delimeted file as "1/1/2007", not "1/1/2007 00:00:00."


Thanks in advanced.

View 8 Replies View Related

Hexadecimal String

Nov 26, 2004

Hi,

I want to convert a UNIQUEIDENTIFIER to a VARCHAR, but I don't want to convert it to a varchar with this format: xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx; I want to convert it to a varchar representing my uniqueindentifier with a hexadecimal number 0xnnnnnnn...
Anybody knows if this is possible, or will I have to do it manipulating each character in the varchar

Thanks,

Federico

View 1 Replies View Related

Open Stored In Hexadecimal

Jul 20, 2005

How I can to open a encrypted stored procedure in Hexadecimal modewith Query Analyzer?Thanks

View 1 Replies View Related

Converting A Binary/hexadecimal To Varchar

Feb 25, 2004

How should I convert a binary/hexadecimal value to Varchar

Thanks in Advance,
Jake

View 1 Replies View Related

How To Convert SLQ Server Express Database File To SQL Compact Edition File?

May 29, 2007

Hi all,



I have a database name MyDatabase (SQL Server Express Dabase File). Is there anyway that I could convert it to SQL Server Compact Edition File?



By the way does anyone here got any problem with programming in SQL Server Compact Edition? It troubles me.



Thanks,

bombie

View 6 Replies View Related

How To Eliminate Hexadecimal 0x00 Padding From Character Field In DB

Jul 25, 2001

I am getting a data loaded in a DB table to a character field padded from the right with hexadecimal zeros 0x00. How to get rid of it?
Thank you.

View 3 Replies View Related

Execute Stored Procedure To Decode A Varchar Hexadecimal String

Nov 20, 2014

how to execute this stored procedure to decode a varchar hexadecimal string? My SQL syntax stills have faded with the sands of time... I want to do a select * from the users table and decode the Password field (but not update) in the process.

CREATE PROCEDURE spPasswordDecode (@hex varchar (100), @passwordtext varchar (100) output)
AS

declare @n int,
@len int,
@str nvarchar(500),
@output varchar(100)

[code]....

View 4 Replies View Related

Convert A Btrieve File To A Sql Server File

Jul 20, 2005

how can i convert a file from kind btrieve to a sql server 2000 file and usedthat files in sql server 2000thank you from your answer

View 1 Replies View Related

.NET Framework :: Convert BAK File In Server To CSV File

Aug 31, 2015

I need to write a code in asp.net to convert .bak file in sql server to .csv file...

View 6 Replies View Related

How To Convert XML File To XSL File Using XSLT

Jan 30, 2014

I need to convert an xml file that has an attribute(name). This xml file has to be converted using xsl into the XSLT file such that the tag should have the same structure along with it and its the tag-content also should be the value of the attribute.

<?xml version="1.0" encoding="utf-8"?>
<PatientUpdateRequest xmlns="http://medseek.com/ecoEnablement/Schemas">
<General>
<SendingApplication>SendingApplication1</SendingApplication>
<SendingFacility>SendingFacility1</SendingFacility>

[code].....

View 1 Replies View Related

Convert An Ascii File To Sql

Oct 7, 2005

All,  I have to automatically grap a dbf or ascii file from my hard drive and then insert that into an already existing database table.  Does anyone know how to do this? The only thing I can find is to do it manually from enterprise manager, but I need to automate this.Thanks in advance!

View 1 Replies View Related

DB Design :: Convert A Bak File

Aug 27, 2015

Is there a redgate tool or any third party tool that would convert a .bak file to its appropriate .mdf and .ldf file? or create an .mdf and .ldf file from the .bak file?

View 13 Replies View Related

Convert Dat Format File

Apr 23, 2008

The data file contains the answers given to questions asked during the course of an interview. This file contains data only for completed interviews. The file is ASCII based, and contains data in a card column format. This means that each record is spread over several rows in the file €“ called cards. Currently 39 cards make up one completed record, although this may change over time. There are 80 columns per row.





sample of data is as follows

record 1

0000301 108033135 ds880783 100325080327000451334779005133477900 1 001
000030251334779000 0 LISA E 002
0000303MCCARTHY est 11000000000000000000000000100 003
0000304DODGE GRCARA 2008 004
0000305Northgate Chrysler Dodge Jeep 005
00003068536 Colerain Ave Cincinnati 45251006
00003072914OHDEMOSS,MIKE 03-26-200811 007
00003081 1 120529101010 9 008
0000309 009
0000310 010
0000311 011
0000312 2 012
0000313 013
0000314 014
0000315120642 1 015
0000316 016
0000317 017
0000318 018
0000319 019
0000320 020
0000321 021
0000322 022
0000323 023
0000324 024
0000325 025
0000326 026
0000327 027
0000328 028
0000329 029
0000330 030
0000331 031
0000332 032
0000333 033
0000334 034
0000335 035
0000336 120557 036
00003373108629008110.000 North-gate Chrysler Dodge Jeep 037
0000338 1 3 038
0000339 039



Record 2


0000401 108033135 ds880609 300192080327000931868842133184587707 1 001
000040231868842131 0 MARK 002
0000403MURPHY cst 10010000000000000000000000100 003
0000404DODGE 2005 004
0000405Hebert's Town and Country Dodge Chrysle 005
00004061155 E Bert Kouns Shreveport 71105006
00004075628LA436 03-25-200811 007
00004083 1 120608 008
0000409 090909 009
0000410 4 010
0000411 011
0000412 2 012
0000413 013
0000414 014
0000415120759 1 015
0000416 016
0000417 017
0000418 018
0000419 019
0000420 020
0000421 021
0000422 022
0000423 023
0000424 024
0000425 025
0000426 026
0000427 027
0000428 028
0000429 029
0000430 030
0000431 031
0000432 032
0000433 033
0000434 034
0000435 035
0000436 120642 036
000043731086290081 09.000A-Bears Town and Country Chrysler Jeep 037
0000438 1 3 038
0000439 039


i need to convert this into a coma delimtited file ,file and i am failing whats need to be done to achieve it

its quite a new concept for me

please advise






View 4 Replies View Related

How To Convert .btr File In SQL OR ACCESS

Apr 28, 2008

how To Convert .btr file in SQL OR ACCESS
please help me
tanks

View 4 Replies View Related

DDL File To Convert From MySQL To SQLServerXXX

Aug 4, 2006

We want to migrate a mySQL database to sql server 2000 or sql Server 2005. I have been given a DDL file to perform the conversion, but I don't know what to do with the file? Can anyone help me out? From what I can conclude, the DDL files is a script. So how do I run this script? Where do I place the file, before I run it?
Please help !

View 2 Replies View Related

Convert Text File Format

Mar 30, 2007

Hi,
How can I convert a text file (.txt) into SQL in ASP.net 2.0 ?  The sample of the file format is like that ...
    09/03/2007 08:41 "Fung, Kitty" Granted Access D1 Main 2354 111
    09/03/2007 08:42 "Ng, Jaclyn" Granted Access D1 Main 21906 18
    09/03/2007 08:42 "Leung, Agnes" Granted Access D1 Main 21920 18
Cheers
 

View 2 Replies View Related

SQL Server 2005 - Convert .BAK File To .MDF

Mar 27, 2008

Hello There,
I would really appreciate if you can help me with this problem. I am currently using SQL Server 2005 Express for one of my web application. I have a .bak file (backup file) provided by my client which I want to use for testing purpose. Now I just want to know how can I use that backup file without installing SQL SERVER 2005 as one way to do this I know is to restore the database in SQL Server 2005 Enterprise Manager but I can't install SQL Server 2005.
To my knowledge, SQL Server Express uses .mdf file for database but what I have is .BAK file..
I would be really glad to see your quick answers.
Thank you for reading this far.
Sincerely,
Zulfiqar

View 2 Replies View Related

Convert Flat File To SQL 2000

Oct 14, 2003

I have a table in a flat file that I need to convert to SQL Server 2000. Within this file are 4 different record definitions (all are similar but with different lengths).

I have experience converting files that are of 2 different record definitions, but never with this many. What kind of data migration techniques are available for such a process? I need to be able to get these 4 different definitions into 4 different tables.

It is coming from a COBOL program in UNIX.

Any help would be greatly appreciated.

View 2 Replies View Related

Sage .DTA File - How Can I Convert/View It ?

Jan 26, 2007

Hello, not sure if this is in the right forum or not...

I have a .DTA file from Sage which is a Database file, im assuming anyway, how can i convert it into a format where i can view it in say access or excel, something like that, or anything really just so i can read it all properly... i can read it in word - buts of it but its all mangled and awful...

Thanks

View 14 Replies View Related

Convert A Boolean Yes/No From Flat File To A Bit

Feb 19, 2008

I have a flat file that has data stored as Yes / No I need to convert it to True / False for my bit data type on my sql table. When I do the data conversion it fails. When I set it to ignore all the values are null. This is a nightly import into SQL is there an inline method to do all the conversions within SSIS?

View 4 Replies View Related

How To Convert SQL Server Table To CSV File Format?

May 30, 2008

 i have 12 different sql server tables. all are binded to one gridview. i have kept one admin user to view the details of the 12 tables in a gridview (pagesize=5). now the admin wants to generate 12 CSV files from the 12 tables (that is, he has to choose the table name from a dropdown and then has to click "Generate" button. CSV file name should be like this "<table_name>_<date>" ). also want to put links(dynamically [after generation of those csv files]) in a separate page to download those csv files. how to do this in asp.net (C#)? its urgent.

View 1 Replies View Related

Convert Or Transfer Access Mdb File To Sql Server

Oct 11, 2007

what's the easiest way to do this. i have 5 tables within the mdb filei tried the "easiest way" shown in a website but it does not work.the way i did it was on access(2007) > database tools tab > sql server buttonit gave me an error when it ask for an login IDi do not have any password/id..please helpthanks

View 3 Replies View Related

How Do I Convert Data From CSV File To Database In SQL Server 2000 ?

Oct 24, 2006

Hi,How could i do to convert data from CSV files to tables on database in SQL server 2000 ? Please show me !Thank very muchdvl_lang 

View 3 Replies View Related

Convert From .sdf File To .mdb File

Jul 15, 2007

Hellow



I have an application that builds a .sdf Sqlq Server Compact Edition file I want to view the file on a desktop computer How can I do it ??

If there is no simple way to do this how can I write a C# application to convert the .sdf file to .mdb file so I will be able to use Microsoft Access to view it.



Thanks

Ofer

View 3 Replies View Related

Date Formats...UK

Oct 9, 2001

My SQL 7.0 database is set to show UK format date ranges. But when opening a table and adding criteria to the grid pane I having to put the US format date to retrive correct results...

Is this correct. I am wanting to be aboe to enter UK format in the criteria

Thanks...Scott

View 2 Replies View Related

Date Formats In SQL 7

Jan 23, 2001

Hi,

I am creating a VB application that will run on a NT machine with Regional Settings as UK English and dd/mm/yyyy settings. When I try to input these values into SQL 7.0 ( default database setting mdy and us_english with Regional Settings as UK dd/mm/yyyy) , I get the error -" The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value " .
Can I change my databse to always be dmy format. It seems to be active for a connection , can it be configured somewhere .

Any help will be greatly appreciated !

Regards

Anand

View 3 Replies View Related

Changing Formats

Apr 25, 2007

Hey guys,
I have a file that has date formatted like so: 2006-11-16 20:12:00
I would like the dateformat to be like mm/dd/yyy hh:mm

The file is being pulled into a varchar field..... as 2006-11-16 20:12:00
when I do a conversion i can only get it to mon 11,2006


any suggestions

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved