Data move from server to Shared path

• yuvipoy

  SSChampion

  Points: 10469

  More actions

  February 17, 2015 at 10:04 pm

  #297844

  Hi,

  I would like to know the ways of move data from one server to another server.

  Two cases are there :

  2 in bound files are there one is coming from database and another from data path in physical drive

  Package needs to be check these two cases

  P1--> Database movement from one server to shared path

  P2--> Move a data which is on my physical path to shared path.(it is pdf file)

  Please share the suggestions on this.

  Thanks!!

• SQL.AP

  Hall of Fame

  Points: 3244

  More actions

  February 24, 2015 at 3:52 am

  #1779524

  Use script task in SSIS to check availability of files. Or use two foreach loops.

  Then use File system task to copy / move these files to your shared path.

  ____________________________________________________________

  AP