how to add multiple indexes to an access mdb using dts?

[Andrew Brill]

Hi,
I'm rebuilding a load of packages we lost (our backup didn't include the
packages!) and I'm trying to work out how we used to create the indexes on
access databases using the execute sql task within a dts package.

The following works on a connection set to an sql table but not on an access
connection (where it seems to only let you have 1 statement..

create index capvehicleid on cap_cprval(capvehicleid);
create index registrationletter on cap_cprval(registrationletter);
create index [year] on cap_cprval([year]);

So how do i send multiple statements to access or create multiple indexes in
one statement?
I know I could use more tasks but I'm sure our old packages used to do this
within one task.

Thanks,
Andrew

 

[Andrew Brill]

Got it!
'go' is the word I'm looking for.



create index capvehicleid on cap_cprval(capvehicleid);
go
create index registrationletter on cap_cprval(registrationletter);
go
create index [year] on cap_cprval([year]);
go