Add Current Date to Insert

Question

Add Current Date to Insert

briangriffin (Programmer)

(OP)

17 Nov 10 11:28

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.

briangriffin (Programmer) · Answer 1 · 2010-11-17 12:06:54

Instead of trying to do it in the transformation, I added another task that runs the update statement. Probably a more elegant way, but this is working. Thanks.

drlex (TechnicalUser) · Answer 2 · 2010-11-18 06:21:51

A sensible way to do it.
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é

Come Join Us!

Posting Guidelines

Add Current Date to Insert