Are you executing these packages manually?  If so, has the account you've logged on to your network been granted access to the database on the new server?

Have you tried an Active X Script task using the FileSystem object?

Does the domain user have delete permissions for the folder the file resides in?

Use an Active X Script task to determine the name of the file, check if the file exists via the FileSystem Object, & set the DataSource of your source file...

The history of a SQL job step only shows so many characters.  To get a log of everything that's happening in the step, create a step output file as follows:

1) Right-click...

Is your computer running SQL Server?   How is the data imported?  Is the data source a file or a database on the Linux server?  If it's a file, are you...

The error log will be in the path you specified in the "Error file:" text box.  Are you using a drive letter to specify the path or are you using...

Do you mean use a view as the source of a data transformation?   If so, yes.

Instead of using a delimited destination file, make it a fixed-length field file.

Double-click on the destination file object, click the Properties button, and select the Fixed field radio button.

Why not export the data to Excel?

Those common functions are supported, the problem is your use of Set.   You don't use set in cases like this.

Dim TodayDate

TodayDate = Now()

Do either of the SQL servers happen to be running under Windows 2003?

Regardless, make sure the "Script File Directory" is valid on the Copy tab of the Copy SQL Server Objects Task...

I assume you're using a data transformation task to import the contents of the Excel file.

Use a DateTime String transformation.  Open your transformation task and go to the Transformations tab.  Select...

Make sure you have a global variable in the DTS package named "@WhereClause".

Open the Execute SQL task where you're calling the stored procedure and make sure the SQL Statement looks similar...

DTS packages are stored in the msdb.dbo.sysdtspackages table. 

You can save your DTS packages as a structured storage file (.dts extension) by clicking the Package/Save As menu and selecting "Structured Storage...

Create a new DTS package and add Execute Package Tasks to execute each of your existing packages.