fileSystemObject - Question!

[KSiva]

Hello Gurus!

I have written a python script (a client GUI tool to access the SQL server database). When client uploads a file, it need to be created in server side. I used the below code (found on this site):

CREATE PROCEDURE [dbo].[sp_CreateTextFile]
@FileName varchar(100),
@FileContent varchar(8000)

AS
Declare @FSO int
Declare @TextFile int
Declare @hr int

EXEC @hr = sp_OACreate 'Scripting.FileSystemObject', @FSO OUT
EXEC @hr = sp_OAMethod @FSO, 'CreateTextFile', @FileName,NULL, @TextFile OUT
EXEC @hr = sp_OAMethod @TextFile, 'WriteLine', @fileContent, NULL
EXEC @hr = sp_OADestroy @FSO
GO

and it works fine, but creates the file in the client side. I am passsing the filename to be created and content of the file. Is that what supposed to be happen? I have been reading the filesystemObject doc and it reads that the file must be created in server side.

I am bit lost here ... Can any of you help me???

Thanks a lot! Sivakumar Kandaraj
System Administrator,Web Programmer
Melbourne
Australia.

 

[tlbroadbent]

Please see my reply in thread183-223938. Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

If you want to get the best answer for your question read faq183-874.