.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Post New Web Links

Subscription file share with UNC name spaces

Posted By:      Posted Date: October 20, 2010    Points: 0   Category :Sql Server


I need to save a subscription file share on this location:

\\Freja\Program Files (x86)\Logica\eBS-Connect\outbox

My problem is that I do not know how to write the path in UNC when there is spaces in the path.

Can anyone please help me?

BR Rasmus

View Complete Post

More Related Resource Links

using SSRS Windows File Share subscription to send file to sharepoint

Hello, I'm looking for the simplest way to automate sending SSRS reports to a Sharepoint document directory.  I know a document library is not a real directory but I am able to run copy scripts into one using the virtual path thats shown when I do Actions-> Open in Windows Explorer. However when I set up a subscription to send a report to this directory, I get an error: Failure writing file \\intranet\projects\docs\test.pdf : The network name cannot be found.  Just checking if anyone knows if this should be able to work or not. Thanks

About Windows file share delivery for a data-driven subscription



In order to try the data-driven subscription with the windows file share delivery, on my machine I have created a folder and then I have shared it adding my Windows account with full-control. The UNC of my shared folder is like \\mymachine\mysharedfolder.

When the subscription starts I can see in the report server service log an error about the access to the shared folder on account or password isn't valid.

Now, how can I solve this issue, please? Do I change some settings in the config files of the report server? Many thanks

SSRS Subscription - How to remove 'Windows File Share' delivery option?


A SSRS subscription has two delivery options (Windows File Share and Email).  We would like to limit users to only Email delivery, to avoid windows password expiration on the File Share.

Is there a way to remove Windows File Share as an Delivery option, so Email is the only option?






Migrate documents from File share to Sharepoint Services 3.0

Hi, everyone! One company is planning to migrate from File share, where they are storing all company documents, to sharepoint services 3.0, and begin to use document versioning, is it possible to migrate mass of documents to sharepoint services 3.0 ? Now I have no opportunity to test it, that's the reason why I'm asking.

Error when accessing an InfoPath file on a file share

Some users get an error when they try to open an InfoPath (2007) file which is location on a file share.  The users getting the error are from our South America domain.  All users, regardless of domain, have the same permissions to the file share folder and they can open and save other files on that file share, txt file, Excel file, etc.  They get this error when trying to open the Info Path file:  "InfoPath cannot create a new, blank form.  InfoPath cannot open the form.  to fix this problem, contact your system administrator.  The query cannot be run for the following data source:SoftwareList"

Need to find File Share Excel Rendering time--SSRS 2008

we are using SSRS 2008 file share subscription to generate EXCEL reports,Requirement here is need to find the file rendering/completion time in order to send the excel file as attachement using xp_senddbmail. Your help is highly appreciated-- Sathish

File Share Crawl and Security Trimming

I have configured a file share to be indexed by SharePoint using the crawl domain account (which is a farm admin account as well). The crawl account has the necessary read permissions on the share and the crawl was successfull. However when an unauthorized user performs a search, the restricted files are still returned by SharePoint even though the user gets access denied message when clicking on the link. Can anyone please provide me with some information of why that may be happening?? I ensured that the user does not have any permissions on that share and any files in it. Thanks in adavace.

An incremental crawl on a file share always has about 9000 successes although nothing has changed


Hi everybody,


We have several file shares (based on Windows servers) that we want to crawl with our SharePoint 2010 system. It is all set up and running, not too fast but that might be another topic. I noticed that every incremental crawl on a file share with about 50 GB of data leads to 9000 successes (according to the crawl log). I did some investigation and saw that there are about 9000 folders on this file share.

It looks like the crawler always recrawls all folders! Is this how it should be?

I think that if there aren't any changes no recrawl should be necessary. Moreover this could speed up the incremental crawl.


Any ideas?


Thanks for your help!





Move folder from file share to local C:/ drive on same box



I need to copy a folder from a file share to my local C: drive. Is there an easy way to do this in SSIS, or do I have to write a DOS batch file and execute it from SSIS.

Any help would be appreciated


Dave SQL Developer

SSRS 2008 R2 After using SSL, In Report Manager new datasource link, upload file link, subscription



I have provided my setting and environment information below. My goal is to set Report Manager and Report Server URL with SSL connection so all URLs uses HTTPS (Secure connection) all the time. and remove HTTP access .

I applied following settings for this but I am getting errors. With Current Settings that I mensioned below, I am able to login into WebService URL successfully with all links working. For Report Manager URL  I logged in successfully but for some pages I am getting HTTP links instead HTTPS. It shows HTTP links for new datasource link, upload file link, subscription links so it shows blank page

I tried to look for solution and I applied but did not worked. I did some experiment with changing urls using application and manually from RSReportServer.config file but still not succedded.

Steps taken to solve problem:

  • To force to use HTTPS only, I tried to change SecureConnectionLevel = 0 to  1,2 or 3 but when accessing to Report Manager it gives 401 Authentication error.
  • If I remove http://+:80/ReportServer and tried to visit 2nd URL with HTTPS. The Web Service URL opens successfully. but Report Manager url gives me er

Error while creating subscription from the backup file






='marcus8-test', --> Name of the publication



Insert spaces to get fixed length fields for flat file export



I have a query which extracts all the required data from a database and I need to load this data into a Text File. I am using a SSIS package to do this.

Now this file should have data in the format given below

437856785        A20101009This is construction         124728347

i.e the receiving file has no delimiters and each field is determined with a fixed length(fixed number of characters). The data I get out of my query for example for the first column returns just the value 437856785 and I need to append spaces to it to achieve the fixed length. I need to do to this kind of appending spaces to all the columns. Please suggest me ways to do this.

Thanks in advance..



Best way to find out if a very large PDF has rendered on a file share?


We are building our bill system printing process and part of the process is to generate a huge PDF to a file share with single page bills inside to print on our folding / stuffing appliance.  Currently, there is a one time subscription created on the report server that is then executed from SSIS in the form of a "Execute SQL Server Agent Job Task" which will send a PDF to a file share defined in the subscription.

We are noticing that this process can go wrong at many points and need to find a way to account for each potential problem.  We first notice that SSIS is totally unaware of almost all failures of the report subscription except the most basic failures that the SQL Server agent is aware of like the subscription being faulty or the database being down; we can capture that easily enough; but it isn't sufficient. 

SSIS executes the SSRS subscription in seconds even though it might take 45 minutes or longer to render.

After SSIS has called the subscription, we have noticed a few problems can happen.

1. A permissions issue can occur on the file share if your password expires (Failure writing file: A log on error occurred when attemp

Check file permission in (local/network share) directory?



I need to check whether a user has read/write permission to a file on any directories (local or network share).

Can someone provide a short code sample?

I've seen many examples online (pinvoking NetShareGetInfo, DirectoryInfo.GetAccessControl(), FileIOPermission.Demand(), etc), but I'm still unable to correctly check if a file in a network share directory (e.g, \\networkPC\sharedFolder) is readable/writable.

All my checks will pass, but when I attempt to write a file, I get UnauthorizedAccessException ("Access to the path ... is denied").

Should I really be doing my checks this way?

public static bool IsFileWritable(string fileName)
  bool isWritable;
  FileInfo file = new FileInfo(fileName);
    using (Stream stream = file.OpenWrite()) // attempt to open a write stream.
    isWritable = true;
    isWritable = false;

How to link or hyperlink files form a File Share from SharePoint


Hi all

We want to put a hyperlink to a directory in a shared drive where there is plenty of space for archive and the overflow of documents.

When someone goes to a document folder and wants to upload their document on SharePoint, when they click, instead of going to the upload page, is there a way that they are hyperlinked to a share drive folder where there is plenty of room.

Is there a way to link or hyperlink  directly from a SharePoint document library to a file or file share?

Please advice


Problem with deleting subscription and big log file


Hi dear all,

It's sql server 2008. The publisher already does not exist. I tried several stored procedures to delete local subscription at subscriber, but always received:

"Could not delete the subscription.
An exception occurred while executing a Transact-SQL statement or batch.Invalid column name 'job_step_uid'. (.Net SqlClient Data Provider)"

And because of that the transactional log file could not be truncated, grows up and is too big.
Please help.




Domain account from SQL box needs to access file share on DMZ server


We have a web server set up on the DMZ that talks to a SQL 2005 server on the company domain.

The issue is, we are trying to install this CMS engine that requires a domain account from the SQL server to access a share on the web server that is in the DMZ. 

Is there a way to trust a domain account to have access to a share on the DMZ server?  I have heard of "read only" and one way trusts.  Is that secure and if so how would we go about setting that up?

Basically I want to avoid at all costs of putting the SQL Server on the DMZ server but need a seamless way to access a file share from the trusted SQL Server.

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend