This is normally to do with permissions on the folders where the packages are deployed to. The following steps has resolved the same issue for me.
1. Create a new windows account on the server. This account will execute the packages
2. Open The SQL Management Studio. Database Engine
3...
I am using a ForEach loop to process text files into different tables. I use a script task to direct the processing to different data flows (depending on the file name) After the data flow is completed, I use a File System task to move the file to another location. I want to use the same File...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.