Expression Task in SSIS does Not work correcly under certain cases by Spandan Buch

Active

Type:	Bug
ID:	772474
Opened:	11/28/2012 12:46:36 AM
Access Restriction:	Public

Workaround(s)

view

User(s) can reproduce this bug

Expression Task by default considers length of previous assigned value when the new value is not of string type. For string type assignments its working correctly.

if 4 characters are assigned earlier then getdate() assignment returns 4 characters only. if 5 then 5 and if none then 0

Details (expand)

English

SQL Server 2012 - Developer Edition

Developer Tools (SSDT, BIDS, etc.)

Other

US English

1. Create SSIS variable of string type and assign four whitespaces as default in Value property
2. Add a expression task
3. In expression task assign the variable with getdate() and press evaluate.

2012 will be displayed

2012-11-28..... should be displayed

X64

File Name	Submitted By	Submitted On	File Size
Test1.zip (restricted)	Spandan Buch	11/28/2012	-

Posted by Spandan Buch on 4/2/2013 at 12:18 AM

Any Updates on this item. It has been 4 months since the issue was reported.

Microsoft