Hi
Could someone advise how to get this working. I am getting access denied so I need to get in user credentials into the command but cannot get any simple information anywhere. My script it this
"\\Server100\c$\Program Files\Microsoft SQL Server\100\DTS\Binn\DTExec.exe" /f "D:\SSIS Projects\Paragon Export Instructions\Exportbookinginsturctions\Exportbookinginsturctions\Package.dtsx"/SET "\Package.Variables[USER::TARGETFILEPATH].Value;"D:\\SSIS Projects\\Paragon Export Instructions\\Export_New.csv"
When I run this I get access denied, it works if run from the server but when run from my computer I get access denied. I know the Admin and username passwords I just don't know how to apply it to the code. Could someone help please. By the way I have copied code from the Internet, I am not that up on the coding.
Thanks
Could someone advise how to get this working. I am getting access denied so I need to get in user credentials into the command but cannot get any simple information anywhere. My script it this
"\\Server100\c$\Program Files\Microsoft SQL Server\100\DTS\Binn\DTExec.exe" /f "D:\SSIS Projects\Paragon Export Instructions\Exportbookinginsturctions\Exportbookinginsturctions\Package.dtsx"/SET "\Package.Variables[USER::TARGETFILEPATH].Value;"D:\\SSIS Projects\\Paragon Export Instructions\\Export_New.csv"
When I run this I get access denied, it works if run from the server but when run from my computer I get access denied. I know the Admin and username passwords I just don't know how to apply it to the code. Could someone help please. By the way I have copied code from the Internet, I am not that up on the coding.
Thanks