Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
daviddeldave
Starting Member
28 Posts |
 Posted - 2005-10-14 : 09:02:05
|
| HiIn the Transform Data Task Properties under Transformations I want to map lots of columns from a text source to sql server. All the columns are in the format yyyymmdd. In Transformation Options I want to highlight all the fields in this format and make then available in the transformation so that they map correctly to their respective datetime fields. When choosing all these fields in "Source columns" and Destination columns and choosing OK I get an error message saying transformationdatetimestring: Must have one souce column and one destination column and each must be compatible with datetime.Both fields are the same format and I have lots of these so it would be much easier if I didnt have to create seperate individual mappings for each of the fields.I hope you understand what I am getting at, and that you can help.David Mercer |
|
|
|
|
|
Must have one souce column and one destination col