Export a dynamic table

[gcole]

I need to export a table that has columns that constantly change. This table is created through an SP. DTS is giving me a problem as it wants the Transformations mapped. BCP also needs a format file. Any ideas?

 

[SQLSister]

This is one of the reasons why it is a bad idea to create a process that requires table changes on a constant basis. I know of no way to do the export except to recreate the export every time you want to run it in this case. How else would it know what data goes where?

Questions about posting. See faq183-874

 

[gcole]

This is a case where it had to be done and the user runs the ap that does it. In FoxPro, you could just dump the table out to a file type. I was hoping for something like that here.