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 |
|
mrmkhokhar
Starting Member
7 Posts |
 Posted - 2011-01-27 : 05:08:24
|
| I can see the preview of data of given query by sql command in OLE Source but Columns list comes as blank. Data is coming from Sybase. any solutions?ETL/Database Developer |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2011-01-27 : 07:49:53
|
Do you mean the column name is blank? or no data is being returned?WE can't possibly answer this question without seeing some more info..perhaps your query?
Poor planning on your part does not constitute an emergency on my part. |
 |
|
|
mrmkhokhar
Starting Member
7 Posts |
Posted - 2011-01-27 : 08:27:03
|
| Data is being returned when I preview but in columns it does not show even a single column. (all blank)ETL/Database Developer |
|
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2011-01-27 : 17:11:12
|
so you see data in the columns during preview, but not afer execution? is this a straight data flow?are you previewing the data in the dataflow connection? or in the Source connection definitions?
Poor planning on your part does not constitute an emergency on my part. |
|
|
|
mrmkhokhar
Starting Member
7 Posts |
Posted - 2011-01-30 : 08:17:50
|
| Problem resolved by spliting the query into parts.Actually derived columns were creating problem while data access. I moved the derived data into Staging area.ETL/Database Developer |
|
|
|
|
|
|
OLE DB Source and Columns