No announcements
Found 749225 threads
-
2 VotesDerived Column - Date Conversion
I tried adding another derived column and casting to a DT_WSTR but it still does not work.Answered | 32 Replies | 6180 Views | Created by nickjb16 - Wednesday, July 22, 2009 5:57 PM | Last reply by Todd McDermid - Thursday, July 23, 2009 7:29 PM
-
0 Votes
Derived Column Date Conversion
So I am trying to change my date type which is in the 1/1/2015 12:30:10 PM to a 2015-1-1 00:00:00 So I am using Derived Columns to do the trnasformation ...Answered | 2 Replies | 1058 Views | Created by kiwi10101 - Wednesday, July 8, 2015 5:37 PM | Last reply by Katherine Xiong - Wednesday, July 15, 2015 6:27 AM -
0 Votes
Date Conversion Using Derived Column
When you open the file in Excel, it autotypes the columns and trys to help you determine the display.Answered | 10 Replies | 3696 Views | Created by Anita A - Tuesday, August 20, 2013 3:34 PM | Last reply by Tom Phillips - Tuesday, August 27, 2013 9:47 PM -
1 Votes
SSIS Derived Column and Data Conversion Task
You cannot directly use the data conversion component to convert into date.Answered | 3 Replies | 9044 Views | Created by Kajoo - Monday, November 1, 2010 4:53 PM | Last reply by Nitesh Rai - Monday, November 1, 2010 5:25 PM -
0 Votes
Assign a date derived Column
Hi, refer to this thread which analyses the date format issue with ...Answered | 5 Replies | 2448 Views | Created by srisql - Wednesday, November 16, 2011 2:36 PM | Last reply by Karthikeyan Anbarasan - Friday, November 18, 2011 9:26 AM -
0 Votes
DT_numeric To Timestamp Conversion in Derive Column
Dates seem particularly difficult in this respect for many people, because they assume that simply because they can understand (read) a date, SSIS will be able to ...Answered | 12 Replies | 4046 Views | Created by Aminesh - Friday, August 28, 2009 6:15 PM | Last reply by Todd McDermid - Friday, August 28, 2009 9:19 PM -
0 Votes
derived column -- Data conversion
HI The second one worked thank you, one more question, I am trying to convert this one to datetime in derived column, its ...Answered | 3 Replies | 2540 Views | Created by Brown256 - Thursday, July 12, 2012 7:27 PM | Last reply by SSISJoost - Thursday, July 12, 2012 8:03 PM -
0 Votes
ssis derived column for date time
NULL(DT_STR, 255, 1252) : ["BuyerBirthDate"]" on "output column "Derived Column 1" (15338)" is not valid.Answered | 11 Replies | 6393 Views | Created by sql learner12 - Wednesday, May 23, 2012 6:05 PM | Last reply by sql learner12 - Wednesday, May 23, 2012 9:26 PM -
0 Votes
SSIS Derived column data conversion
All I got to is CSV files pumping in and chaning the date from DD/MM/YYYY to datetime.Answered | 5 Replies | 5288 Views | Created by ozsql - Wednesday, June 23, 2010 12:33 AM | Last reply by ozsql - Wednesday, June 23, 2010 3:20 AM -
1 Votes
SSIS derived columns: allow null dates but reject invalid dates
In your Derived Column component, you have some kind of expression to convert your text string column [TextDate] into a real date, like ...Answered | 3 Replies | 14964 Views | Created by firstlast - Thursday, October 1, 2009 4:12 PM | Last reply by firstlast - Monday, October 5, 2009 2:09 PM -
2 Votes
derieved column string to date conversion
Have you put a data viewer before the derived column and for error outputs from the derived column.Answered | 10 Replies | 4228 Views | Created by SameerMughal - Tuesday, March 2, 2010 4:52 PM | Last reply by Sudeep Raj - Wednesday, March 3, 2010 1:32 PM -
1 Votes
Derived Columns
Hi, SQL Server 2008 now has a dedicated Date only datatype so the OP's question may be valid if ther destination db is on SQL Server 2008.Answered | 5 Replies | 5299 Views | Created by caolong32 - Wednesday, February 4, 2009 10:36 PM | Last reply by Mr. Wharty - Thursday, February 5, 2009 9:34 PM -
0 Votes
Substring function in Derived Column
Because 20111201 is not a date, and frankly you do not need this conversion, leave all DT_WSTR. just extract the date portion slice to add the dashes (-) and you are done.Answered | 2 Replies | 2723 Views | Created by srisql - Thursday, January 12, 2012 7:37 PM | Last reply by srisql - Thursday, January 12, 2012 8:01 PM -
0 Votes
SSIS derived column convert string to date
You can also create a script component, set language as C# , create an output column of type date and write this script for ...Answered | 2 Replies | 8589 Views | Created by asquare97 - Thursday, July 12, 2012 8:01 PM | Last reply by Reza Raad - Thursday, July 12, 2012 11:55 PM -
0 Votes
Change Date-Time format through derived column
I have my OLEDB source query as : select convert(varchar(10),getdate(),101) as date_var My Expression used in the Derived Column part ...Answered | 9 Replies | 1634 Views | Created by Adarsh Srivastava - Thursday, March 20, 2014 6:33 AM | Last reply by Adarsh Srivastava - Thursday, March 20, 2014 10:47 AM -
2 Votes
Date columns changing using derived column task
Hi, As you need to remove only "/" , you can use derived column transformation and this ...Answered | 2 Replies | 1708 Views | Created by Murali dhar - Monday, July 15, 2013 12:49 PM | Last reply by Aamir Shahzad Warraich - Monday, July 15, 2013 4:10 PM -
0 Votes
String to Date conversion fail
Below is the Derived column formula that used.Answered | 6 Replies | 1034 Views | Created by ShyamCharan - Thursday, January 14, 2016 10:02 AM | Last reply by MarcosLanzarini - Thursday, January 14, 2016 11:33 AM -
3 Votes
Data type conversion problem in derived column transformantion
He was trying to execute @Maxdate = select max(date) from dimtime. in a Derived Column Transformation.Answered | 16 Replies | 7338 Views | Created by Deputy12 - Wednesday, May 11, 2011 11:07 PM | Last reply by Mr. Wharty - Thursday, May 12, 2011 2:37 AM -
0 Votes
How to convert string date type in derived column
Pardon the columns names, but they are informative :) CREATE TABLE UnScrew_Dates (stupid_date_string VARCHAR(10) NOT NULL PRIMARY KEY, valid_date ...Answered | 7 Replies | 3815 Views | Created by Dana70 - Wednesday, October 5, 2011 4:32 PM | Last reply by --CELKO-- - Wednesday, October 5, 2011 10:32 PM -
1 Votes
text to date conversion
You can just do a Derived Column transformation along the line below.Answered | 1 Replies | 7098 Views | Created by 02NDN - Monday, November 16, 2009 3:12 PM | Last reply by Kalman Toth - Monday, November 16, 2009 5:15 PM - Items 1 to 20 of 749225 Next ›
No announcements
