Package executes as expected inside designer, but not from DTSRunU

#1

[SQL2000 Windows 2003 ]
I have a package that exports a bunch of data files. For some reason, while
I am in the DTS Designer, the package executes correctly - in that it creates
files in the specified directory. However, if I run the same package from
DTSRunUI, it appears to run fine, but the files are never created in the
directory.

I am at wits end as to why this is? The DTS Designer is running frm the
same machine that is running DTSRunUI and this is the sql server that has the
package stored on it, so I don't think this is a security thing.

Any ideas?

Brandon

#2

If you are actually sat at the same machine, the server itself, to test all
this, it doesn't make a lot of sense. Try turning on all the logging options
and compare the logs.

--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

"Brandon Lilly" <avarice (AT) nospam_swbell (DOT) net> wrote

Quote:

[SQL2000 Windows 2003 ]
I have a package that exports a bunch of data files. For some reason,
while
I am in the DTS Designer, the package executes correctly - in that it
creates
files in the specified directory. However, if I run the same package from
DTSRunUI, it appears to run fine, but the files are never created in the
directory.

I am at wits end as to why this is? The DTS Designer is running frm the
same machine that is running DTSRunUI and this is the sql server that has
the
package stored on it, so I don't think this is a security thing.

Any ideas?

Brandon

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

Package executes as expected inside designer, but not from DTSRunU

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Package executes as expected inside designer, but not from DTSRunU - 10-03-2005 , 03:56 PM

Re: Package executes as expected inside designer, but not from DTSRunU - 10-04-2005 , 07:03 AM