This is a multi-part message in MIME format.

------_=_NextPart_001_01C17D44.B270A529
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

To run dts it should have administrative priviliges ..
Go to sql server - Security-logins- that user- properties-Server roles-
Tick Server Administrator.
And then give db_owner permissions for the account which you were using
to run dts.

I think in your case the problem is the path. Where you created the dts
? Is it that you created the dts in your enterprise manager and trying
to run it from sql server or through stored procedure.
Sql server tries to find the text file from the local machine where you
are running the dts.

I hope this will help.
Vani

-----Original Message-----
From: GREG ZIMMERMAN [mailto:gzimmerman@w...]
Sent: Tuesday, December 04, 2001 6:59 PM
To: sql language
Subject: [sql_language] Re: dts ftp task failure

I am having a permission problem with my DTS's.  I can get them to
execute but when it reaches the step to retrieve the text file I get the
error that it cannot find the path specified, Is this what you were
experiencing?  If so how did you fix?  Our network guy has no experience
in SQL and I have limited experience in networks so we are a little
stumped.
Thanks,
Greg

 -----Original Message-----
From: vani [mailto:vani@a...]
Sent: Tuesday, December 04, 2001 1:07 AM
To: sql language
Subject: [sql_language] Re: dts ftp task failure
Thanks nayeem,

 Your idea seems to pretty good. But I solved my problem, there was some
permission problem..
Thank you for your reply..

Regards,
Vani.


-----Original Message-----
From: nayeem [mailto:nayeem@g...]
Sent: Tuesday, December 04, 2001 12:14 PM
To: sql language
Subject: [sql_language] Re: dts ftp task failure

Hi,

 You can use DOS FTP Commands Using xp_cmdshell like ftp -s:filename.

so you should write the ftp commands in filename like

open websevername or IP Address
username
password
get textfilename
bye

and save the filename after writing the FTP Commands in it and execute
the SQL Procedure

EXEC [master].[dbo].[xp_cmdshell] "ftp -s:filename"

hope it will work for you.

Regards,
Nayeem.


----- Original Message -----
From: vani <mailto:vani@a...> 
To: sql <mailto:sql_language@p...>  language
Sent: Tuesday, December 04, 2001 8:03 AM
Subject: [sql_language] dts ftp task failure

Hello everybody,

  I am trying to run a dts package which consists of   DTS FTP TASK.
The job of this package is to get some text files from web server and
dumb them into sql servers temp folder.  Later I want to use this files
to populate my tables.

I created a stored procedure to run this.

My Stored procedure is

CREATE PROCEDURE ftpdts
AS

EXEC [master].[dbo].[xp_cmdshell] "dtsrun /S xxx.xxx.xxx.xxx /U xx /P
xxxxxx /N ftpdts"
GO

It is running fine from my query analyzer. But when I tried to run the
same stored procedure  from asp page it is showing error.
Error details
error '80040e09'
/ffp/admindata/ftpresult.asp, line 78
Any help will be greatly appreciated.
Thank you all
Regards,
Vani.


$subst('Email.Unsub')

$subst('Email.Unsub')

gzimmerman@w...
$subst('Email.Unsub')

$subst('Email.Unsub')