Just Learned - SSIS Fast Parse only supports YYYY-MM-DD, YYYYMMDD for parsing date data

Getting Started with Adobe After Effects - Part 6: Motion Blur


	Just Learned

A collection of quick technology learning tips from what people around you learn every day


	Submit a tip


	Subscribe..

Home · Most Liked · Most Learned · Most Discussed · Silver Rated · Sections

SSIS Fast Parse only supports YYYY-MM-DD, YYYYMMDD for parsing date data

May 3 2012 12:00AM by Jason Yousef

Fast parse supports the following string formats for date, YYYYMMDD and YYYY-MM-DD Basic and extended formats for a four-digit year, a two-digit month, and a two-digit day, for the extended format, the date parts are separated by a hyphen (-), also it's available only when Flat File source or the Data Conversion transformation is used.

Read More.. [74 clicks]

Published under: SQL Server Tips · · · ·

Previous: Record your SlideShows (PowerPoint/PPT) and upload it to Youtube
Next: Easy way to Learn Keyboard Shortcuts in SSMS by Enabling ScreenTips

Jason Yousef

152 · 1% · 319

Liked

Knew

Learned

Incorrect

Interesting

Forgotten


Post this to my facebook wall
Tweet this
Like This
I knew this before
Thanks, I just learned it from you
Sorry, but this is not correct
Interesting, but not my area
I knew it but i have forgotten it


	Submit

Your Comment

Sign Up or Login to post a comment.

"SSIS Fast Parse only supports YYYY-MM-DD, YYYYMMDD for parsing date data" rated 5 out of 5 by 5 readers +Jason Yousef

SSIS Fast Parse only supports YYYY-MM-DD, YYYYMMDD for parsing date data

Your Comment