FileSystemObject: Permission denied?

Hi,
I got the err below, nevertheless my folders have full permissions for all.
Permission denied
/vilmar/ASP_JavaScript_CSS_HTML/ajudas_asp_completos/novo_asp/novo_asp_4-12-
03/Objeto_FileSystemObject.asp, line 17
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set Arquivo = objFSO.CreateTextFile("c:\Texto_teste.txt", True)
Arquivo.WriteLine("Isto é um texto." & vbcrlf & "Outra linha do texto e " &
vbcrlf & "...outra linha do texto.")
Arquivo.Close
Set Arquivo = objFSO.GetFile("c:\Texto_teste.txt")
Arquivo.Move "D:\Testes_Apostilas" ' »»line 17
Thanks,
««««««««»»»»»»»»»»»»»»
Vlmar Brazão de Oliveira
Desenvolvimento Web
HI-TEC"news.microsoft.com" <suporte@.hitecnet.com.br> wrote in message
news:eoiz6cNwDHA.2452@.tk2msftngp13.phx.gbl...
> Hi,
> I got the err below, nevertheless my folders have full permissions for
all.
> Permission denied
>
/vilmar/ASP_JavaScript_CSS_HTML/ajudas_asp_completos/novo_asp/novo_asp_4-12-
> 03/Objeto_FileSystemObject.asp, line 17
> Set objFSO = CreateObject("Scripting.FileSystemObject")
> Set Arquivo = objFSO.CreateTextFile("c:\Texto_teste.txt", True)
> Arquivo.WriteLine("Isto é um texto." & vbcrlf & "Outra linha do texto e "
&
> vbcrlf & "...outra linha do texto.")
> Arquivo.Close
> Set Arquivo = objFSO.GetFile("c:\Texto_teste.txt")
> Arquivo.Move "D:\Testes_Apostilas" ' »»line 17
Your folders may have full permissions -- however, does the NTFS level have
adequate permissions for whatever process is running your asp script?
Stevesql

Fileshare Data Driven subscription - Setting up report manager fil

I am trying set up a data driven subscription that will render reports as
PDFs to specific folders in Report Manager. I have setup a fileshare to which
I am pushing reports, but I am having trouble relating specific Report
Manager folders to the fileshares and there is little documentation about
this. Is there a simple way to push PDFs to Report Manager folders via
fileshare subscriptions?
Also, on a data driven subscription, I am setting up the table that will
read the specifications for the data driven subscription. How do a refer to
the PDF rendering method in the table - as "PDF" or " Adobe (PDF) file" or
something else? Also, what is the bit I should use to increment the file if
it already exists? The documentation on data driven subsciptions is really
not adequate to answer these questions.Incidentally, this question relates to Reporting Services 2005
"Mark" wrote:
> I am trying set up a data driven subscription that will render reports as
> PDFs to specific folders in Report Manager. I have setup a fileshare to which
> I am pushing reports, but I am having trouble relating specific Report
> Manager folders to the fileshares and there is little documentation about
> this. Is there a simple way to push PDFs to Report Manager folders via
> fileshare subscriptions?
> Also, on a data driven subscription, I am setting up the table that will
> read the specifications for the data driven subscription. How do a refer to
> the PDF rendering method in the table - as "PDF" or " Adobe (PDF) file" or
> something else? Also, what is the bit I should use to increment the file if
> it already exists? The documentation on data driven subsciptions is really
> not adequate to answer these questions.
>|||Hi Mark,
Not sure I understand third question, but you must provide a different
FileName paramter to the DDS for each report. Whatever logic you want.
Answer to second question is: PDF
As to the first question - I don't think that is possible. DDS can
output to fileshares, but the folders and files in those folders in RM
are controlledby the RS catalog and not accessible outside RM.
As a quick test, I uploaded a PDF file using RM and then searched the
RS Server for the pdf and it was not found. (So RS must be storing it
away somewhere on the server in a secured spot).
Are you sure you really want to do that anyway? The folders may get a
little crowded if you start storing PDF's there. You can, as another
option, store data with the report by using Snapshots.
If you do find a solution for stroing PDF's though, please post it!!
As a workaround, maybe|||Matt - Regarding your last comment, can I arrange the snapshots for the
reports into different folders? My understanding is that you can create a new
snapshot under the history tab for each report, but you cannot move the
history "snapshots" to other folders. Or can you?
"Matt" wrote:
> Hi Mark,
> Not sure I understand third question, but you must provide a different
> FileName paramter to the DDS for each report. Whatever logic you want.
>
> Answer to second question is: PDF
> As to the first question - I don't think that is possible. DDS can
> output to fileshares, but the folders and files in those folders in RM
> are controlledby the RS catalog and not accessible outside RM.
> As a quick test, I uploaded a PDF file using RM and then searched the
> RS Server for the pdf and it was not found. (So RS must be storing it
> away somewhere on the server in a secured spot).
> Are you sure you really want to do that anyway? The folders may get a
> little crowded if you start storing PDF's there. You can, as another
> option, store data with the report by using Snapshots.
> If you do find a solution for stroing PDF's though, please post it!!
> As a workaround, maybe
>

Files in SQL 2005

Hello,
In my ASP.NET 2.0 web site I need to upload many files to various
folders and add the information in an SQL 2005 database.
I am creating a documents table which includes the fields:
[DocumentId], [DocumentAuthor] and [DocumentUrl]
This table will have records for many files.
Is there a standard way to name the files?
Maybe renaming the files to "doc" + DocumentId?
However my DocumentId is a Guid so it would be to big ... I think.
I would need to create the record, get the DocumentId and then access
the record again to add the DocumentUrl after renaming the file in
my .NET code.
Anyway, is there a standard way to make sure that every file name is
unique and that at the same time won't have an unreadable name?
Thanks,
MiguelOn Feb 14, 4:05 pm, "shapper" <mdmo...@.gmail.com> wrote:
> Hello,
> In my ASP.NET 2.0 web site I need to upload many files to various
> folders and add the information in an SQL 2005 database.
> I am creating a documents table which includes the fields:
> [DocumentId], [DocumentAuthor] and [DocumentUrl]
> This table will have records for many files.
> Is there a standard way to name the files?
> Maybe renaming the files to "doc" + DocumentId?
> However my DocumentId is a Guid so it would be to big ... I think.
> I would need to create the record, get the DocumentId and then access
> the record again to add the DocumentUrl after renaming the file in
> my .NET code.
> Anyway, is there a standard way to make sure that every file name is
> unique and that at the same time won't have an unreadable name?
> Thanks,
> Miguel
one possible solution make DocumentId as identity and store document
as documentid value

File System and MSDB folders gone

This is terrible thing to happed at 4:30 pm on Friday!

I was working yesterday on some of deployment packages using file system (by the way, my msdb can not expand )

and just an hour ago I wanted to try some parent child deployment using file system.

but,

The only two folders I see in Integration services are Running Packages and Stored Packages. Nothing under those ones...

I have checked default location for File System (C:\Program Files\Microsoft SQL Server\90\DTS\Packages) and there are three packages there but these do not show in IServices.

And another question, if I execute package by double clicking on .dstx file should that make it show under File System?

thanks

Have you talked to the DBA? Sounds like access permissions, to me.|||

Hi Ljiljana,

1) Answer to Phils question - Yes ? goto (2). No ? Contact your Admin for the Privilleges mentioned by Phil.

2) Open the Services window, Restart your Integration Service Instance. Successful ? goto (3), No ? Check if the Service account has necessary privileges.

3) Log into your SSMS using your Integration Services Instance, You might see List of Packages in your Folder - Yes ? End of the Step, No ? goto 4)

4) Are you running Integration Services in a Cluster Environment (Note that IS is not cluster aware). Yes? Configure your Integration Services as described here.

Reply, if you are still having issues

Thanks

Subhash Subramanyam

|||

Hi and thanks all!

Subhash, direction you gave me with msDTSsrvr.ini.xml helped.

This is an article I came across before when I wanted to resolve issue with msdb not being able to expand.

I wanted to add that my previous question was no so clear as I was able to see File System and MSDB (not expandable) and the Friday afternoon they disappeared.

Now that I think about what I have done was following;

I copied piece of code under Configuration File for a Named Instance of SQL Server from http://msdn2.microsoft.com/en-us/library/ms137789.aspx and added my server info. However, this has not changed anything for me as I forgot to restart SSIS.

Then on Friday mid day I shut down my PC and that is when that file kicked in creating more issues for me.

So I asked my coworker to send me his file and, except for server name where I had my info he had dot (.) the only other difference was following code (two last lines from the above link)

<?xml version="1.0" encoding="utf-8"?>
<DtsServiceConfiguration xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

So I took these lines out, left my server info, restarted SSIS and it worked. All of it, including MSDB which I can expand now.

made me happy...

|||

Sorry, I do not know why part of the post is this bold and large; I was not yelling