New answers tagged ssis
There is a way to setup the number of times to retry and to set the interval between each try inside the SQL Agent Job. Simply open the job and edit the job step. Click on advanced link. Once there, you can set the retry attemps and retry interval see below. You can also setup the package to restart from the point of failure. I have not done that personally ...
Figured it out shortly after posting. Although SSIS doesn't allow you to delete the error columns in the error output of the first insert, it does allow you to change the names. I was able to modify the names of these columns and then the Union does not throw any errors as the names are not in conflict anymore.
If your SSIS package runs with the appropriate file system permissions, you can create a template Excel file with the desired formatting and copy that file to a new one (using a file system or script task) where the data will be exported. If the sheet will contain a variable number of cells that must be formatted, you can use conditional formatting in the ...
Run the installer again. Installing/Configuring SSIS and SSRS to existing SQL Server 2008 database services Run SQL Server setup program and on the “Feature Selection” page click the checkboxes associated with the features you would like to have installed. When finish, reapply any service pack the instance have applied before.
Top 50 recent answers are included