jobrien9796 (9/6/2013)
I should clarify the original problem a bit here: The query i had as an example just pulled from a table. What I am looking for is something I could apply to an arbitrary query. I think there has to be something like this in SQL Server because SSIS has to figure out datatypes and column names for the dataflow task.Thanks in advance!
Yes this type of metadata is stored in sys.columns. Take a look at the second example I posted.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/