Problem solve Get help with specific problems with your technologies, process and projects.

Trouble seeing source fields

SQL Server Development expert Greg Low offers a suggestion about invisible source fields.

I have created two connections then (in 2003) and then in the Transform Data Task Properties, entered a big query, went to the Transformations tab and had all of my correct destination fields but no source fields?

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.

I have not seen this happen. Have you selected the source connection in the drop-down list in the properties of the transform data task?

View questions and answers from all of our SQL Server experts here.

This was last published in March 2006

Dig Deeper on SQL-Transact SQL (T-SQL)

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.