Unable to schedule DTS

#1

Unable to schedule DTS for picking up file in shared drive. It creates
table but fails to copy. But if run in em it will execute fine (sql
server 2000)

#2

what task are you using in your dts to copy file to table ?

#3

I'm copying data from access db to sql server 2000.
rshivara... (AT) gmail (DOT) com wrote:

Quote:

what task are you using in your dts to copy file to table ?

#4

are you logging your dts, so you know where it fails
what task are you using to copy ? transfer data task ?
what is the error message ?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Unable to schedule DTS

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

Unable to schedule DTS - 06-07-2007 , 05:55 AM

Re: Unable to schedule DTS - 06-07-2007 , 07:02 AM

Re: Unable to schedule DTS - 06-12-2007 , 06:54 AM

Re: Unable to schedule DTS - 06-12-2007 , 08:04 AM