any good example of extracting data from sql server 2005 in EDI file format I need to generate EDI files from sql server


Re: EDI file output

Phil Brammer

If you know the EDI file format in question, it could be as simple as using an OLE DB Source to get your data from SQL Server and hook that up to a Flat File Destination, with its columns matching that of your file layout.

Are you familiar with SSIS at all