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.
| Author |
Topic |
|
Jayam.cnu
Starting Member
45 Posts |
 Posted - 2012-08-14 : 06:59:09
|
| Hi,I've a requirement to copy the files from one Server to another Server where they exist on diff. Domains. On first Server, we've administrative privileges with Domain accounts (like 'admin'), but on second Server we don't have and moreover on that Server, two Windows Logins (Local accounts) were been created to connect & access SSMS. We should use only those two accounts in order to access anything. Please let me know, how can I proceed further to create a job to copy the files (on Daily basis).Sreenivasulu.p,Mail ID: sreenivas.puliverthi@gmail.com |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-08-14 : 07:05:05
|
| Since you need to do this only once a day, an SSIS job would probably be the most ideal. You can create SSIS packages using Visual Studio, or in this case, where you are simply copying a few tables (I assume you want to copy tables even though you said "copy the files"), you can use Import/Export Wizard. To use Import/Export Wizard, right click on the database name in SSMS Object Explorer, Tasks -> Import Data and follow through the wizard. Somewhere along the way, it will give you an option to save the package. Save the package, and you can schedule it to run every day. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-08-14 : 14:55:08
|
| If you really want to copy the files, you can use file system task in ssis------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
|
|
|
|
|
|
|
Copying Files from One Server to another