Add Current Date to Insert
Add Current Date to Insert
(OP)
I have a simple transformation that is working, it takes data from a spreadsheet and pumps it into a SQL Server table each day.
I need to include the current date in the insert, but that value does not exist in the spreadsheet. What is the best way to include it?
I'm not particularly skilled in DTS, thanks for the assist.
I need to include the current date in the insert, but that value does not exist in the spreadsheet. What is the best way to include it?
I'm not particularly skilled in DTS, thanks for the assist.
RE: Add Current Date to Insert
RE: Add Current Date to Insert
I find also a need to 'sanitise' the data from a spreadsheet, due in part to Excel insistence that some columns are a certain data type based on a few initial rows, but mostly due to users entering out of scope items.
To do so, I load the spreadsheet into a temp. table and then extract the valid rows; the invalid ones can then be flagged on a warning email.
soi là, soi carré