Post

SSISSSIS

s
sri kanth

Posted on 26th February 2024|3593 views

0
votes

Ssis Convert String To Date

How to convert a string to date?

Answers
P
chris bons

Posted on 26th February 2024

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