April 10, 2009 at 4:49 am
I'm running a Bulk Insert script from an AppServer to insert into a DBServer. The filepath for the files is UNC, and it works on both servers if copied in explorer. The AppServer holds the SSIS packages and the files to import, the DBServer holds just the database.
When I use to setup above I get an error "file does not exist"
When I refer to a database on the AppServer itself instead of the DBServer, everything runs fine!
I think I checked all permissions, everything seems to look like it should. Strange thing is that the files that have to be imported are on the same server as the SSIS packages, so right/permissions shouldn't be a problem?
help appreciated!
April 10, 2009 at 5:33 am
Has the account that launches the ssis package been granted read authority on your UNC path / file ?
(service account of sqlagent or proxy account of the sql jobstep that launches dtexec)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
April 10, 2009 at 5:56 am
ALZDBA (4/10/2009)
Has the account that launches the ssis package been granted read authority on your UNC path / file ?(service account of sqlagent or proxy account of the sql jobstep that launches dtexec)
Yes, It has all the necessary authorisations. Also, it's on the same server as the SSIS packages.
April 10, 2009 at 6:06 am
you may want to try it out by logging on to your server that launches the ssis package and using that service account (or proxy).
Then try to use the unc path in explorer and see if it works.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
May 6, 2009 at 11:37 am
Bulk Insert only works on "local". If you run on SERVER, your SSIS has to be in that SERVER.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply