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 2005 Forums
 Transact-SQL (2005)
 SSIS Expression Builder Add Line Break, Getdate()

Author  Topic 

ismailc
Constraint Violating Yak Guru

290 Posts

Posted - 2007-08-08 : 06:51:49
Hi, I need help on the following.

SSIS Expression Builder Add Line Break like paragraph format.

1. "Hi" + BREAK? +"Attached find the Daily Sales Report: " + RTRIM( @[User::Period] )

SSIS Expression Builder Adding GetDate() and Add Image Examples

2. GETDATE() ?

3. DAY( @[System::CreationDate] ) ?

4. (DT_IMAGE)?

Please any examples, could not get off the net.

Regards,

rudesyle
Posting Yak Master

110 Posts

Posted - 2007-08-08 : 12:22:31
The line break would be char(10)
Go to Top of Page

ismailc
Constraint Violating Yak Guru

290 Posts

Posted - 2007-08-10 : 03:04:46
Hi, Thank You for your reply.
My Apologies for my late reply as it was Holiday yesterday in S.A.
Do you have example?
Go to Top of Page
   

- Advertisement -