BISQL # 31 : How To Create Folder from SSMS
Hi Friends,
This is very normal requirement in DB,In most case SSIS developer requires this.
For this we have to use following two EXEC MASTER.dbo.Xp Sp’s
- EXEC MASTER.sys.Xp_dirtree
- EXEC MASTER.dbo.Xp_create_subdir
Lets go one by one
EXEC MASTER.sys.Xp_dirtree
This is used to find level of directories for a particular folder
— Below query will list out the directories on C drive in BIDS Folder
EXEC MASTER.sys.Xp_dirtree ‘C:\BIDS’
Having following output
EXEC MASTER.dbo.Xp_create_subdir
This is used to create folder in any directory in windows OS
— Below query will create the folder SSIS Folder in BIDS Directory on C:\BIDS\ drive
EXEC MASTER.dbo.Xp_create_subdir ‘C:\BIDS\SSIS’
GO and try out the following query in your server
-- Below query will list out the directories on C:\BIDS drive EXEC MASTER.sys.Xp_dirtree 'C:\BIDS' -- Below query will create the folder SSIS in BIDS Directory on C:\BIDS\ drive EXEC MASTER.dbo.Xp_create_subdir 'C:\BIDS\SSIS' -- Below query will create the folder VishalPawar folder in SSIS Directory on C:\BIDS\SSIS drive EXEC MASTER.dbo.Xp_create_subdir 'C:\BIDS\SSIS\VishalPawar'
You can also Visit to todays Link Resource Website : Link Resource # 8 July 28 « Dactylonomy of Web Resource
Hope this helps !!
For more interesting information on SQL we can also look into similar topics such as
· BISQL # 32 : How To find Parent Child Relationship Between Tables
· BISQL # 33 : Lets Understand Stored Procedure
· BISQL # 34 : What is Identity IN SQL {Identity Part–I}
· BISQL # 35 : Deep dive into Identity Functions in SQL {Identity Part–II}
· BISQL # 36 : Queries to Understand more on Identity aspect {Identity Part–III}
Hope you will like this post on Creating folder on SSMS.
If you really like reading my blog and understood at least few thing then please don’t forget to subscribe my blog.
If you want daily link and analysis or interesting link go to following website which will give @ your inbox please subscribe our following link resource blog : Link Resource Website
For More information related to BI World visit my Mentalist Blog
Link Resource Blog >> Daily Interesting links
SQL Server Mentalist >> SQL Learning Blog
Business Intelligence Mentalist >> BI World
Connect With me on
Copyright © 2011 – 2012 Vishal Pawar
-
July 28, 2011 at 8:10 pmLink Resource # 8 July 28 « Dactylonomy of Web Resource
-
July 31, 2011 at 10:11 pmList of monthly post of MS BI and SQL blog–July 2011 « SQL Server Mentalist
-
July 31, 2011 at 10:19 pmList of monthly post of MS BI and SQL blog–July 2011 « (B)usiness (I)ntelligence Mentalist
-
July 31, 2011 at 10:30 pmList of monthly post of MS BI and SQL blog–July 2011 « Dactylonomy of Web Resource
SQL Server Mentalist 