This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 71%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECS%3C/text%3E%3C/svg%3E)
I have a SSIS package which exports data to multiple tabs to Excel, This doesn't export full data to Excel when run from SQL Server agent on server. It is checked to run as 32 bit. I have other packages which exports data to Excel and they all work fine but less data. I have only issue with this package. The highest number of rows it exports data to the tab is 22k.
There are 6 tabs that needs to be populated.
Tried following on the server:
Connection String for Excel: Provider=Microsoft.ACE.OLEDB.12.0;Data Source=tp\Rem.xlsx;Extended Properties="EXCEL 12.0 XML;HDR=YES"; Excel Version selected on Excel destination: Excel 2007-2010
Admin had installed from this link on the server recently: microsoft.com/en-us/download/details.aspx?id=54920
On devserver, they installed 32 bit.
Please advise. Thanks!
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
Additional SQL Server features and topics not covered by specific categories
Hi @Challagundla, Sindhura (ITS),
As you said, it seems that there is no error message.
If you run the package via Visual Studio, will the data lose as well?
When you preview the excel source in the package, will it show all the data?
Hi @ZoeHui-MSFT ,
No error messages when its triggered via sqlserveragent. Sometimes it fails with unexpected termination. When the package is run via visual studio on mymachine, everything looks good. The data is loaded in all tabs and no error messages. Thank You
Hi @Challagundla, Sindhura (ITS),
Could you please re-deploy the package for a try?
Unexpected termination is a general error in agent job and is hard to narrow down.
Hi @ZoeHui-MSFT ,Thank you for your reply, I did try to redeploy and see. Any idea about why the excel sometimes doesn't export data to one tab and does to other tabs when the job succeeds? Everything works fine on my machine. Is there anything i should compare between the server and my machine to narrow down the issues? Thank You in Advance!