Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
Hi All,
I have a dtspackage call download. It copy the data from a given table into an excel file. I am trying to run the same package for various databases in the same sql server. For example my server datawarehouse has 20 different databases. (i.e Meet1...Meet20). In each of the databases there is a table call dwnLoad. I need to be able run the dtsPackage from vfp for various databases depending on what option is selected by the users. Thus the same dtspackage need to run for database Meet1 or Meet2, etc. I do not know how to create a dynmaic ole db connection. Can someone point me to right directions.
Thanks
ZA
Suivant
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