I would like to move/copy some files between two SQL servers. The files are consist of .css .png .jpg and .gif files. I've tried to do this using the File System Task but I can't for the life of me work out how I point it to the servers file
system. I'm obviously not an SSIS guru, I had a play and can move files around my own PC from location to location, but can work out my server to server issue, I hope someone can help, or at least point me in the right direction.
I'm going from SQL2005 to SQL2008 if that makes any difference, but as I say its not SQL tables, data, or what not, it's simply moving files that happen to be stored on the two servers.
Thanks in advance
View Complete Post