Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
aestima
Starting Member
10 Posts |
 Posted - 2014-06-25 : 09:39:33
|
| Hello Guys, I have an activity that was created using SSIS 2008 R2, which consists of copying a file from a server within the network to a server that is outside the network DMZ. The design is as follows I have SSIS server, the server A on the internal network and server B in the DMZ. There is a SSIS package that is in the SSIS server creates the file in the server and copy that server to server B (DMZ). When he is in design mode (C server) it works correctly, but when I install the SSIS server and set a job to run the package generates the following error: The file name "\\server B\\TransferenciaArquivoSSIS\ Export_File_Destino.txt" specified in the connection was not valid. Could anyone help in this case, what is happening can? Thanks for listening, Antonio |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-06-25 : 12:45:21
|
| Your error message shows the path has an extra slash and an extra space. Is that just a typo when posting on here? Log into the SSIS server using the SQL Server service account and copy/paste that path and file name into Start..Run. Hit enter and see if the file opens. If it doesn't, then the path is likely bad or a permissions issue.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
aestima
Starting Member
10 Posts |
Posted - 2014-06-25 : 13:31:07
|
| Sorry I made a mistake when typing, but the correct is "\\server B\TransferenciaArquivoSSIS\ Export_File_Destino.txt" |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-06-25 : 13:35:46
|
| What about the extra space before Export? After the last slash, there's a space. Should it be there? Do the steps I mentioned to verify what is wrong.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
aestima
Starting Member
10 Posts |
Posted - 2014-06-25 : 13:35:50
|
| Anyone else have any ideas that might help us? |
|
|
|
aestima
Starting Member
10 Posts |
Posted - 2014-06-25 : 13:44:57
|
| The space before Export does not exist at the time was to copy and paste.Ok?Regards,Antonio |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-06-25 : 13:51:42
|
| Please follow the steps in my first reply.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
aestima
Starting Member
10 Posts |
Posted - 2014-06-25 : 14:54:15
|
| I have followed the steps, in fact the service user was not connecting. I tried to run the net use mapping to see if SSIS could access. The domain/account can, but when I run the job the same error happens. |
|
|
|
|
|
|
|
|
Copy a file from a server on the internal network