[MSSQLServer] [DTS] How to avoid a DTS Package be reentrant

Hello.
I am designing a DTS package that should not to be executed more than two instances of this package.
Something like "If App.PrevInstance = True Then End" in Visual Basic, but I want to do the similar thing with my DTS Package, so that the same package will not be executed (just quit) in same time.
I'm wondering if I can add an ActiveX step to cope with this, to validate whether the following steps can be controlled to be executed or not.
Thank you in advance,
NokSearch SQLDTS (http://www.sqldts.com) website for any examples.

[Help]I encounter an error when using RDA

Hi All,

When my customers sync the data using RDA, they got this error message,

I don't know how to avoid it. ( I am using window mobile 5, Palm Treo 700wx, C# 2005, Sql server 2005(remote server) and Sql CE 3.0):

The OLE DB data type information in the SQL Mobile columns does not matchthe information in the SQL server columns for the RDA table (Client type=3,server type =20, Table naame =MyTable)

it's very urgent, could anyone help me out? Thanks.

James

When I search on MSDN book online, it is Server Agent Errors (value 29017), don't know the client type =3 and server type = 20 mean...

Anyone knows...

|||

Those are data type values from OLE DB:
DBTYPE_I4 = 3 (Int32)
DBTYPE_I8 = 20 (Int64)

This means you are mapping an Int32 to an Int64.

|||Thank you very much. That is what I am thinking.