0
I have a process in SSIS that takes information from a table and exports it to an xlsx file. It happens that, when running Job by SQL Server Agent, often the file is generated blank, even if it has content in the table (it is not always that this happens). When this happens I open the SSIS and roll in my hand, and the file comes filled in properly. I wonder what could be causing this? In Data Flow Task I have a data Conversion between Data Source and Excel Destination, which converts the lines to String, but I didn’t see anything wrong with this task either. Someone’s been through something like this?
Hello Paul, have you ever imported DTS into SSIS again ? Is it when you "wheel in hand" isn’t running a different version than the one in SSIS ?
– Ricardo Souza
Ricardo, I run the SSIS Solution itself... it’s the same DTS that Job is pointing to.
– Paulo Felicio