<div>
try:<br />
<br />

<pre><code id="code-20-42836333-1">RIGHT(&quot;0&quot; + (DT_WSTR,2)DATEPART(&quot;dd&quot;,GetDate()),2) + &quot;-&quot; + RIGHT(&quot;0&quot; + (DT_WSTR,2)DATEPART(&quot;mm&quot;,GetDate()) ,2) + &quot;-&quot; + (DT_WSTR,2)DATEPART(&quot;yyyy&quot;,GetDate()) </code></pre>
</div>


try:



RIGHT("0" + (DT_WSTR,2)DATEPART("dd",GetDate()),2) + "-" + RIGHT("0" + (DT_WSTR,2)DATEPART("mm",GetDate()) ,2) + "-" + (DT_WSTR,2)DATEPART("yyyy",GetDate()) 

IT Consultant

gvamsimba

<div>
Hi Ryan I got the below error<br />
<br />
A truncation occurred during evaluation of the expression.
</div>


Hi Ryan I got the below error

A truncation occurred during evaluation of the expression.

<div>
the below works like a charm..<br />
<br />
RIGHT(&quot;0&quot; + (DT_WSTR,2)DATEPART(&quot;dd&quot;,G<wbr />etDate()),<wbr />2) + &quot;-&quot; + RIGHT(&quot;0&quot; + (DT_WSTR,2)DATEPART(&quot;mm&quot;,G<wbr />etDate()) ,2) + &quot;-&quot; + RIGHT(&quot;0&quot; + (DT_STR,4,1252)DATEPART( &quot;yyyy&quot; , getdate() ), 2)
</div>


the below works like a charm..

RIGHT("0" + (DT_WSTR,2)DATEPART("dd",GetDate()),2) + "-" + RIGHT("0" + (DT_WSTR,2)DATEPART("mm",GetDate()) ,2) + "-" + RIGHT("0" + (DT_STR,4,1252)DATEPART( "yyyy" , getdate() ), 2)

<div>
<div class="content wysiwyg-content">
Hi I have created a new variable in SSIS with string datatype and used the below expression which is giving me 03042019 but i want it as<br />
03-04-19 which is in dd-mm-yy format. can someone please update the below expression to get my<br />
desired result.<br />
<br />
Many Thanks<br />
<br />
RIGHT(&quot;0&quot; + (DT_WSTR,2)DATEPART(&quot;dd&quot;,G<wbr />etDate()),<wbr />2) + RIGHT(&quot;0&quot; + (DT_WSTR,2)DATEPART(&quot;mm&quot;,G<wbr />etDate()) ,2) + (DT_WSTR,4)DATEPART(&quot;yyyy&quot;<wbr />,GetDate()<wbr />)
</div>
</div>


Hi I have created a new variable in SSIS with string datatype and used the below expression which is giving me 03042019 but i want it as
03-04-19 which is in dd-mm-yy format. can someone please update the below expression to get my
desired result.

Many Thanks

RIGHT("0" + (DT_WSTR,2)DATEPART("dd",GetDate()),2) + RIGHT("0" + (DT_WSTR,2)DATEPART("mm",GetDate()) ,2) + (DT_WSTR,4)DATEPART("yyyy",GetDate())

SSIS Variable Expression to get dd-mm-yy format

SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications. It features a fast and flexible data warehousing tool used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data. SSIS replaced Data Transformation Services, which had been a feature of SQL Server since Version 7.0.