We are migrating SSIS from SQL 2008 to SQL2014.
- Old OS: WINDOWS 2008 R2 SP1
- New OS: WINDOWS 2012 R2
I use the
Execute Process Task to map an NFS share to a drive.
- Executable: C:\Windows\System32\net.exe
- Arguments: use Q: :/vol/
When I execute this command in a normal CMD (64bit) then it works.
When I run it from SSIS then it fails with error code "2".
After some digging I found that when I run the "net use" command from a 32bit CMD or 32bit powershell that it also fails.
So it seems to only work from 64bit.
I have googled and checked SSIS and the flag "Run64BitRuntime" is set to "True". Also the "Integration service" is installed on the new machine.
NFS Client is of course also installed.
I can't find a difference between the package on the old and the package on the new server as we copied the whole project from one server to the other one.
I hope that someone can help me to find a solution. the "net use" command is not required in the solution.
If there is another maybe better way to access the NFS share then I will try it.