When we copy a big file from a server to a remote location (NAS drive or something) through ssis,there comes a network connection unavailable error.
To fix this go to my computer and map a network drive .Add that remote drive.Now the job willl execute properly through SSIS.
Executing a package is easy but running a job from sql server gives error.To resolve that
|
Use the UNC path when specifying the destination-- the SQL Agent doesn't have a concept of "mapped" "drives".
Also, SQL Agent typically runs as "Local Service" or "Local System"
and, as such, doesn't have rights to remote shares on other computers.
You have a couple of choices:
- Run SQL Agent as a role account in the domain. Grant that account
permission to write to the directory / share where you'd like the
backups stored.
- Run SQL Agent as "Network Service". It will authenticate to the
sharing server with the domain computer account of the machine the
service is running on. Grant that account permission to write to the
directory / share where you'd like the backup stored.
- If you don't have a domain, create an account with the same
username and password on both the machine hosting SQL Agent and the
machine hosting the backup files. Change SQL Agent to run as this "role"
account, and grant that account permission to write to the directory /
share where you'd like the backup stored. (The "poor man's domain"...)
-
-
- or else create a batch file pkgexec.bat having "C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\dtexec.exe" /file c:\SceneVisitReports.dtsx and schedule in windows task manager c:\>pkgexec.bat
|
No comments:
Post a Comment