February 7, 2007 at 6:53 pm
Hi all,
I have DTS package which will export into multiple export files based on products. Here sales relating to multiple products are present in a single table and I have multiple transformations with thier product code, which will export data into export file. When I run this job when DTS package is open, it run perfectly, but when I run as a job, few export file will not have any rows at all eventhough records are present for that product.
I appreciate any information relating to this problem. Thanks in advance.
February 9, 2007 at 2:37 pm
Are you logging the package? You can look at the package log to see if perhaps there are errors with some of the steps.
Russel Loski, MCSE Business Intelligence, Data Platform
February 11, 2007 at 3:29 pm
Yes, I am logging the package. But no steps reports with any errors at all?
February 15, 2007 at 5:35 pm
I am not too certain when you said "few export file will not have any rows at all" in the original message by Mohan. Does this mean the job created the export file but did not include the result OR the job did not even create the export file???
According to my experience my job did not create the export file even if direct DTS execution successfully created the file. If this is the case for you, then this may be the issue with SQL-Agent login. When a job is running, the job is running under SQL-Agent login credential. Therefore the target export file location(perhaps in a shared directory in shared server) should have permission for SQL-Agent login(this is an NT login). If the SQL-Agent login does not have the required permission to create a file, then the job fails. And I remember that the job did not fail??? But worthwhile to check it again with your system administrator for the SQL-Agent login.
February 18, 2007 at 9:20 pm
In fact, I just added NOLOCK and seems to be working fine. Thanks all.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply