I programmed a Source extension, that accesss a text file. In my code I have the following code to open a file:
protected override void reader(PipelineBuffer buffer)
{
TextReader reader = File.OpenText(_filename);
The komponnet works well. How do I grant permissions to access this text file? Because I got problems when I try to run my package using a task created in the SQL Server Agent.
This sounds like a how do I use windows file security question, not a SSIS issue at all. Simple, use Windows Explorer, and select the drive, folder or file and right-click to access the security tab. Is that really what you are asking?
Have you determined the security context (account) used by SQL Agent? You will of course need to do this to grant that account with the correct permissions.
This also seems unrelated to the component used.
|||I coudn't access the resources. I used the following \\server\share
And it works!
No comments:
Post a Comment