Hi

I have never run this code...But try putting it in a vb6 application....But remember to put it in a sub or function;

Private Sub TestScript

End sub

Hi

Does this happen when you schedule the DTS package as a job and when you execute it when you are in the designer?

Mike

Hi

Is this what you are looking for;

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql_analservbp.asp

The following VB code snippet shells out to execute the MSMDARCH command. There is no return code; check the error log file...

Hi Jeffry

I have having touble posting the stored procedure. I can email it to you and you can post it on the site...

Regards Michael

Hi

Can't help you with the send mail task...But I have a stored procedure that sends mail through smtp and returns if the mail was sent...as far as the smtp server....Would...

Hi

Is it possible for you to try another ODBC driver? What you can also try is put a trace on the odbc driver and see what it out puts, you...

Hi

We do the following we pull the source data into a transformation...

Hi

I would suggest that you get on the server (log on the server) then try each step and should each step run correctly then schedule your job and it should...

Hi

Is it possible for you to speak to the vendor to allow you to make use of physical tables as temporary tables?

Do you need to run some types of queries...

Hi

As far as I know no…But its sounds like you need to...

Hi

It also takes time to get forums up and running. Over time who knows this might be your top Datawarehouse Forum.

So lets all try and participate.

Mike

Hi

I have done a bit more research into this problem and on this particular DB we took the decision to shrink the LDF files due to the type of back...

Hi

Have you taken a look at

 IDENT_CURRENT('Datasets')

Which will return the Identity for a table?

Mike

Hi

Thanks for the effort but the query does not seem to work..I have foung another way of getting what I wanted.

Thanks

Michael