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: 2 days ago @ 12:27 PM
Points: 179, Visits: 589
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