logo-MindMajix
PostSSISSSIS
s
sri kanth

Posted on 19th July 2024|3883 views

0
votes

Ssis Convert String To Date

How to convert a string to date?

1 answers
Answers
P
chris bons

Posted on 19th July 2024| views

To convert a string to Date, we have to perform the following steps:

  • Include a "Data Conversion" Data flow component.
  • Right-Click, Display Advanced Editor
  • Open Input and Output Properties
  • Open the custom properties, fix custom properties to be true.
  • Ensure that data type is fixed to database date[DT_DBDATE].
  • Run the SSIS Package.
     

Write your answer

STILL GOT QUERIES?

Get a Live FREE Demo

  • Explore the trending and niche courses and learning maps
  • Learn about tuition fee, payment plans, and scholarships
  • Get access to webinars and self-paced learning videos
Name
Course *
Email *
Phone Number