DATE CONVERSION error in SSIS Package

[king420]

!q# !q# !q#


SSIS vallu unte itu randi

[StoneCold]

Let me know whats your issue is about?? sHa_high5ing sHa_high5ing sHa_fr1ends

[The QUEEN]

[quote author=AUDI BABU link=topic=141720.msg1609312#msg1609312 date=1294614792]
!q# !q# !q#


SSIS vallu unte itu randi
[/quote]u forgot these gifs  @3$% LoL.1q LoL.1q LoL.1q LoL.1q

[Deletedid1]

[quote author=StoneCold link=topic=141720.msg1609325#msg1609325 date=1294614991]
Let me know whats your issue is about?? sHa_high5ing sHa_high5ing sHa_fr1ends
[/quote][img]http://www.gifsoup.com/imager.php?id=1683934[/img]

[StoneCold]

[quote author=The QUEEN link=topic=141720.msg1609328#msg1609328 date=1294615100]
u forgot these gifs  @3$% LoL.1q LoL.1q LoL.1q LoL.1q
[/quote] @3$% @3$% you rock you rock

[king420]

[quote author=StoneCold link=topic=141720.msg1609325#msg1609325 date=1294614991]
Let me know whats your issue is about?? sHa_high5ing sHa_high5ing sHa_fr1ends
[/quote]

Naadi Flat file source
Date format DD-MON-YY format lo undi...output DD-MM-YY format kavali

derived colum lo expression lo SUBSTRING use chesa

ee error vastondi

"The value Cannot be converted due to Potential loss of data"



naaku ee error vastondi

[StoneCold]

[quote author=BENZBABU link=topic=141720.msg1609329#msg1609329 date=1294615108]
[img]http://www.gifsoup.com/imager.php?id=1683934[/img]
[/quote] LoL.1q LoL.1q *=: bro sHa_high5ing sHa_high5ing

[king420]

[quote author=The QUEEN link=topic=141720.msg1609328#msg1609328 date=1294615100]
u forgot these gifs  @3$% LoL.1q LoL.1q LoL.1q LoL.1q
[/quote]  *7*^

[Deletedid1]

[quote author=AUDI BABU link=topic=141720.msg1609333#msg1609333 date=1294615168]
Naadi Flat file source
Date format DD-MON-YY format lo undi...output DD-MM-YY format kavali

derived colum lo expression lo SUBSTRING use chesa

ee error vastondi

"The value Cannot be converted due to Potential loss of data"



naaku ee error vastondi
[/quote][img]http://www.gifsoup.com/view1/1397205/gladiator-o.gif[/img]

[king420]

[quote author=BENZBABU link=topic=141720.msg1609337#msg1609337 date=1294615220]
[img]http://www.gifsoup.com/view1/1397205/gladiator-o.gif[/img]
[/quote]  [img width=93 height=80]http://www.andhrafriends.com/Smileys/default/lol-501.gif[/img][img width=93 height=80]http://www.andhrafriends.com/Smileys/default/lol-501.gif[/img]

[Deletedid1]

[quote author=AUDI BABU link=topic=141720.msg1609339#msg1609339 date=1294615239]
  [img]http://www.andhrafriends.com/Smileys/default/lol-501.gif[/img][img width=93 height=80]http://www.andhrafriends.com/Smileys/default/lol-501.gif[/img]
[/quote] sCo_hmmthink sCo_hmmthink sCo_hmmthink sCo_hmmthink

[SACHIN-The Legend]

nenu  oka sample tho test chesa..
date
21-jan-2001
22-jan-2002
23-feb-2003
27-sep-2009
output
1/21/2001,
1/22/2002,
2/23/2003,
9/27/2009,

used data conversion --select date data type
mapped output  of data conversion to destination.

[king420]

[quote author=SACHIN-The Legend link=topic=141720.msg1609636#msg1609636 date=1294618667]
nenu  oka sample tho test chesa..
date
21-jan-2001
22-jan-2002
23-feb-2003
27-sep-2009
output
1/21/2001,
1/22/2002,
2/23/2003,
9/27/2009,

used data conversion --select date data type
mapped output  of data conversion to destination.
[/quote]  *7*^  naaku DD-MM-YY format kavali.... MM-DD-YYYY kadu

and Derived column lo  neenu SUBSSTRING(filename,5,2,)+.........+........  expression rastunnanu...

Next Data Conversion lo DT_DATE istunte...

[color=red]The value cannot be converted due to potential loss of data...[/color]

ani error vastondi

[The QUEEN]

[quote author=AUDI BABU link=topic=141720.msg1609336#msg1609336 date=1294615215]
  *7*^
[/quote] thankyou sSc_hiding2 hmmmm sCo_hmmthink sarle  take ur gif *7*^

[king420]

[quote author=The QUEEN link=topic=141720.msg1610331#msg1610331 date=1294624570]
thankyou sSc_hiding2 hmmmm sCo_hmmthink sarle  take ur gif *7*^
[/quote]

nee bonda emanna solution cheppavemo ani vacha
eleeeee