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 |
|
archana23
Yak Posting Veteran
89 Posts |
 Posted - 2015-03-24 : 14:19:33
|
| Hi,I am new to developing SSIS packages . I have OLEDB Source Editor , I have selected SQL Command as Data access mode and provided SQL query in SQL command text. when I click on Preview button I am getting below error saying"Error at Data Flow Task : No Column information was returned by the SQL Command"Can you please help me on this.Thanks,Archana |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2015-03-24 : 14:36:00
|
| Is the query using a temp table? Show us the query.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
archana23
Yak Posting Veteran
89 Posts |
Posted - 2015-03-24 : 15:27:28
|
| Yes we are using some of Temp tables too.. query is too long almost 700 lines. Unable provide query here...What could be the problem?Thanks,Archana |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
No Column info was returned by the SQL Command