Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

dtutil.exe Creating Folder SQL only if the folder doesn't ..

 
   Database Forums (Home) -> DTS RSS
Next:  Migrate subset of data from 2000 to 2005  
Author Message
ls

External


Since: May 04, 2006
Posts: 1



(Msg. 1) Posted: Thu May 04, 2006 8:42 pm
Post subject: dtutil.exe Creating Folder SQL only if the folder doesn't ex
Archived from groups: microsoft>public>sqlserver>dts (more info?)

I was wonder if anyone know how I go about creating a folder in SQL location
only if the folder doesn't exist. I can create a folder if I run

dtutil.exe /SourceServer mySqlServer /FCreate SQL;/;NewFolder

However if the folder already exist, I get and error. I'm trying to write a
batch file to create the folder (only if it doesn't exist) and then copy my
package into sql server.

 >> Stay informed about: dtutil.exe Creating Folder SQL only if the folder doesn't .. 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
To copy files from a folder to another folder - In order to copy all files in certain folder to another folder (with the same file name) I have placed a File System Task inside the foreeach Loop container. However, I'm not sure on how to set the variables ie. the property of the File System Task...

FTP Tasks return error when FTP Remote Folder have not any.. -

auto start a dts package by placing a file in a folder - I need a way to execute a sql dts package when a file is placed into a directory. Essentially this would be like a file system Monitor or file listner that would be waiting for a file as soon as the file is in the directory it would read from the flat...

SSIS:how to arrange dtsx into different folder & offline s.. - hi! I have 2 questions about SSIS. 1. In my SSIS project there are many dtsx can I arrange them into different folder? like SSIS_PROJ | ---FolerA---DTSX1, DTSX2,DTSX3 ---FolerB---DTSX4, DTSX5,DTSX6 I've tried to arrange these DTSX but failed. I wonder....

Creating DTS packages with VB.NET and DB2 - Hello, I would like to use the DTS object model and VB .NET to create DTS packages to connect to DB2 and export data to CSV and XLS formats as well as import data from CSV or XLS into DB2 tables. Can anyone point me to VB .NET code sample that do this...
   Database Forums (Home) -> DTS All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]