Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Using Script Task to check if Folder Exists Expand / Collapse
Author
Message
Posted Tuesday, June 11, 2013 6:57 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, September 24, 2013 5:00 PM
Points: 50, Visits: 161
Lidou123 (6/6/2013)
Hi,

I have the same problem.
Did you found the solution ?
How to prevent the creation of a folder which already exists


I have not. I just manually rename the first folder created if I ever run into this situation. Fortunately for me it's rare so I just went with the manual solution. Hope you find a solution to your problem and keep us posted.
Post #1462065
Posted Tuesday, June 11, 2013 11:29 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 12:23 AM
Points: 4,833, Visits: 11,202
mrtrich99 (6/11/2013)
Lidou123 (6/6/2013)
Hi,

I have the same problem.
Did you found the solution ?
How to prevent the creation of a folder which already exists


I have not. I just manually rename the first folder created if I ever run into this situation. Fortunately for me it's rare so I just went with the manual solution. Hope you find a solution to your problem and keep us posted.


I posted some sample code for a Script Task which will create a folder only if it does not exist - see this thread.



Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

When you ask a question (and please do ask a question: "My T-SQL does not work" just doesn't cut it), please provide enough information for us to understand its context.
Post #1462454
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse