July 21, 2004 at 2:10 pm
When I use the DTS wizard to export a table to a text file using fixed length format with column heading, the dates are exported with the full format like this: 2004-07-21 10:59:00 and the transform task shows size of 25.
When I use the DTS designer to export the same table to a text file using fixed length format and column heading, the date format is truncated like this: 2004-07-21 00:00 and the Transform Task shows size of 16.
There are also differences in sizes for decimal, integer and float between DTS Wizard and DTS Designer. The Wizard results are accurate while the DTS Designer results are not.
Any ideas?
July 26, 2004 at 8:00 am
This was removed by the editor as SPAM
July 27, 2004 at 11:21 am
For the DTS Designer try using DateTime String as the type of transformation as opposed to Copy Column. It should work. Using the DTS designer is more flexible but it does mean you may have to specifically chose transformations and other options.
Francis
July 28, 2004 at 9:11 am
Yes, thanks. I understand that I can edit the transformations for individual columns but what I wanted was to match the settings that the wizard uses for datetime, decimal, int, etc as an automatic transformation. I don't understand why in DTS designer it would transform a datetime to char(16) which truncates the date, when the wizard properly transforms datetime to char(25). I am looking for a global setting in DTS designer that would manage this if there is one, instead of having to edit each transformation manually.
July 28, 2004 at 9:35 am
I agree with you that the difference in behave of DTS designer vs. the wizard is odd. Maybe its fixed in SQL Server 2005. It may be worth checkm out in the beta. For the current version I'm not aware of any global setting that will change this behaviour. I'd be interested if anyone else has a more complete response.
Francis
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply