Great find Ricky! Now I have one last question. I created my DTS package via enterprise manager and saved it as a "Meta Data Service Package." Now I go into the design view of the package, and the source location of the mdb file is still my local hard drive. When I try to change it to a folder I know exists on the server (and no my machine), it doesn't allow it. When I call the DTS package via CF, how will the DTS know to look for the access file on the web server's drive vs my desktop?
Do I have to have enterprise manager loaded on my web server and create the package from there in order for this to work? I know this is a little more off topic than CF, but your help is much appreciated. Thanks! -Kevin On Tue, 16 Nov 2004 11:46:34 -0600, Ricky Fritzsching <[EMAIL PROTECTED]> wrote: > Kevin: > > Try this link: > > http://www.pengoworks.com/index.cfm?action=articles:spExecuteDTS > > Ricky > > > > -----Original Message----- > From: Kevin Pechin [mailto:[EMAIL PROTECTED] > Sent: Tuesday, November 16, 2004 11:32 AM > To: CF-Talk > Subject: DTS Package From Cold Fusion > > Hello, > > I have an access db that I want to import into SQL Server 2000. > Normally I would just use enterprise manager to truncate the table and then > import the new database, but I would like to create an application to make > the end users self sufficient and allow them to upload an mdb file to the > web server which would then run a DTS package on a seperate database server. > > Can this be done, and if so does anyone have sample code? > > Thanks! > > -Kevin > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184419 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54