True true.

But we have to add in a few other columns of data as it is loading. I believe I am unable to manipulate the data as it is...

Another I idea that I have grown to love is actually not calling the packages from the page but from a Stored Proc.

I find it is much easier to call...

Start with a simple DTS from your XLS file to Table.

In the DTS select the 4 columns from the source file and the one col in the destination table, create

Create...

IF scheduling the pack is not possible I like triggering DTS from Stored Procs.

-- <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<DECLARE @objPackage int

DECLARE @PackageName varchar(128)

DECLARE @rc int

DECLARE @ServerName varchar(128)

DECLARE @DatabaseName varchar(128)

SET@PackageName = 'DTS_Example'

SET@ServerName =...

Thanks Sal,

I have done further testing on this and found:

I have a Stored proc triggering a DTS package, the package transforms a file to table, using an active x script....

Not sure how you are triggering the package. If you are calling it from a page or proc you could try this:

Try sending the file name 20030811.csv as a...

Have you tried setting the row delimiter to {lf}{cr}{lf}.

This can easilt be set when you select your csv file.

I too have the same problem with Output Global Vars

DTSGlobalVariables("strRetFileString").Value="XXXXXXXXXXXXX"

Even this simple string is not returned to the calling procedure, where as if I set this value as the default...

Thank you for the responses

I like the idea of the tickler file and will give that a try.

Cheers

Thank you all for the posts

I figured it was ust something along those lines.

Thank you

I have done some follow tests with this sp and found the following:

Both Return and Recset return if return is using a 'select count(*)...'

The Recset does not return if returning...

I guess I got hung up on the

Statements following RETURN are not executed.

But statements are executed after?

<b>RETURN</b>

Exits unconditionally from a query or procedure. RETURN is immediate and complete and can be used at any point to exit from a procedure, batch, or statement block. Statements following...

Interested in something along these lines.

Truncate table results in a syntax error when I try from an Execute SQL Task.

???

Thanks

Mark