dbTalk Databases Forums  

Import binary flat file

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Import binary flat file in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
David Compton
 
Posts: n/a

Default Import binary flat file - 02-05-2004 , 09:10 AM






Hi all,

I have a number of binary flat file databases (fixed size records containing
strings, integers, dates, etc.) that are used in VB apps using type
structures, get, put, etc.

Does anyone know if it's possible to import these into a SQL table using DTS
?
If it involves writing my own drivers, do you know of a link to any examples
on the net ?

It's a pain exporting the data to a CSV file in VB because as there's no
eval() command you can't dynamically choose an existing type structure into
which the record can be loaded, forcing you to recompile the app for each
database. I guess it's time I learnt C#...

Any help would be greatly appreciated.

Dave Compton.
Autoclimate Ltd.



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.