Create text file in SQL Server via trigger and stored procedure?
Posted on 2007-12-04
I am working on migrating to a Warehouse Management System, which has an SQL Server 2005 back end
At the moment, i have an external program which creates carrier labels, based on a fixed width text file that gets produced by the current Firebird databae, via a stored procedure, called by a trigger
I need to do the same thing in SQL Server. It will be a trigger on a table update, and that trigger will call a procedure, and within that procedure the data will be formatted, padded to the appropraite widths, and then exported to a text file to a specified location
I have 2 questions..........
1. can this be done?
2. if so, how!?