Are you using PIVOT or COALESCE in your code to generate the column names?

I ask because the closest thing I've got to what you're doing sets a variable using COALESCE...

<snicker> Today's Sandra and Woo[/url] offers a reversal of the Dilbert paradigm.

Last post until I get more info from you on how you're dynamically generating your column names (code sample?) from the database.

Looks like there was an article on SSC for...

WayneS (10/27/2010)

---

3. Execute SQL task (connected to a SQL Server) runs a query with dynamic column names (based on the year being executed for). The results are stored in a...

Jez,

So you'd be doing this manually instead of scheduled as an automatic job?

Have you tried the Import / Export Wizard? It can import flat files.

Ivan, that's okay. Just please don't use text-speak like "u" and "r" in these forums....

Nope. That's a different, separate thing. You can dynamically create the file, and all its...

Odd. When I do a "SELECT current_timestamp, GetDate()", I get the exact same values. So I'm not getting the point about readability.

crystal

How much of a performance hit do styles put on the server?

Dynamic name can be done either via script or via a Variable set as "Evaluate as Expression".

Using the File Connection (not the Flat File Connection), you can dynamically create...

Look in the upper left hand sidebar. "Write For Us" has all the details. You'll have to click through...

Steve Jones - SSC Editor (10/27/2010)

---

I wonder if any of you would be interested in writing to fill holes? I keep finding posts here, and elsewhere that someone answers a...

OMG, someone grab the paramedics. Steve's going into shock because he...

Read my edit. Your punctuation use (. instead of ?) at the end made it sound like a statement, not a question. I thought you were telling us there were...