Copy files onto other server using for each loop in SSIS

• bhushan_juare

  Ten Centuries

  Points: 1292

  More actions

  July 6, 2011 at 4:41 am

  #145588

  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.

• rene-500237

  Hall of Fame

  Points: 3769

  More actions

  July 6, 2011 at 5:08 am

  #1348835

  Hi,

  it has maybe to do with access rights (Share level and file level).

  Have you checked that the SQL user account has sufficent rights?

  Regards,

  Rene