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.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Copy a file from a server on the internal network

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 Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

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"
Go to Top of Page

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 Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

aestima
Starting Member

10 Posts

Posted - 2014-06-25 : 13:35:50
Anyone else have any ideas that might help us?
Go to Top of Page

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
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-06-25 : 13:51:42
Please follow the steps in my first reply.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

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.
Go to Top of Page
   

- Advertisement -