Do not know if this is the right place for this question but maybe someone can direct me. I am using the SQL Agent to create a job that takes a created text file and copies it to a network drive. If I run the package I created to do this in SSIS the job runs fine but if I try to run it with in a job it errors out. I believe this is because you have to add the network drive so SQL Server Management Studio recognizes it. Does anyone know how to add a network drive to SSMS? I have looked online and found no step by step instruction.
Thanks!!