Here's how you can execute a DTS package from a stored procedure. Look up dtsrun utility in the Books Online for more information on the switches.

EXEC master.dbo.xp_cmdshell 'DTSRUN /S...

Replace the Copy Column data transformation with a Date Time String transformation.

On the General tab of this transformation type's details, click the Properties button and enter the date...

VBScript doesn't support mulit-line comment blocks. You're going to have to treat each line as a single-line comment.

Instead of using a Copy Column transformation, use an ActiveXScript transformation. Click on the properties button of this new transformation to edit the code. Enter something similar...

There are a few different ways you can do this.

If the DTS package is executed via a SQL job, you can use the logging features of the job step. ...

Sounds to me like either you're not executing the loop correctly or the CountryCode global variable value isn't being updated like you expect to be.

How is CountryCode being populated and...

Read this:

http://www.sqlservercentral.com/Forums/Topic330600-5-1.aspx

Here's the official word, straight from the horse's mouth:

http://support.microsoft.com/kb/810927

Yes, it's possible. You'll need to have global variables set up in your DTS package and use the DTSRUN utility to pass values to those global variables Look up...

The InsertFailureMain function isn't being called because you have the Fast Load option enabled.

Go to the Options tab of the transformation task properties window, and uncheck 'Use Fast...

Simply add another Data Transformation task to your DTS package after your SQL task. The source of the tranformation would be your SQL Server and the destination would...

Add an Active X Script task before your Data Transformation task that does the following:

1) Disable the Data Transformation task

2) Uses the FileSystemObject to determine if the file...

That is the very reason why I don't use the lousy FTP task. Instead, I create an Active X Script task that executes a shell command to download the...

You can't execute a TRUNCATE TABLE command from a different server.

Here are 2 workarounds:

1) Add a SQL connection object to your DTS package that points to the server/database that...

You're trying to execute a SQL Server stored procedure in an Execute SQL Task where the connection is an Access database? That's not going to work.

Here's one way...