Viewing 3 posts - 1 through 3 (of 3 total)
Thanks Williams,
I figured out whats wrong. I have created the folder in my PC rather than the Server's C Drive. Once I created and ran the Stored Proc, it created...
November 13, 2007 at 6:32 pm
William,
I'm still getting the ourput as
OpenTextFile C:\SQLClasses\table1.cs
OpenTextFile C:\SQLClasses\table2.cs
.
.
.
.
OpenTextFile C:\SQLClasses\tableN.cs
EXECUTE @OLEResult = sp_OAMethod @FS, 'OpenTextFile', @FileID OUT, @FileName, 8, 1
IF @OLEResult <> 0 PRINT 'OpenTextFile ' + @FileName
I...
November 13, 2007 at 4:10 pm
I'm getting output as
(x row(s ) affected) - x is a number
OpenTextFile (a whole bunch of them)
And the C:\SQLClasses directory is empty.
Do I need to set any Permissions to...
November 13, 2007 at 3:49 pm
Viewing 3 posts - 1 through 3 (of 3 total)