dc

dc

  • NA
  • 663
  • 0

write .net application to be like data driven subscription in SSRS 2008 R2

Feb 16 2011 3:00 PM

If the below option does not work, how you you setup this setup this situation in a C#.net 2008 or C#.net 2010 professional edition: 

I would like to be able to control the standard subscription in SSRS 2008 r2 to a file share directory using the standard edition of sql server

2008 r2, I would use the following link:
http://msdn.microsoft.com/en-us/library/ms157386.aspx.


The situation I have would be like the followiing:
1.  I want to be able to write to a directory structure that has three levels. The file share directory would look like: 
 a. higher level would be region like midwest, east-coast, and west-coast.
  b. The middle level would be state level like Iowa, Ohio, oregon, california, etc...
  c. The third level would be the city name like Council bluffs (which is in Iowa and higher level would be the midwest). Another example would be the city of Anaheim (which is in California which is in the west-coast.)
To be able to store files in this directory strucutre, could I accomplish task using a standard subscription? If so is there a url you can point me to that would give more details?
If not, would one of the following two choices be an option:
- Write a .net application that would accomplsih this task for me? If so, do you have a url I can look at  for a reference? If not, I will look on the internet to see how to write this .net code and/or would you recommend what forum group would I ask this question to?
- Would setting up the standard subscription to e-mail addresses help and then use the
 e-mail addresses to write the file to reports to the file share work?
If the above does not work, would you recommend writing a .net application to accomplish this task?  
 

Answers (2)