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 |
|
sandesh.ravi
Posting Yak Master
110 Posts |
 Posted - 2011-10-14 : 04:59:28
|
| Hi, I have created a SSIS package that imports the file from the shared location to the database. However when the package is executed from BIDS. then the error message is displayed in the logs. "Access to the path is denied". How do I check from which account the SSIS package is executing so that I can give the access to that account.Thanks,Sandesh |
|
|
sandesh.ravi
Posting Yak Master
110 Posts |
Posted - 2011-10-14 : 05:01:27
|
| In For each loop container enumerator section where can I mention the user id and password so that the file can be accessed?Thanks,Sandesh |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-14 : 05:13:23
|
| are you executing package from BIDS? if yes, it would be executed using logged in account itself. Just check if you're able to access the path first.Also is path being retrived from variable or expression in ssis?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
sandesh.ravi
Posting Yak Master
110 Posts |
Posted - 2011-10-14 : 05:15:58
|
| Can I explicitly specify the user id and password while accessing the shared file.Thanks,Sandesh |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-14 : 05:23:06
|
| you can do that unless you pecify it in connection string. Is file server not in same domain as machine running ssis?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
sandesh.ravi
Posting Yak Master
110 Posts |
Posted - 2011-10-14 : 05:58:37
|
| Thanks issues resolved. I had requested them to give full access to the account.Thanks,Sandesh |
|
|
|
|
|
|
SSIS package to import remote file to the database