Hi
I'm trying to pull chunks of data from the database and export each one of them to a separate named range in an excel spreadsheet. I have the excel spread sheet formatted so I just need to export the data to it
here are the steps that I follow:
I created a named range in excel
I created the excel connection to the excel file
I created the connection that pulls data from the database
I created the transform data task that exports data from the database to Excel
then I created a SQL Task in DTS package to drop and create the table of the named range (in order to clean the data that exists already in the spreadsheet)
but this latter doesn't work properly because I create three fields as decimal and when I look in the Data Transform Task, I find that it creates a table with three fields but the first one as short not as decimal.
what could be causing this?
if this doesn't sound right, what is the best way to export data to many different named ranges in excel.
please help
Thank you in advance for your help