Add Current Date to Insert

briangriffin · Nov 17, 2010

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 · Nov 17, 2010

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 · Nov 18, 2010

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é

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Add Current Date to Insert

briangriffin

Programmer

briangriffin

Programmer

drlex

Technical User

Similar threads

Part and Inventory Search

Sponsor