I have SQL Server 2000. I am trying to automate a process that runs a pivot table then exports the results to a text file. Because it's a pivot table it could have different column names every time it runs.
Does anyone know of a way to do the export in a DTS package?
When I do a straight export it always wants the column names to remain the same as when it was first set up.