Hi,
i created a DTS package that used a data transformation task to call a stored proc and then writes it 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
i created a DTS package that used a data transformation task to call a stored proc and then writes it 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