"it doesn't work" means that the files are not being created but the rest of it executes successfully. I'm not sure how to enable SSIS logging. Can you please point me to where i can find out how?
Thanks|||Sean,
The package is deployed on a Windows 2003 Standard server, SQL Server 2005 Standard. I am writing the files to a directory on C:\ and have tried giving Everyone full control on the directory and still no files are created.
Is there anywhere else i can check for the correct permissions?
Thanks|||
In the designer, click on the SSIS menu, and then choose Logging...
Check the Event Viewer in Administrative Tools to see if there are any Security exceptions being thrown. Sorry I can't be more specific here. It's tough to know exactly what your problem is. :)
|||Thanks SeanAfter turning on the logging i have worked out what the problem was. It was a bug with my package.
Thanks everyone for your help.
No comments:
Post a Comment