<div>
I would think that you would have to do it either in SSIS as an Execute Process task, or using xp_cmdshell as a job step in the job. &nbsp;As for the 2nd question, I am not sure what you maen.
</div>


I would think that you would have to do it either in SSIS as an Execute Process task, or using xp_cmdshell as a job step in the job.  As for the 2nd question, I am not sure what you maen.

<div>
I would need an actual example of the actual DOS command. &nbsp;I guess there are two involved, copy and move. &nbsp;<br />
<br />
Also, to clarify my second question: I want there to be a date and time stamp for when the task of copying and moving a file in DOS was accomplished
</div>


I would need an actual example of the actual DOS command.  I guess there are two involved, copy and move.  

Also, to clarify my second question: I want there to be a date and time stamp for when the task of copying and moving a file in DOS was accomplished

<div>
Due to security measures on our system we are not allowed to use xp_cmdshell. &nbsp;Is there any other way to do this?
</div>


Due to security measures on our system we are not allowed to use xp_cmdshell.  Is there any other way to do this?

<div>
If you are using 2005 you could write some CLR procedures that move the file for you. &nbsp;
</div>


If you are using 2005 you could write some CLR procedures that move the file for you.  

<div>
could you give an example for clr procedure for my case?
</div>


could you give an example for clr procedure for my case?

<div>
If we disregard the fact that I need to do this via sql server, how would the commands look if I would just do it in DOS directly?
</div>


If we disregard the fact that I need to do this via sql server, how would the commands look if I would just do it in DOS directly?

<div>
copy c:\moveme.txt c:\tracefiles\moveme.txt<br />
<br />
or <br />
<br />
move c:\moveme.txt c:\tracefiles\moveme.txt
</div>


copy c:\moveme.txt c:\tracefiles\moveme.txt

or

move c:\moveme.txt c:\tracefiles\moveme.txt

<div>
I should clarify when we move then rename the file to include the date when the file was copied/moved, so:<br />
<br />
<br />
move c:\moveme.txt c:\tracefiles\moveme022120<wbr />08.txt
</div>


I should clarify when we move then rename the file to include the date when the file was copied/moved, so:


move c:\moveme.txt c:\tracefiles\moveme02212008.txt

<div>
Is it OK to write the date out to a different file?<br />

</div>


Is it OK to write the date out to a different file?


<div>
not sure what you mean, can you give an example?
</div>


not sure what you mean, can you give an example?

<div>
I get this error:<br />
<br />
syntax of the command is incorrect
</div>


I get this error:

syntax of the command is incorrect

<div>
I did this in dos using your command above, there is nothing else I can provide.
</div>


I did this in dos using your command above, there is nothing else I can provide.

<div>
did you swap out the file names for a file on your c drive? &nbsp;Did you make sure you typed out all the little ~ and % characters correctly?<br />

</div>


did you swap out the file names for a file on your c drive?  Did you make sure you typed out all the little ~ and % characters correctly?


<div>
yes, and I will double check - this works on your computer?
</div>


yes, and I will double check - this works on your computer?

<div>
after double-checking it worked. thanks!!
</div>


after double-checking it worked. thanks!!

<div>
<div class="content wysiwyg-content">
How does one add a move and copy file dos command to a sql server job? &nbsp;And how does it record the date/time of the copy and move of the file?
</div>
</div>


How does one add a move and copy file dos command to a sql server job?  And how does it record the date/time of the copy and move of the file?

SQL Server 2005 job: move and copy file in DOS

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft Disk Operating System (MS-DOS) was an operating system for x86-based personal computers, and traces of it are still found in the Windows operating system. DOS is still used in some embedded systems and for certain legacy 16-bit networks.