If you are using a transformation to fill your spreadsheet:

Create an Excel template that you always use for the destination. (Just the field names on the worksheet.) 

Upstream of the transform,...

Go back to your dts package in design view.  Right click in the design window.  Select Package Properties, the logging tab, and then have the package execution log to your...

Here's a thought, try truncing the date in it's native language and make sure the year part is formatted as YYYY to avoid the 2000 thing (year 30 is the default - but...

This is what you need to know right here! 

http://www.sqlservercentral.com/columnists/jsack/capturingtheerrordescriptioninastoredprocedure.asp

BTW, a good rule of thumb is to store your data scrubbed and display your data formatted.  In other words, don't format your phone numbers when you import them into...

I wrote that function in t-sql for myself today, but you can do the same thing in your activeX Jess.

When you are on the transformations tab

remove your automapping

highlight areacode and...

Here's a function I just wrote to format phone numbers:

CREATE FUNCTION dbo.FormatPhone(@inphone varchar(20))

RETURNS varchar(20)

AS

BEGIN

 declare @outphone varchar(20)

 declare @ext varchar(6)

 declare @pos smallint

 --remove any non-numeric characters

 set @pos = patindex('%[^0-9]%',@inphone)

 while @pos > 0

 begin...

And don't forget about this handy little baby:

This example uses PARSENAME to return information about the authors table in the pubs database.

USE pubs

SELECT PARSENAME('pubs..authors', 1) AS 'Object Name'

SELECT PARSENAME('pubs..authors', 2)...

Forget managing this in DTS.  This is what the job scheduler already excels at!  Viewing the job history of the job makes it really easy to undertand your progess/retry status...

Not necessarily a fix for this situation, but a good reminder just the same:

After altering a stored procedure, execute with recompile.

Thanks Eric!  I have shared with my team - crediting you of course!

Hopefully at least this coverage will prompt more people to buy and read Ken's book.  I consider it to be the most valuable book on my desk at work.  It...

BTW, I was wondering if this might be helpful - can you save your DTS package as a BAS module in SQL 7?  If so, that would help you with...

Create an ExecSQL task that selects the date you want from your date table.  The date you capture should become an output parameter.  Assign the output parameter to a global...

http://www.sqldts.com/default.aspx?205,1