Fixing SQL Script problem ( Moving a file to a folder within the scripts/or agent)
- or -
Post a project like this2625
$$
- Posted:
- Proposals: 5
- Remote
- #1421709
- Awarded
Description
Experience Level: Intermediate
General information for the website: We host customer applications
Database management system (DBMS): Microsoft SQL Server
Description of requirements/features: Help trying to run/execute SQL commands "xp_cmdshell" execute "master.sys.xp_create_subdir" which will move data from 1 table to another table within the same database( This Works) as well as picking up a file from within a folder and moving this to another folder.( doesn't work)
Extra notes: We are pushing data and a file to a SQL server, and have a trigger setup to move/ update the appropriate record within the database as well as moving the file however this fails on moving the file.
Database management system (DBMS): Microsoft SQL Server
Description of requirements/features: Help trying to run/execute SQL commands "xp_cmdshell" execute "master.sys.xp_create_subdir" which will move data from 1 table to another table within the same database( This Works) as well as picking up a file from within a folder and moving this to another folder.( doesn't work)
Extra notes: We are pushing data and a file to a SQL server, and have a trigger setup to move/ update the appropriate record within the database as well as moving the file however this fails on moving the file.
Lee W.
98% (26)Projects Completed
22
Freelancers worked with
22
Projects awarded
28%
Last project
10 Jan 2024
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Lee
Share query and error message you having? -
Can you show me the current query that you are using to copy the files from one directory to another?
290614290595
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies