-
Re: How to properly replace data when using Upsert for Output?
You could preserve your historical data by making a new DataFlow that uses the problematic output as an input, and then copy its contents to a new DataSet. Then you could bring that copied DataSet in…1 -
Re: How to properly replace data when using Upsert for Output?
Upsert works exactly like Append except that any pre-existing rows with the same key value (the value in the specified key column(s)) as a newer row will be removed. It isn't currently possible (in M…1 -
Re: Input DataSet - Load New data
I can't see why only some of the tiles are displaying the error from what you've said and shown, but I can say that upsert DataSets don't support data version filtering. Most DataSets (Replace and Ap…1 -
Re: Error with String to Date
In that error message, the slashes are not part of the problematic value. They are placed around the value by the error message, the way quotes usually would be. They are very confusing and I am goin…1
