microsoft / microsoft/sql-server-samples
WideWorldImpoters ETL Question at Container Load City Dimension
Nobody has claimed this yet.
- Dominant language
- PowerShell
- Stars
- 11.2k
- Forks
- 9.1k
- Avg merge
- 2d 7h
- Merged PRs (30d)
- 14
Description
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
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start with DailyETLMain.dtsx and the Execute SQL Task 'Get Lineage Key' in the 'Load City Dimension' container. Read the Integration schema definition of the getlineagekey stored procedure, trace how @NewCutOffTime is supplied, and confirm the task no longer reports missing required parameters.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 20/100