Hi all...

Can anyone help me in trying to truncate a table using DTS. I tried
using the "truncate table" statement in an Execute SQL task but it
failed. I dont want to use "Delete table" as I want to start my seed
at 1.

Thanks in Advance.
Sivas

Without seeing the DDL for the table all I can suggest is that you can't
use TRUNCATE TABLE on a table that is the primary key side of a
relationship, even if the foreign key side is empty.


Regards,

William D. Bartholomew
http://blog.bartholomew.id.au/

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Or maybe it's the user it's running under.

You could delete then dbcc checkident to reset the seed.


Nigel Rivett
www.nigelrivett.net

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Thank you all. Sorry about the lack of info provided and I can see that
this problem can arise from a wide varity of issues. But fortunately, in
my case, it seems to have occured due to a slight oversight on my part.

The issue was caused by me trying to run the TRUNCATE statement on an MS
ACCESS connection, instead of the SQL Server connection in my package,
like I should have. MS ACCESS does not recognise the TRUNCATE statement.
Doh!

Once again thank you all for the quick response. Much appreciated.

Sivas


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!