February 11, 2009 at 5:37 pm
Hi All,
I've had this DTS package running like a dream for donkeys years. This morning i was told that the xls files that we export to are blank. So i decided to run the DTS manually thinking that it was the job that failed. At first glances it seem to had worked all the showed that completed successfully, but i noticed that even thou its been completed no records had been export to all the xls, only some files where populated. I then check if the DTS package had been modified, which it hasn't. I then checked the permissions on the files and they have not changed and are identical. SO i checked the sql statement that builds the record set and that is fine. So then i checked the destination, confirming that it is connecting to the right xls file and that column heading reflect the destination heading and they do. So now i'm at a dead end, i have a dts that tells me its working, but its not! IS there any way for me to debug this???
Cheers
Remember
Without Change something sleeps inside of us that seldom awakens, the sleeper must awaken!!
February 12, 2009 at 5:15 pm
What I like to do is open the package in DTS Designer and execute each step individually. Since it seems to export data to some of the .xls files, I'd concentrate on the ones that export to the empty files.
Before doing any of this, enable package logging and enable logging on the tasks if you're using Transform Data tasks.
Greg
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply