Adding Folders In The Solution Explorer?

Oct 27, 2006

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

View 2 Replies


ADVERTISEMENT

Adding Folders Under The Solution

Jul 5, 2007

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.

View 4 Replies View Related

Adding Misc Files To Solution Explorer

Dec 12, 2005

I assume this is the best forum for this quesiton; if not, please direct me.

View 3 Replies View Related

Create Folders In Object Explorer - Wish...

May 4, 2007

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

View 1 Replies View Related

Solution Explorer And SQL Server

Dec 12, 2005

I am a Visual Studio .net developer and understand Solutions and Projects in VS.net.  Nevertheless, it appears that the paradigm of using Solutions Explorer in SQL Server is not exactly the same.  That is, in Visual Studio you can't get anything done without creating a solution first.  In SQL Server, it is entirely possible to get a lot done without a solution and the ability to create and make use of a solution seems almost an after thought or an add-on.
I am particularly interested in using a solution in SQL Server to allow me to make use of SourceSafe.  In the past, we jumped through all kinds of hoops to keep a running trail of changes we had made to (for example) stored procedures.  It appears now that this can be managed more efficiently with the use of a Solution and SourceSafe and saving scripts or .sql files.  I guess it is not possible to save a pristine copy of a stored procedure directly in SourceSafe, but you can save the code that makes up the stored procedure as a .SQL file which I suppose is about as good.
Anyway, what I would like to know is whether there is a good white paper (or chapter in a book) on the philosophy behind Solutions and projects in SQL Server and how MS intends us to use them; perhaps something other than the cold facts from the documentation.  I would appreciate something more that gives me the big picture on just how MS sees them being used in SQL Server so I can get the most out of them.  I have the feeling that if I "get the vision", they are meant to be an integral part of SQL Server now and in the future.
Woody

View 3 Replies View Related

Order Packages By Name In Solution Explorer

Dec 19, 2007

Good afternoon,
This is a simple question....how can I order packages by name in solution explorer ? I have a solution with more or less 50 packages
and it's very ime consuming to find a package ! ehehe

Thanks everybody

View 5 Replies View Related

What Is It For 'rebuild' Option On Solution Explorer?

Jun 6, 2006

Up to the moment I don't need it at all

tia

View 3 Replies View Related

Oracle Connection In Solution Explorer

Mar 10, 2008

When trying to create a data source in Solution Explorer the Provider is greyed out and only allows me to create a connection to a SQL server database although I can connect to an oracle database in Server Explorer

View 5 Replies View Related

Arrange Items In Solution Explorer

Sep 20, 2007

Can the items, i.e. reports within the SSRS Report Designer Solution Explorer be arranged in a custom manner instead of being sorted alphabetically only?

View 2 Replies View Related

How To Add Subfolders To The Report Folder In Solution Explorer

Dec 17, 2007



Hello,

When you create a Reporting Services project it by default creates two folders: Shared Data Sources & Reports. When I right click on the Reports folder in solution explorer in Visual Studio 2005 there is no option to add subfolders, I am simply left with handful of options adding report files. Is there a way to add subfolders to the Reports folder? I am going to be migrating over 40-50+ reports and it would be helpful to organize them into their own folders.

Thanks,
Flea

View 3 Replies View Related

How To Use The Deply Menu From Within The Project In Solution Explorer

Jan 21, 2008

I'm stuggling to find information on how to use the Deploy menu within a project in solution explorer. I would like to understand how to setup modify and delete the attributes that affect the actions of the Deploy menu. How to set different settings so that I can deploy to a test server ad then later change it so that I can deploy to a production server.

All help is welcome.
Thanks

View 1 Replies View Related

Sorting The Packages In The Solution Explorer Window

Jun 14, 2006

Hello all,

A simple one: How can I sort the packages in my project (in the solution explorer) in an alphabetical sort?



Thanks,

Liran

View 1 Replies View Related

Solution Explorer Drag/drop Error?

Feb 19, 2007

I've submitted a bug report for this, but I also want to be sure it's not my own installation.

In the solution explorer, when I drag a package (usually accidentally) to another spot in the list, it disappears from the list. If I try to re-add the package, it thinks the original already exists, and names the second one with a "(1)" suffix. I can work around this by moving the original package out of the primary package folder and then re-adding it through solution explorer, but that's a touch cumbersome.

I don't really have a question here other than perhaps validation of the issue. Thanks.

Here's the bug report if others experience the same issue:
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=258908

View 1 Replies View Related

Can't Execute Package From BIDS Solution Explorer Post SP2 Install

Feb 20, 2007

Yesterday, SQL Server 2005 SP2 was installed on our DEV Server (Windows 2003 SP1 x86) and now I cannot right-click a package in the Solutions Explorer window in BIDS and Execute Package. When I do, I get the following error

===================================

Object reference not set to an instance of an object. (Microsoft Visual Studio)

------------------------------
Program Location:

at Microsoft.DataTransformationServices.Project.DtsPackagesFolderProjectFeature.ExecuteTaskOrPackage(ProjectItem prjItem, String taskPath)

I know I could do this yesterday morning pre SP2. I've attempted this with a couple of different packages and solutions, so it is probably not a corrupt package (unless now they are all corrupt). I can execute in debug mode if I open the package first and then hit Start Debugging. However this is not always an optimal solution because I sometimes have many connected packages and sometimes what gets executed is not what is expected.

Your thoughts would be appreciated.

View 1 Replies View Related

SQL Server 2008 :: Delete Folders / Sub Folders Older Than N No Of Days

Jul 30, 2015

If 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 Related

T-SQL (SS2K8) :: Function To Create Folders (and Sub Folders)

Jun 5, 2014

I'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] .....

View 1 Replies View Related

How Can I Return A Database From The DataBase Explorer Of VB 2005 Express To The Object Explorer Of SQL Server Management Studio

Mar 3, 2008

Hi all,

I just realized recently that a database "XYZ" in the Object Explorer of my SQL Server Management Studio Express (SSMSE) is put in the Database Explorer of my VB 2005 Express for processing a Stored Procedure in executing the SELECT statements (not by using Input and/or Output Parameters) during the ADO.NET 2.0-VB 2005 Express programming, then the content of the database "XYZ" is not in the SSMSE. How can I return the database "XYZ" from the DataBase Explorer of VB 2005 Express back to the Object Explorer of SQL Server Management Studio Express (SSMSE) safely? Please help and advise.

Thanks in advance,
Scott Chang

View 6 Replies View Related

SOLUTION! - VB.NET 2005 Express And SQL Server 2005 - NOT Saving Updates To DB - SOLUTION!

Nov 30, 2006

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.

View 17 Replies View Related

Object Explorer And Object Explorer Details

Apr 23, 2008

SQL server 2005:
How to view or open tables under object explorer details, when i double click an object under object explorer.

thats how the default settings used to be.

now when i double click any object or try to open query analyzer it is open in the same left side pane on top of Object explorer window.

i did something to my explorer and explorer details panes since then both are separated, they are not getting synchronized.

Thanks for your help.

View 1 Replies View Related

Two (2) App_Data Folders?

Apr 25, 2007

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
 

View 2 Replies View Related

How To Add Folders In SQL 2005

Jun 13, 2007

does anyone have idea How to add folders in SQL 2005
thanks in advance

View 12 Replies View Related

Two MDF Files With Same Name In Different Folders

Apr 25, 2015

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

View 6 Replies View Related

How To Enumerate IS Folders ?

Dec 5, 2007



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

View 3 Replies View Related

Deploying To Sub Folders

Feb 21, 2008



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

View 13 Replies View Related

Dynamically Name Folders

Feb 12, 2007

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

View 3 Replies View Related

SQl Dbase Query From Different Folders

Feb 4, 2008

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

View 7 Replies View Related

Hide Folders In Report Mng

May 12, 2008

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?

View 4 Replies View Related

Databases In Separate Folders?

Mar 15, 2006

In Enterprise Manager, is there a way to group Databases into Separate folders?

View 6 Replies View Related

Deleting Folders Using SQL Triggers

Jun 24, 2007

I 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?

View 1 Replies View Related

Restricting Access To Certain Folders?

Jan 6, 2007

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

View 10 Replies View Related

Can You Create Folders Under Databases In SMS

Aug 20, 2006

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

View 1 Replies View Related

Granting Permission To Folders

Feb 12, 2008

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!

View 4 Replies View Related

How To Suft Through MSDB Folders?

Feb 7, 2007

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,

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved