![]() as i have not checked any exceptions in the article. you need to have some files in the source filepath and destination filepath for comparing. I think that the filepath (C:\Source) which you have specified does not exist. The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.īelow are the sample of MyFiles that I am getting. Run the RECONFIGURE statement to install. Run the RECONFIGURE statement to install.Ĭonfiguration option 'xp_cmdshell' changed from 1 to 1. I tried the codes, it worked but get stucked in the datetime conversion problem as below:Ĭonfiguration option 'show advanced options' changed from 1 to 1. I like to do that so I can compare the attributes of those two files against another XML file that I created/exported after running a SQL query. #Xcopy to compare folders codeWhat changes do I need to make to the code so that I would be able to store those files in a directory on my drive. Are those two files stored on a Temp Table or on a drive? In your example , as shown in your pics, the MakeXML stored procedure would return two XML files for the Source and Destination folder. The ‘NewFiles' folder one by one using the DOS xcopy command.Īfter the two stored procedures have been created the code is executed as follows: The output of this is put into a Cursor so that such files are then copied to
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |