0

New to IICS, when build mapping to populate data by EXEC stored procedure from source, I can preview data from query editor. But when I tried to run preview from source and I got nothing return. Any idea?

Preview Data from Query Editor

I can preview data

Not able to preview data when run preview from Source

I also tried to write data to file, the file generated but only field names without data return.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Tako
  • 1
  • Aside... be careful with things like datetime literals which are subject to language/region settings, such as the `SET DATEFORMAT` setting of the server and/or current session. Instead of `01/25/2023 11:00:00` you might wish to use the unambiguous format `yyyy-MM-ddThh:mm:ss`, i.e.: `2023-01-25T11:00:00`. – AlwaysLearning Apr 05 '23 at 01:07
  • This seems to be `run preview`, a preview of data when you run or may be debug the flow. It can be different than a source data preview. What are you trying to do here? – Koushik Roy Apr 05 '23 at 06:05
  • @AlwaysLearning I tried the date format you suggested. I am still having same issue. Thanks – Tako Apr 06 '23 at 02:38
  • @KoushikRoy I tried to populate my source data by EXEC Stored Procedure. I can preview data from query editor that make me thinking my source is working. But the data not flow to the downstream expression – Tako Apr 06 '23 at 02:44
  • Seems a bug to me... – Maciejg Apr 07 '23 at 13:05

0 Answers0