Wednesday, March 21, 2012

Files not creating on Win2003

I have created a package which extracts data from a table and creates several files. This works fine on my PC (WinXP SP2), but when i deploy it to the server it doesn't work. I have also tried to create the package from scratch on the server as the administrator and it still has the same problem. Anyone have any ideas?"it doesn't work" is not much to diagnose the problem. Are you getting any error? Have you enabled SSIS logging - what logging information are you getting?|||You haven't provided a lot of information here, but the first thing to check is permissions on the folder you are writing to.|||Sorry Michael,

"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 Sean

After 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