Does anyone know a way to fire a trigger to launch a stored procedure after a BCP?. We have a hot folder that we would like to drop files into, then have BCP pick them up and import them. Once the file completes the import, I would like to run a few things on it like counts and field verification.
I know since I'm using an outside app to handle launching BCP when it sees a file land in the folder, I would like to minimize the interaction bewteen SQl and outside apps and keep as much of the processing inside SQL as I can.
Does BCP fire off any messages a trigger can pick up?