Pipeline change Date to Datetime

[HarderT]

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?

[HarderT · Accepted solution]

I have seen that there is already a known issue for this. However, I use Pipeline and not Dataflow Gen2.

Known issue - Type mismatch when writing decimals and dates to lakehouse using a dataflow - Microsof...

[v-nikhilan-msft]

Thanks for the details @HarderT 
I will keep you posted regarding the updates of this known issue. Appreciate your patience.

[v-nikhilan-msft]

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?

[v-nikhilan-msft]

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.

[HarderT]

Hi @v-nikhilan-msft,

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.