Forum Discussion

HarderT's avatar
HarderT
Icon for Helper II rankHelper II
2 years ago
Solved

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 proce...
Need Help
pipelines
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
HarderT
Icon for Helper II rankHelper II
2 years ago

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.