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 are missing or not registered...files not registered

Hello,
I am having a problem connecting to SQL server 2000 through enterprise manager. Whenever i try to look at a table, view or DTS package I get the message...

"The query cannot be executed because some files are either missing or not registered. Run setup again to make sure the required files are registered."

I have tried to re-register, unregister and re-register.

I have tried to create a new instance of SQL server and attach the Data files to this.

I have tried to Re-install client tools.

The only option I am left with is totally removing SQL server and re-installing then restoring the Databases from a backup tape...
I just wanted to know if anyone has anyother ideas before i go ahead and do this.
Thanks in advance.

JF

One more thing...
I can access all of the tables through access and excel and other data analyzers as I normally would.hi
have you tried checking the error on microsoft tech net, they dont always mean what they say. have had lot of success in the past

all the best

Originally posted by josef fukano
Hello,
I am having a problem connecting to SQL server 2000 through enterprise manager. Whenever i try to look at a table, view or DTS package I get the message...

"The query cannot be executed because some files are either missing or not registered. Run setup again to make sure the required files are registered."

I have tried to re-register, unregister and re-register.

I have tried to create a new instance of SQL server and attach the Data files to this.

I have tried to Re-install client tools.

The only option I am left with is totally removing SQL server and re-installing then restoring the Databases from a backup tape...
I just wanted to know if anyone has anyother ideas before i go ahead and do this.
Thanks in advance.

JF

One more thing...
I can access all of the tables through access and excel and other data analyzers as I normally would.|||Originally posted by kpaynter
hi
have you tried checking the error on microsoft tech net, they dont always mean what they say. have had lot of success in the past

all the best

kpaynter

I found this article on microsoft tech net...

http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b315868

On it has commands to be ran in command promt.
It did the trick, thank you very much for your reply...
You saved my 3 day weekend!!!!
Thanks again,
JF

File Metadata and the Foreach Loop Container

Hello,

I want to set up a Foreach loop container to loop through several flat files. I have a connection manager set up for individual flat files. The metadata for the files is all the same. They are fixed width files, and contain sixty five columns.

I didn't see a place in the container properties to configure the metadata of the files. How can a Foreach Loop Container 'know' the metadata of the flat files that I want to loop through?

Thank you for your help!

cdun2

If you are going to iterate through a number of files, you need t use a ForEach loop container that uses file enumerator . Then you need to create a single data flow with a single Flat file connection manager (using an expre ssion in the connection manager will do the trick of changing the name of the file on each iteration).

The metadata of the file has nothing to do with the ForEach loop container (It is defined in the connection manager though).

|||

cdun2, Jamie Thomson has some great examples of SSIS on his blogs page. This one refers to enumerating files using a ForEach Loop container (not quite exactly what you are attempting to do, but gives you an Idea of how to use the foreach container.

http://blogs.conchango.com/jamiethomson/archive/2005/05/30/1489.aspx

Can you outline your process? If you are going to do processing on each flat file, you probably want the processing within the ForEach loop.

|||

Actually, here is another example:

http://www.sqlis.com/55.aspx

|||

Thank you for your input! I'll see if I can run with the resources you have provided here.

cdun2

|||

Another approach is to use a multi flatfile connection.

To use that you need to create a connection string with all the filenames concatenated with a "|" (pipe). You just use it as if you are loading a single flatfile into a table. It also lets you add the filename as a column so that you know what file a particular row is coming from.

Check it out.

|||

I tried to implement this by following SSIS Tutorial Lesson 2 and the pkg only processed the last file in the list. From one I can tell from the project log, it didn't even loop through the other files, though it did process the last file by inserting its rows into the table, as expected.

Any ideas on why this would be happening? It seems like such a simple example... Thanks.

File Metadata and the Foreach Loop Container

Hello,

I want to set up a Foreach loop container to loop through several flat files. I have a connection manager set up for individual flat files. The metadata for the files is all the same. They are fixed width files, and contain sixty five columns.

I didn't see a place in the container properties to configure the metadata of the files. How can a Foreach Loop Container 'know' the metadata of the flat files that I want to loop through?

Thank you for your help!

cdun2

If you are going to iterate through a number of files, you need t use a ForEach loop container that uses file enumerator . Then you need to create a single data flow with a single Flat file connection manager (using an expre ssion in the connection manager will do the trick of changing the name of the file on each iteration).

The metadata of the file has nothing to do with the ForEach loop container (It is defined in the connection manager though).

|||

cdun2, Jamie Thomson has some great examples of SSIS on his blogs page. This one refers to enumerating files using a ForEach Loop container (not quite exactly what you are attempting to do, but gives you an Idea of how to use the foreach container.

http://blogs.conchango.com/jamiethomson/archive/2005/05/30/1489.aspx

Can you outline your process? If you are going to do processing on each flat file, you probably want the processing within the ForEach loop.

|||

Actually, here is another example:

http://www.sqlis.com/55.aspx

|||

Thank you for your input! I'll see if I can run with the resources you have provided here.

cdun2

|||

Another approach is to use a multi flatfile connection.

To use that you need to create a connection string with all the filenames concatenated with a "|" (pipe). You just use it as if you are loading a single flatfile into a table. It also lets you add the filename as a column so that you know what file a particular row is coming from.

Check it out.

|||

I tried to implement this by following SSIS Tutorial Lesson 2 and the pkg only processed the last file in the list. From one I can tell from the project log, it didn't even loop through the other files, though it did process the last file by inserting its rows into the table, as expected.

Any ideas on why this would be happening? It seems like such a simple example... Thanks.