April 30, 2005 at 10:49 am
I have a DTS Package which exports selected data to named ranges on an Excel spreadsheet. The database table has several large varchar columns (each of which holds up to 2,000 characters). When I run the package, some of the data in these large columns does not make it to the Excel spreadsheet.
Has anyone experienced a similar issue? I'm not sure where to begin troubleshooting this.
“If you're not outraged at the media, you haven't been paying attention.”
April 30, 2005 at 6:32 pm
Look at the destination and make sure the field is big enough. Many times exports to excel with default to 255 characters for the field so anything larger is truncated. Just verify you task doesn't see the field as short. There can also be other reasons but right now that is the only thing that popped in to my head.
May 2, 2005 at 11:26 am
That appears to be the issue. I found this article on Microsoft Support:
http://support.microsoft.com/default.aspx?scid=kb;en-us;247527
Unfortunately, this solution only applies to delimited text files, not Excel spreadsheets. Maybe I could export to delimited file, and then write an ActiveXScript to import the delimited file into Excel.
“If you're not outraged at the media, you haven't been paying attention.”
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply