SQL Stored Procedure and Triggers

[webdev]

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...