Hi,
Not really... in DTS you can use one source multiple times in column destinations.
With BCP task you can skip first row and determine how many rows you need to import.
With CAST or CONVERT function you can convert different data types to the type you have in you table.
JFB