Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>Francisco:
>
>I'm not sure I know what the DTS Package is - can you elaborate?
>
>At the time I run this program, all that is known about the incoming data is a source file name and some field names, not the type of field (char, numeric, integer, etc.) or the field length. In order to run SQLEXEC() to create a table in the SQL Server database, don't I have to know these things?
>
>Thanks!
>Tom.
The DTS is a function within SQL Server where you can configure Data Transformation services.
So you can configure that a source file (accessed by ODBC or OLE DB if it not native SQL Server Data) is going to be imported into some table into some Database in a SQL Server.
You can even define some transformations on each fieldfs if you want. These transformatuion can be configured by the wizard or can be written in VBScript.
You can choose to create the table if it doesn´t exists.
You can also configure it to run automatically periodically.
To do the import from within VFP, you must know the fields types and lengths in order to execute the transact SQL command (via SQLEXEC) to create the table.
You can do it with 'Afields()'
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement