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 |
|
companionz
Yak Posting Veteran
54 Posts |
 Posted - 2009-04-23 : 06:37:41
|
| Hi Guys,I tried DTS Export feature in SQL 2005 for exporting data to an excel file. Got this error:" Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Destination - Query" (19).(SQL Server Import and Export Wizard)" Someone has any idea on this?Also, can anyone help me out if i just wanted to export data into an excel file using an excel file? If yes please provide with an example BCP command.Earlier i used BCP to export data to a text file using the below bcp command:BCP dbname..table_name out abc.txt -c -t~ -UUser -PPassword -SServerNameThanks,Sourav |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Exporting data into Excel