Forum Discussion
Pipeline change Date to Datetime
Hi together,
this is an example of my Importjob. I create a Table with a lot of tablenames from our source database and the ForEach-Task copy the table into our Lakehouse.
In the process, become .
Does anyone have the same problem and know a solution?
I have seen that there is already a known issue for this. However, I use Pipeline and not Dataflow Gen2.
5 Replies
I have seen that there is already a known issue for this. However, I use Pipeline and not Dataflow Gen2.
Thanks for the details HarderT
I will keep you posted regarding the updates of this known issue. Appreciate your patience.
Hi HarderT
Thanks for using Fabric Community.
Are you using On prem database here?
Have you set/checked the data type in the Mapping tab in Copy?
Hi HarderT
Under mapping you have Advanced settings:
If in the source, the column is determined to be a String then running the type checker doesn't understand the source's format.
If you need to force a String -> Date, precreate the table.
Hope this helps. Please let me know if you have any further questions.Hi Anonymous,
the source is an OnPrem-Database. The Columntyp there is DATE and after import into Lakehouse its DATETIME.
I dont use the Mapping-Tab, because I use a ForEach-Loop to import many tables.
I already tried to change the typ with Type conversion settings, but somehow it doenst work. I need the column not as string, but as same as in the source.
I try to precreate the table and see what happens.
