search

microsoft / sql-server-samples

Azure Data SQL Samples - Official Microsoft GitHub Repository containing code samples for SQL Server, Azure SQL, Azure Synapse, and Azure SQL Edge
Other
9.72k stars 8.78k forks source link

WideWorldImpoters ETL Question at Container Load City Dimension #1111

Open Jingyu1998 opened 1 year ago

Jingyu1998 commented 1 year ago

On visual studio, I restart DailyETLMain.dtsx manually. When executing Execute SQL Task 'Get Lineage Key' in container 'Load City Dimension', an error "No value given for one or more required parameters" was encountered. I check the definition of Stored Procedure getlineagekey in Schema Integration. The variable @TableName is "City". But what is the variable @NewCutOffTime? Please help me for this question!! Thanks

Jingyu1998 commented 1 year ago

I forgot to set the page "Parameter Mapping" and "Result" in "Execute SQL Task Editor". After setting, execute sucessfully.

sikanderv commented 11 months ago

Unrelated to your question but which version of SQL Server that is housing the WWI and WWI-DW databases? I have been getting errors with the DailyETLMain.dtsx and I'm on SQL Server 2022.