Q
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.

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.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close