sql server - SSIS Permission Issue Flat Files -
Recently I took my files to a new SSIS server when I try to execute a bulk listing Everything is working, it tells me
(can not be loaded because the file "e: \ flatfiles \ SSG \ apmast.txt" can not be opened operating system error Code 21 (Device not ready.). ".
This does for all my successful files. One is saying that you need to give full control to the MSSQLSERVER user, which I did but it does not seem to fix this. Thanks.
I understand that, it is found that to put a bulk, the server asks to look at the locally text file. I have a SSIS from a server Servers on large servers and another server on another server in SQL Server Not put each other trying to SQL. As soon as I Flatfail on a remote server, I grabbed it and used it. Oddly enough to work, I expect the files to be pushed on the SQL server rather than asking the SQL Server for files locally via hard drive.
Comments
Post a Comment