dbTalk Databases Forums  

DateTime Stamp Column

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss DateTime Stamp Column in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
PSULionRP
 
Posts: n/a

Default DateTime Stamp Column - 04-08-2008 , 04:01 PM






I am transforming, INSERTing rows into a SQL Server Table from an Excel
spreadsheet. I have two columns on my SQL Serve Table that I want to provide
the information for that is not in my Excel spreadsheet...

CreatedOn which should be the Current DateTime stamp and
CreatedBy which I'll need to hard code my User ID into.

Can someone tell me where I need to do this...within the "Destination"
folder...within the "Transformations" folder...

Thanks in advance for your help.

PSULionRP

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.