Unanswered: Sql Server 2008 r2 (Sql server agent issue)
This is for sql server 2008 r2. 64 bit system.
I created a sql server job to create a text file. It will create the text file name. But it will write a blank file. The job that is created is using the system admin account. And the job is run under system admin account.
It acts like it runs successfully. Just got a blank file.
I have tried (Package source - using ssis package store and file system) to execute the package. Still get a blank file. Either way. No error messages at all.
If I run through, Integration Services within Management studio. It runs successfully. It created the file with 20mb of data. Or running through window explorer directly, it created the file with data.
I am not sure why the sql agent does not work properly for this job. It looks like the other job has no problem.