The last step of the query selects columns from a global temporary table, calls a user-defined function for formatting...
on some column data,and renames them (uses the AS clause).
Why can't I see my source fields? Do I have to create another temporary file with my selected data then reference the new table from Transform Data Task properties?
Do you have an alternative.
Dig Deeper on SQL-Transact SQL (T-SQL)
Related Q&A from Greg Low
Should developers be granted permissions to production queue in a SQL Server environment? See why expert Greg Low suggests proc access by WITH ... Continue Reading
If you're working with SQL Server 2000 and trying to find a disabled index, here's something you should know. Continue Reading
Find how to save stored procedure output to the network drive via SQL Server Management Studio. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.