I tested it on SQL2k SP4. The recovery mode is set to Simple.

The Rollback works and retrieves all the records.

You probably need to test again please.

Try the SQL that...

It is SQL2k and the recovery mode is set to Simple.

Thanks...

Pls explain this.

I had a truncate and an insert statement enclosed in a transaction.

QUOTE

BEGIN TRANSACTION

truncate table mastersmi2

insert into mastersmi2

select top 10 * from mastersmi

ROLLBACK TRANSACTION

UNQUOTE.

I was able to retrieve all...

You could use a stored procedure. In the stored procedure make all the SQL statements (Truncate & Import ) part of a transaction. See if that works.

Hey I am sorry, I didn't realise you are using an ActiveX script. I am such a fool.

I made you chase a ghost. There is no such property for...

Instead of "IF IsNull(v) Then"

Try using "If v = "" then"

1. Click the Package Menu

2. Select Disconnected Edit menu option

3. In the Edit All Package Properties dialog, expand the Tasks Item.

4. Under that expand, DTSTask_DTSDataPumpTask_1

5. Under that expand look for...

Never seen this error before. Are you getting this error message on Selecting Import option from the Drop Down menu?

I am not sure if this works. Try to set the value for the Command Timeout property to a huge value in the "Edit All Package Properties" diaolog box.

To navigate...

Please be a little bit more specific as to where you want to see the description.

Do a database import. Choose the Data Source Type to "Microsoft Access", select the aceess .MDB file. set the user name and paswword. Similary specify the destination to SQL server....

You can use the DTSPackage Library. The DTS Package Library exposes objects that can be invoked using VB code in Access to execute the DTS packages. Refer to SQL Books...