Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Date Time Insertion

Author  Topic 

vikram1
Starting Member

13 Posts

Posted - 2006-02-09 : 04:51:04
Hi All,
I am trying to insert the DATE and Time when i process a DTS Package automatically.Wat i mean is whenever i run my dts Package i want that in my output sheet there should be a column populated regarding the date and time at which these results are populated in the output sheet. like
kunnr DTStime
709 09022006 3:20 P.M
if anyone knows a solution to this pls help.

X002548
Not Just a Number

15586 Posts

Posted - 2006-02-09 : 15:59:51
Make the column defate GetDate() and exclude it form the import?



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam
Go to Top of Page

vikram1
Starting Member

13 Posts

Posted - 2006-02-10 : 06:29:12
i would be highly obliged if you could tell a bit more about the solution you are suggesting....

:-)
Go to Top of Page
   

- Advertisement -