Have you thought about calling the dts package from vba and sending in the parameters you want to be dynamic.

You can give your users a locked down front end...

Thanks for the correction, Hans. I never knew there was a difference. Have to extend my reading material.

0 and 100% are the exact same.

If you have any tables regularly insered, updated and deleted you should be looking at the range of 70 - 90%.

Start at a...

In the past I have found a quicker way is to use exists:

DELETE FROM tbl_Parent

WHERE NOT EXISTS (

SELECT ParentID

FROM tbl_Child

WHERE tbl_Parent.ParentID = tbl_Child.ParentID )

Glad it helped. I have had the same sort of error messages for a couple of dts jobs in the last month all down to conflicting permissions.

The error message is screaming permission problems.

Check that the account that sql server is running under can select from table A and insert into table B.

If this works, divide the...

Glad to hear it works.

I hate to sound patronising, but somehow your truncate table is not working.

Check the connection to make sure you are truncating the table from the right database. Try running the...

Something else to realise is that if you have a char(20) column and do not use all twenty characters, you are wasting disk space.

Varchar will only only use up the...

Check the following:

1. Make sure the account that the sql server agent is running under has sufficient priveleges to perform the dts task.

2. Make sure any paths to files are...

I have tried all the above and none of them work for me.

PLEASE IGNORE THIS THREAD.

I finally spotted that the batch file I was calling did not go through a mapped drive. I used the full path via server name.

I was concentrating...

Try dropping all the indexes apart from the index in the query. This should then reduce the transaction log size considerably. Then put the index back on and dbcc reindex....

The answer to 1 would be to look for a good dts book.

The answer to 2 is to use an activex script. You can set source and destination fields dynamically...

I cannot see how this can be done from table to table. You are relying on the dts package knowing which fields to join for starters. If you wanted to...