Copy files onto other server using for each loop in SSIS
Hello Everyone, I have designed a package which can copy multiple files with different file formats on local server but i want this to be done on different server. When I create new connection and pass the address of another server i got an error but when I run the same address in run window its showed me location I dont know what went wrong. Could anyone who knows how to do this please, let me know. Thanks.
July 6th, 2011 6:37am

When you gave the location in run were you prompted for authentication if so then tick the remember password and it should work other wise give write rights for that path to the user through which the package is being executed-------------------------------------------------------- Surender Singh Bhadauria
Free Windows Admin Tool Kit Click here and download it now
July 6th, 2011 6:50am

Providing the error message might be useful.http://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me
July 6th, 2011 7:40am

Ok, i think the reason for Error is, cannot write to the destination location, the reason in such a case would be the user account access. 1) Assume you are running the package via a SQL agent job, in this case the service with which integration service is started on the other server needs to have access to the diretory where you are trying to write the file to. Abhinav
Free Windows Admin Tool Kit Click here and download it now
July 6th, 2011 10:42am

The following article is related to the topic: How to: Automate SSIS Package Execution by Using the SQL Server Agent (SQL Server Video)Kalman Toth, SQL Server & Business Intelligence Training; sqlusa.com
July 8th, 2011 1:11pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics