Image database dyay import to MS-SQL

[wa8okr]

Hello All

I would like to know if it is possible to use SQL Server to directly import data from an HP image data base and not use the interum text file and format files to accomplish this.

I have available an ODBC package from MiniSoft that allows connections to the HP database.

If this is possible can it be done with DTS.
My plan is to move the data to a temporary SQL database for scrubbing and then to move it to a live database when the scrubbing is complete. I hope to use Stored procedures and avoid an interface program written in VFP6.0 or Vb6.0

Thank you

Bill WA80KR

 

[DougP]

If this is SQL server 7 or 2grand then yes both are extremely flexible.
As with any project you have to start somewhere. Then it’s a matter of figuring out workarounds for situations that come up.
First you must see if you can manually convert the data at all using the DTS and your ODBC driver. If it does work then save it. It can be called from a Stored Procedure later.
DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive

 

[wa8okr]

Thanks DougP

Do you have any suguestions as to some DTS information that would help me get started on the SQL 7.0 side? It seems that I will be working backwards to what I am used to since I want to try this processing from completely inside of SQL Server.

Thanks Bill