December 20, 2011 at 11:15 pm
Hello All,
In this i have two task to be done. I have to export data from a excel 2007 to Table in sql server 2008. the excel has drop down list where user has selected the values. this export to table can be achieved with out any problem.
But the same vice versa like from table to excel 2007 where i need to maintain the same drop down options in the excel. Can you please guide me on this. thanks.
December 21, 2011 at 1:23 am
That won't be (easily) possible with SSIS. SSIS just dumps the data in the Excel file.
Maybe if you create an empty sheet with the dropdown already present and SSIS just fills up the individual cell, that might work.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 21, 2011 at 1:25 am
Thanks I will work as such. Thanks for your help
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply