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

  • Thread starter Thread starter Andrew Brill
  • Start date Start date
A

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
 
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
 
Back
Top