In RS, can one add a folder under the Reports folder? I don't see where I can do this. We work with many different state's and we would like to organize reports by state.
Thanks for the information.
Hi..
Isnīt it possible to create sub folders in the solution explorer??
I have it hard time to create a decent structure inside the SSIS Package folder, since I have like 30 packages in my project. Is it just me being silly or cannot this be done?
Have a nice day
/Erik
I assume this is the best forum for this quesiton; if not, please direct me.
View 3 Replies View RelatedIf I run the below command, it clean up the files inside the folders but unable to clean up the folder and sub-folders older than 30 days. xp_ cmd shell ' forfiles -p "D:abcd" -s -m *.* -d -30 -c "cmd /c del /Q @path"'
View 4 Replies View RelatedI'm using sp_OACreate in a scalar function to create a folder if it doesn't exist, and it works fine if you're asking it to create a single folder. For instance: C:Newfolder
It creates "Newfolder"
However, if I try to ask it to create C:NewfolderNewsubfolder
It doesn't work
Here's the code:
DECLARE @Exists int, @ObjFile int, @ObjFileSystem int, @Folder nvarchar(500) = 'C:',
@Action tinyint = 1 --(0 to check if folder exists, 1 to actually create it)
EXEC dbo.sp_OACreate 'Scripting.FileSystemObject', @ObjFileSystem OUT
EXEC dbo.sp_OAMethod @ObjFileSystem, 'FolderExists', @Exists OUT, @Folder
[Code] .....
VB.NET 2005 Express and SQL Server 2005 Express - NOT saving updates to DB - SOLUTION!
-----------------------------------
The following article is bogus and confusing:
How to: Manage Local Data Files - Setting 'Copy to Output Directory' to 'Do not copy'
http://msdn2.microsoft.com/en-us/library/ms246989.aspx
You must manually copy the database file to the output directory
AFTER setting 'Copy to Output Directory' to 'Do not copy'.
Do not copy
The file is never copied or overwritten by the project system. Because your application creates a dynamic connection string that points to the database file in the output directory, this setting only works for local database files when you manually copy the file yourself.
You must manually copy the database file to the output directory
AFTER setting 'Copy to Output Directory' to 'Do not copy'.
-----------------------------------
The above article is bogus and confusing.
This is rediculous!
This is the most vague and convoluted bunch of nonsince I've ever come accross!
Getting caught out on this issue for the 10th time!
And not being able to find an exact step-by-step solution.
--------------------------
I've tried it and it doesn't work for me.
Please don't try what the article eludes to as I'm still sorting out exactly what is supposed to be happening.
If you have a step-by-step procedure that can be reproduced this properly please PM me.
I would like to test its validity then update this exact post as a solution rather than just another dicussion thread.
Many thanks.
This is the exact procedure I have come up with:
NOTE 1: DO NOT allow VB.net to copy the database into its folders/directorys.
NOTE 2: DO NOT hand copy the database to a folder/directory in your project.
Yes, I know its hard not to do it because you want your project nice and tidy.
I just simply could NOT get it to work.
You should NOT have myData.mdf listed in the Solution Explorer. Ever.
Create a folder for your data following NOTE 2.
Copy your data to that folder. * mine was C:mydatamyData.mdf
Create a NEW project.
Remove any Data Connections. ( no matter what)
Save it.
Data | View Data Sources
Add New Data Source
select NEW CONNECTION ( No Matter what, do it!
Select the database. * again mine was C:mydatamyData.mdf
Answer NO to the question:
Would you like to copy the file to your project and modify the connection?
- NO ( no matter what - ANSWER NO ! - Absolutely NO )
Then select the tables you want in the DataSet.
and Finish.
To Test ----------
From the Solution Explorer | click the table name drop down arrow | select details
Now Drag the table name onto the form.
The form is then populated with a Navigation control
and matching Labels with corresponding Textboxes for each field in the table.
Save it.
1) Run the app.
Add one database record to the database by pressing the Add(+) icon
Just add some quick junk data that you don't mind getting lost if it doesn't save.
YOU MUST CLICK THE SAVE ICON to save the data you just entered.
Now exit the application.
2) Run the app again.
And verify there is one record already there.
Now add a second database record to the database by pressing the Add (+) icon.
NOW add some quick junk data that you WILL intentionally loose.
*** DO NOT *** press the save icon.
Just Exit the app.
3) Again, Run the app.
Verify that the first record is still there.
Verify that the Second record is NOT there.
Its NOT there because you didn't save the data before exiting the app.
Proving that YOU MUST CLICK THE SAVE ICON to save the data you just entered.
Also proving you must add your own code to catch the changes
and ask the user to save the data before exitiing or moving to another record.
As a side note, since vb.net uses detached datasets,
(a copy/snapshot of the dataset in memory and NOT directly linked to the database)
the dataset will reflect all changes made when moving around the detached datasets.
YOU MUT REMEMBER TO SUBMIT YOUR CHANGES TO THE DATABASE TO SAVE THEM.
Otherwise, they will simply be discarded without notice.
Whewh!
I hope this saves me some time the next time I want to start a new database project.
Oh, and uh, for anyone else reading this post.
Thanks,
Barry G. Sumpter
Currently working with:
Visual Basic 2005 Express
SQL Server 2005 Express
Developing Windows Forms with
101 Samples for Visual Basic 2005
using the DataGridView thru code
and every development wizard I can find within vb.net
unless otherwise individually stated within a thread.
I loaded an application to my server with the app_data folder intact in the application folder which is a sub folder of the root web.
Through my host enableing SQL somehow a second App_Data folder has been created in the root of the web and the db has been duplicated. Without a doubt this is causing a problem with the application not running correctly. The application is the asp.net membership app which is trying to read and write to the .mdf file.
Can we simply delete the App_data folder in the the root web or will this rebuild itself? Or do we need to edit the web config files?
How / Why did this happen?
Server is running Win2k with SQL Express 2005
TRU
does anyone have idea How to add folders in SQL 2005
thanks in advance
Is it OK to have two mdf files with the same name placed in different folders and attached with different names.
Example:
DATADB1Hotel.mdf attached as hotel1
DATADB2Hotel.mdf attached as hotel2
Hi All,
I need to get access to stored packages. To do so I use
Microsoft.SqlServer.Dts.Runtime.Application class.
There are methods: Application.FolderExistsOnDtsServer, Application.FolderExistsOnSqlServer
but I need to enumerate existed folders.
Are there something like: Application.GetFolders(String ParentFolderName) ?
I have searched in doc but there is not any useful except:
"To verify that the folder was created, the following Transact-SQL query selects all packages stored in the File System folder of the Stored Packages package store.
select * from sysdtspackages90 "
It is not suitable for me because I don't have permissions to access database
Thanks,
Sergiy
hi all
using sqlserver 2005 Reporting Services
When I go to deploy
my main folder = Reports
my sub folder = reAct or Managers Reports or Onboarding etc
how do I deploy directly to the sub-folders?
thanks
jewel
Apologies in advance for the newbie question. I'm new to Integration Services and am trying to build my first project.
I want to dynamically create folders based on the results of a stored procedure. The resultset is limited to one column but can contain multiple rows. (It returns a list of 8-character strings representing dates.) This returned value needs to be combined with the path where the new folders should be created.
Can someone point me in the right direction? I've run the stored procedure and put the resultset into a RecordSet Destination that uses a variable of type Object. (At least, I think I've done it correctly.) But I have not been able to figure out how to access this data to actually create the folders.
Thanks for the help,
Chris
HI, I have a Dbase Database stored in several subfolders. I allready made my connection with a sqldatasource and a gridview, and all works fine when i do a query with the tables in to root folder. The problem is when I try to include tables from the subfolders, the compiler send me a syntax error in the FROM Clausule
I Allready try this.
SELECT products.id, products.descri, condition.discount from products, clientscondition where products.line=condition.line
SELECT producst.id, products.descri, clientscondition.discount from products, clientscondition where products.line=condition.line
SELECT products.id, products.descri, condition.discount from products, condition in 'clients' where products.line=condition.line
SELECT producst.id, products.descri, clientscondition.discount from products, 'clients'.condition where products.line=condition.line
And many other different combinations. I would like to be helped if you know the correct syntax or a link where i can consult the syntax for VB.net and dbase with several folders
Another option a tried is having a query from 2 different datasources, but I donÂīt know how to make a reference to the 2 sqldatassources in a new one to be linked to the gridview
Hi All,
I would like to control user access to my Report Manager.In detail,I would like to hide some report folders from certain users when they access the Report Manager.Some of the users are not suppose to see certain folders on the report manager,and some users are suppose to see all report folders.
How can I do this?.Where should I include this settings?
In Enterprise Manager, is there a way to group Databases into Separate folders?
View 6 Replies View RelatedI need to delete the empty subfolders under my "uploads" folder
how can i perform that using triggers
i need to delete old records in database and the folders associated with them, i've used triggers to delete the records before 180 days, but i don't know how to remove the folders associated with each folder.
note:
name of folders is the same as record number
is that possible?
Hi all,
I have a user who I only want to provide access to a single folder within
RS2005. I don't seem to be able todo this, they can either see everything or
nothing at all.
What am I missing? Any help much appreciated.
Kind regards
Tarun
I see under databases in the object explorer of SQL Server Management Studio that there are two sub-folders: System Databases and Database Snapshots.
Is there a way to create other folders here? It would be nice to be able to group the various databases (ex. Samples).
tia
Within my Report Manager, I have several folders, and I would like these folders to be only visible to certain users and groups. In the Active Directory I have DOMAINGroupName1. If I add this group to the folder I want them to have access to with a Browser role, when they open Report Manager they do not see the folder at all. Then I added the same group to the HOME folder also, but again they could not see their folder when they opened the Report Manager. If I add the Users of this group individually (DOMAINUser1, DOMAINUser2 etc) then they can see the folder and run reports just fine. This is not an ideal solution as groups will change over time and I don't want to have to keep adding and deleting members. Anyone got any ideas why they can't see their folder?
Thanks!
Hi everyone,
Primary platform is Framework 2.0.
My target now is to know programatically how many folder exists under MSDB folder as well as its names.
How to accomplish this?
Thanks in advance and regards,
I am making changes to a report and believe I am correctly deploying it to an ssrs report folder per the messages I get back from vs.net.
Question is, how can I see what folders are available? and where? At some point I knew or was able to do this, and think it was through SQL server since I can't see them through IIS and they don't appear to be real file system folders.
Also, I'm trying to figure out why parameter default value changes i make don't seem to deploy or overwrite??, while cosmetic (color for example) changes do when I deploy. I am selecting the option overwritedatasource in the project.
If I navigate to the reportserver I see the folder in question.
http://myreopertserveriphere/reportserver
Thanks for any help or information!
I am the administrator for our Reporting Services environment. I was researching the functionality of the My Reports feature of Reporting Services 2005. I enabled the My Reports feature and SSRS created folders to accomodate this feature. I then experimented with linked reports.
Now I want to undo this feature. I turned off the My Reports feature but the folders remain. The Report Manager refuses to delete them. I found their entries in the ReportServer.Catalog table but don't want to just delete them.
Does anyone know how to remove these folders from the Report Manager?
Gordy
Can someone please help in in understanding what I have done wrong. My company is using Backup Exec 7.3 as it's back up application. I have built a server, installed SQL, Built an database and added logins. I am backing up my database and Transact Log Files to specific folders on my partioned drive. Why when I run the backup ups, It backs up everything EXCEPT for my SQL folders. It seems to Skipp all SQL Folders. Please Help, I need to have this funtion working properly. What have I done wrong or what do I need to do to make this stop. Does this perhaps have something to dwil Here is an example of the backup Message in Backup Exec that I am recieving:
Media Name: "DIFF"
Backup of "FEPTESTE$ "
Backup set #41 on storage media #1
Backup set description: "Daily 6"
Backup Type: DIFFERENTIAL - Changed Files
Backup started on 6/28/02 at 12:36:21 AM.
The item Microsoft SQL ServerDataMSSQLDataTESTDB_Data.MDF in use - skipped.
The item Microsoft SQL ServerDataMSSQLDatamaster.mdf in use - skipped.
The item Microsoft SQL ServerDataMSSQLDatamastlog.ldf in use - skipped.
The item Microsoft SQL ServerDataMSSQLDatamodel.mdf in use - skipped.
The item Microsoft SQL ServerDataMSSQLDatamodellog.ldf in use - skipped.
The item Microsoft SQL ServerDataMSSQLDatamsdbdata.mdf in use - skipped.
The item Microsoft SQL ServerDataMSSQLDatamsdblog.ldf in use - skipped.
The item Microsoft SQL ServerDataMSSQLDataorthwnd.ldf in use - skipped.
The item Microsoft SQL ServerDataMSSQLDataorthwnd.mdf in use - skipped.
The item Microsoft SQL ServerDataMSSQLDatapubs.mdf in use - skipped.
The item Microsoft SQL ServerDataMSSQLDatapubs_log.ldf in use - skipped.
The item Microsoft SQL ServerDataMSSQLDataempdb.mdf in use - skipped.
The item Microsoft SQL ServerDataMSSQLDataemplog.ldf in use - skipped.
The item Microsoft SQL ServerDataMSSQLLOGTEST_Log.LDF in use - skipped.
Backup completed on 6/28/02 at 12:37:11 AM.
Backed up 48 files in 24 directories.
14 items were skipped.
Processed 23,876,604 bytes in 50 seconds.
Throughput rate: 27.3 MB/min
Hi,
I have one query in sql server reporting services securities.
In ssrs i have folders like(Custom reports, testreports,...). these folders are having reports. In this i want to give permissions to folders means if i gave permission to user1 to access the custom reports folder then he is able to access to that folder only and he is not able to access to any other foldes. How to give permissions to folders.
Pls any one help me on this.
Thanks
Ravuri
Here's one thing that I'd like to see come out in some version of the SQL Server Management Studio...
The ability to create folders under the database node so that databases can be grouped on one server.
We have over 100 databases on our development server and these are created by a range of consultants and developers and even support staff as needed.
Being able to group the databases by product, etc would be a nice touch since we have client databases that don't fit naming conventions etc.
Multiple instances are another way around this but are expensive and resource hungry - we develop and support models, not use them for transactions too much.
Yes there are 'better' ways such as setting security correctly but we are too busy working and not maintaining.
Folders or database groups would be a nice touch.
Cheers
Hello I have a few questions hoping someone can help
Any way to hide a report completely ? ie data source folders, subreports called from hyperlinks etc
Anyway off hiding the List view and restrict the user from selecting list view ?
Anyway off customising the reporting services top area which is in yellow and black ie put a logo in this area ?
thanks
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 FilesMicrosoft SQL Server90DTSPackages) 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
I have a situation from where I need to loop through different folders and files in these folders. After processing these files, I need to archive these folders to different location.
e.g., C:MainFolderMar01 ==> Multiple files in Mar01 folder
C:MainFolderMar02 ==> Multiple files in Mar02 folder
Does any one know the best way to do this in SSIS?
Thanks in advance.
BC
Hi, I am a new user for RS so this might be a very dump question for some of the advanced users here.
I am using SQL 2005 RS and was wondering how I can deploy reports to specific folders that I created on the Reports page. I do know that I can go to Properties to move the reports to different folders. But the problem I have is when I deploy the reports from VS 2005 ( I created the reports using VS 2005) they were deployed back to the old/root folder. How can I change the 'deploy-to' destination folder for the reports in VS 2005?
Many Thanks,
Casey
Hi,
can i deploy reporting services rdl files into different folders in RS?
will it be able to create the folders by itself or do i need to create them beforehand?
thanks for any answers.
-
HY
By default,when I would like to back up any database by SSMS.
default destination on disk will be C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBackup every time
Although I everytime change it to my backup folder.
Please let me know how to change it.
I have a simple FOR EACH loop who's task is to go to a folder, find all .zip files and then extract them to a directory of my choosing. I only want this step to extract files in a particular (root) directory.
What is happening is after the step extracts the main file to the specified output directory, it then goes to the next directory and extracts the files in THAT directory - even though I do NOT have "traverse subfolders" selected.
What is going on here? This has never happened before - at least when I was developing these packages with SQL 2008 R2...
Is there any way we can download sharepoint folders using ssis. I have a specific link(View on sharepoint) which I would like to download using ssis, Is it possible?
View 2 Replies View Related