OK. Stick it in a dts package to make it manageable and trackable.

Step 1 - use xp_cmdshell to overwrite the existing file with the new on.

Step 2 - set up...

See this article I posted a while back:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=187740#bm187760

Take a look at this article. It will help you achieve exactly what you are after. It refers to a text file, but the principle is the same.

http://www.databasejournal.com/features/mssql/article.php/3073161

Expand support services.

Right click sql mail.

Select properties.

Make sure dropdown says 'MS Exchange Server'

Click on test to make sure it works.

Also log on to the server as the account that the...

See this link.

All you have to do is save the package as a vb module. Perform the changes in the attached artile as well as changing the server name if...

Take a look at the filesystem object. You can retrieve the date and time that the file was created or modified.

That way you can store this in a table and...

Thanks for the feedback, Remi.

I seemed to have made some slightly erroneous assumptions when trying to get my point across. It reinforces the fact that you need to check every...

An easier way would be to have an extra step at the end that writes into a dummy table. You can then select the max record from this table for...

This should point you in the right direction. Well written and easy to follow:

http://www.sqldts.com/default.aspx?214

For more detailed information, check Books On Line.

For a brief answer:

DTS Packages are a way of perfroming processes (e.g. importing and exporting data in sql server). They can also peform...

Could you be a little more specific in what you are trying to achieve.

IE- Where is the coding running from (activex?)

Why don't you do a normal insert statement?

When you want to enter numbers in excel to be treated as a string you start by putting a ' in the beginning.

Whilst you do not see this when you...

It's easier if assign the variables first and use a string to execute the dtsrun line:

declare @var1 as varchar(50)

declare @var2 as varchar(50)

declare @var3 as varchar(50)

declare @var4 as varchar(50)

--set all you...

I'm all out of ideas. If all your packages are runing slowly, I would think about a reinstallation on the client that you are running the package on.

Why not use the functionality in dts. You can call that from t/sql  via xp_cmdshell