Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Flat File DTS
Message
From
30/06/1999 16:15:46
Robert Byrd
National Association of Homebuilders
Washington, District of Columbia, United States
 
 
General information
Forum:
Microsoft SQL Server
Category:
Import/Export
Title:
Miscellaneous
Thread ID:
00234911
Message ID:
00236142
Views:
29
>OK, I think that I'm also confused. Can we start over?
>
>-Mike

Ok.

Here is a simple example that will represent what I am trying to do.

I have a source ASCII file with two fixed length columns. The first is a date in the form YYYYMMDD and the second is a 10-character ID. I want to transform the date to MM/DD/YYYY and disregard the ID and pass the transformed date to a target ASCII file.

Obviously, this is a simplified version of my reality, but if I can understand the DTS construct to perform this, I think I can figure out the rest.

Thanks, Bob
Database Development Team
Previous
Reply
Map
View

Click here to load this message in the networking platform