SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Copy a file from a server on the internal network
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

aestima
Starting Member

10 Posts

Posted - 06/25/2014 :  09:39:33  Show Profile  Reply with Quote
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

USA
37157 Posts

Posted - 06/25/2014 :  12:45:21  Show Profile  Visit tkizer's Homepage  Reply with Quote
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 - 06/25/2014 :  13:31:07  Show Profile  Reply with Quote
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

USA
37157 Posts

Posted - 06/25/2014 :  13:35:46  Show Profile  Visit tkizer's Homepage  Reply with Quote
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 - 06/25/2014 :  13:35:50  Show Profile  Reply with Quote
Anyone else have any ideas that might help us?
Go to Top of Page

aestima
Starting Member

10 Posts

Posted - 06/25/2014 :  13:44:57  Show Profile  Reply with Quote
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

USA
37157 Posts

Posted - 06/25/2014 :  13:51:42  Show Profile  Visit tkizer's Homepage  Reply with Quote
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 - 06/25/2014 :  14:54:15  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000