issues exporting stored proc results to excel

[scabral79]

Hi,

i created a DTS package that uses a data transformation task to call a stored proc and then writes the results out to an excel spreadsheet.

However, on the destination tab, i keep getting NewTable in the table name dropdonw, but i really want it to say Sheet$1 instead, since it's going to excel.

When i try to run the dts package, it tells me it can't find NewTable. The next step folloiwng the tranformation is an excel connection to a server.

Any ideas what i might be doing wrong?

scott

[mattyblah]

does the excel spreadsheet exist? you need to use whatever the sheet name is on the spreadsheet. so, if you worsheet is name "hello" you need to select the "hello" table in the dts. hope that makes sense.