selecting system date

Question

selecting system date

preed64

Valued Member

Points: 70
More actions
June 24, 2004 at 10:22 am

#108158

I'm rather new to SQL server and have a requirement to add the date of the export to the filename in my DTS package.
I know how to do this in Oracle easily via a pseudo table called dual and it's a simple select sysdate from dual.
How can I accomplish this in SQL Server?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736162 More actions · Answer 1

use a dynamic properties task to select getdate(). you can use datepart to extract the items you need and then format them. The dynamic properties task can use this query to set the export filename for any connection you have.

preed64 Valued Member Points: 70 More actions · Answer 2

Thanks Steve I'll try that. By the way is something like this in that book you talk about on your site?

Steve Jones - SSC Editor SSC Guru Points: 736162 More actions · Answer 3

Which book?

Brian Knight's DTS book (http://www.sqlservercentral.com/columnists/sjones/prodts.asp) talks about dynamic properties a little as does Darren Green's site (http://www.sqldts.com)

mansooralia SSC Enthusiast Points: 100 More actions · Answer 4

mansooralia

SSC Enthusiast

Points: 100

June 25, 2004 at 4:45 pm

#512055

try :

Select getDate();

It may help.

M.Ali