Import dbf file to SQL Server (from Delphi) with a DTS Package
hi
i'm using Delphi7 and SQL Server 2000
i have a DBF file and i want to import it into my SqlServer
i made a DTS Package in SQLServer to import data to it , but i dont know how can i use it(call it) in the delphi
i wanna have a page in delphi that i can import data to DataBase from that form
how can i do that?
i'm using Delphi7 and SQL Server 2000
i have a DBF file and i want to import it into my SqlServer
i made a DTS Package in SQLServer to import data to it , but i dont know how can i use it(call it) in the delphi
i wanna have a page in delphi that i can import data to DataBase from that form
how can i do that?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
https://www.experts-exchange.com/questions/20257966/How-to-execute-an-MS-SQL-Server-DTS-Package-from-within-Delphi.html
You say that you want to have a "page in delphi that i can import data to DataBase from that form". I would need to know more what you want that form to do. Do you want it to display records from your DBF file and allow them to be added to the SQL Server database when a button is clicked (one at a time)? Do you want to have it try to update all records from the DBF into the SQL Server when the button is clicked? It would help to know how you are handling identifying individual records, and if there are linked tables involved.
Let me know when you can give me some more info.