I have a package in SSIS which in a first step executes these two queries:
truncate table mytable;
insert into mytable
select * from myview
Then, a second step read data from view that takes data from mytable in join with other tables, and writes all the data into a csv file.
The job has never given me any problems, in the last three days however the csv file that is written only contains the header row with the name of the fields. I specify that the job also does not fail, the execution is successful.
The csv file that is written is very bih, about 1.5 gb as I have to upload it to an application that requires the entire data history each time it is loaded so I cannot remove any data by appying a filter before write the file.
Can you help me?
I've tried to change the timeout options of the first step to 300 seconds (it was 0), the exported file is still empty.
Then I tried to change the contraint option in the connection between the first and the second step It was "Success" I tried with "Completion". File still empty.
