Re: SQLServer -> EXCEL DTS. Destination Table problem

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

After playing around for some mroe time, I found the reason for the
error.

The records are being copied to a template file (XLS) and the Workbook
name is Sheet1. When I renamed the table name at "Destination" tab to
Sheet1, the package started working fine..

This was a newbie error! Hopefully this post helps other newbies...

Thanks for the suggestions and comments...

.

Quantcast