Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
NickyW
Starting Member
10 Posts |
 Posted - 2003-05-14 : 11:09:21
|
| Hi All,Please help,I am trying to run a Transform Data Task importing some data from an ODBC data source to sql server.I have set up the the source and destination connections, and selected 'tranform data task'. On the 'Source' tab I enter an sql query and press 'preview' - and here's the exciting bit - it works fine! all the data is displayed without a problem. I then set up the destination tab which is again fine. However here is the problem when I go to the 'Transformation' tab the 'Source' box is completely empty!, the destination box has all the destination fields listed, but the source box is just blank.What really gets me is that the 'preview' works, so SQL server can definetly see the other database.Any help would be really appreciated (I have been stuck on this forever).Thanks,Nicky |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-05-14 : 11:53:55
|
| Are there any column names in the source?Do you have sp3 applied (on your client)?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
NickyW
Starting Member
10 Posts |
Posted - 2003-05-14 : 12:02:35
|
| Hi nr,There are column names in the data source and they appear in the 'preview'. I've also tried using "select "columnName" as x..." in the query and it hasn't helped.I do have SP3 installed.NickyEdited by - NickyW on 05/15/2003 05:20:06 |
|
|
|
|
|
|
Empty 'Source' box in 'Transform Data Task'