Executing Snapshot from DTS

[lpeens]

Hi,

I am not sure if I am asking the question at the correct place, but is there a way to start the snapshot procedure of a replication that was set up, from a DTS package?

Regards,

Lizelle

[russell]

sure, just add an execute process task to the dts package, point it to a .cmd or .bat file with the snapshot script in it.

if u are unsure how to script the snapshot, see here (http://msdn2.microsoft.com/en-us/library/aa214018(sql.80).aspx)