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