Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Varcahr in date column Expand / Collapse
Author
Message
Posted Thursday, July 18, 2013 2:19 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, September 17, 2013 2:07 PM
Points: 171, Visits: 556
Hi Friends ,
In ssis package , trying to pull data from excel to a table
I have a date column in a table ,but excel has "date, text" in date column.
How can I insert the date , text in a table date column ?


I tried taking date caolumn datatype as varcahr(10) but not inserting valid date.

example:
DATE
3/10/2013
recrr

Thanks,
komal
Post #1475214
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse