file system copy directory from a server to anotht

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)

file system copy directory from a server to anotht

Author

Topic

sarahmfr
Posting Yak Master

214 Posts

Posted - 2011-08-08 : 20:50:58

Hi All,
I have two servers
I created an ssis package that does some tasks one of them is copying a directory from one server to another.
I as The creator of the package has the same username and password on the two servers
I mapped network drives T: for target and F: for source.
What I am doing wrong I am having error messages that it can not access the folder.
to copy a directory from one server to another
I was able to copy from F to T from windows explorer.

Thanks
Appreciate you help

sarah

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-08-09 : 00:35:13

Grant the SQL Agent service account permissions on both source and destination.

Make sure UAC is diabled.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-08-09 : 10:23:50

also make sure package protection level is set to rely on server security

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-08-09 : 10:46:31

quote:
Originally posted by visakh16

also make sure package protection level is set to rely on server security

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

good call

sarahmfr
Posting Yak Master

214 Posts

Posted - 2011-08-09 : 15:12:46

thanks
but the the two folders are on servers different from the sql server

sarah

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-08-09 : 20:40:59

Make sure the SQL Agent account has permissions then

sarahmfr
Posting Yak Master

214 Posts

Posted - 2011-08-09 : 23:36:28