Forum Discussion
Copy data step error copying data from date to date fields
After importing data to a staging table, I am attempting to just append it to a fact table. The process is a simple append from table to table with a partition of DateKey. The tables share the same...
Just wanted to let people know the resolution. I landed the data into a table with datekey set to text, then appended the data to the permanent table, and converted it to Date Format in the destination table.