Thank you for the reply.

The batches are just adding and / or modifying table rows in a table.

Thank you!

Cross,

I think the error message from the sp_OAGetErrorInfo is misleading.

I do not know if you can get accurate error on what is causing the package not to fire,...

Another good trick is to have the DTS save to an exceptions file.

If the exceptions file is empty after you run it from the proc, chances are the DTS is...

What is happening in your back in your DTS?

IS your DTS firing?

Remember you might need to appropriate permissions to run your DTS package from the proc.

Turn on Profiler and to...

Thanks for the link.

Looks like we are doing just about the only way it can be done.

Thanks!

Curious,

What was it?

Are you doing an Active X?

If so you could try spliting the string on the commas into an array.

arryTemp=split(NameField,",")

Any chance to have the file better formatted before it gets to...

A thought,

I notice you are not supplying a Username / Password.

Try ommiting those 2 from the code.

I have fired a DTS from a proc many a times and I always...

Thanks Phill,

I will give the sql functions a try.

Actually they are not default values but dynami values as they need to change per user entering the data.

Thanks for all the...

Thanks once again Phill!

*****************************

Maybe you can add the current user and datetime to the tables.

*****************************

I would like to do something along this line, and I guess username, datetime data must be entered to...

Thanks Phillcart,

I am almost there.

There is just one concept I am having trouble grasping:

Insert record into staging header table

Not a problem. Pull ID created via scope_identity().

Insert records into staging detail...

Current Proccess:

1) Users upload text file via asp.

2) DTS package is triggered via proc to dts file.

3) File Header info is inserted to tHeaderTable and @@IDENTIRY returned

4) Meat of text...

Will have a Web front end enabling people to DTS text files to table. DTS Pack is being called from a stored proc.

Worthy of a try,

but problem is we might have up to 20 people hammering on this thing at a time trying to put files in.

Any issues with concurrency?