Hi George,

In Script Task click on Design Script and Add the Following:

Imports System

Imports System.Data

Imports System.Math

Imports Microsoft.SqlServer.Dts.Runtime

Imports System.Data.OleDb

Imports System.IO

Public Class ScriptMain

' The execution engine calls this method when the task executes.

'...

Thanks Carolyn,

what a brilliant Article.

i however have modified it a bit to use WinRar and so far it works perfectly.

hi,

this is my command line:

/DTS "\MSDB\LandRoverDailyPartPricesAudit" /SERVER server name /CONNECTION "server IP.DB Name";"\"Data Source=Server IP;Initial Catalog=DB Name;Provider=SQLNCLI.1;Integrated Security=SSPI;Auto Translate=False;\"" /CONNECTION "Excel Connection Manager";"\"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=R:\LRPartPricesAudit.xls;Extended Properties=""EXCEL 8.0;HDR=YES"";\"" /CONNECTION "LRPartPricesAudit.xls";"R:\LRDocs\LRPartPricesAudit.xls" /CONNECTION...

good day all,

could someone please help me in order to overwrite excel files in SSIS Packages?