No announcements
Found 698516 threads
-
2 VotesCapture data conversion error for each row
No, row_number is not provided ,you have to deal this situation in other ways.Either you add a column row id in excel or first dump this data into some temp table and then apply data ...Answered | 7 Replies | 2208 Views | Created by Tech_consultant - Friday, September 21, 2012 11:11 AM | Last reply by Samay Shrivastava - Friday, September 21, 2012 1:12 PM
-
2 Votes
Derived Column - Date Conversion
After the second derived column, the format for the date column is exactly 'Mon 05/21/2009' or '21/05/2009'.Answered | 32 Replies | 6050 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
Indentify Column name after Data Conversion Error
Step 1: Take the error output of Data Conversion and ass a Sript component insode your Data flow.Answered | 3 Replies | 2695 Views | Created by Tech_consultant - Tuesday, August 13, 2013 9:14 AM | Last reply by Tech_consultant - Friday, August 16, 2013 7:43 AM -
1 Votes
Displaying columns as rows and rows as columns
I'm not sure that I fully understand, but vave you looked at formatting the report with multiple columns?Answered | 1 Replies | 7985 Views | Created by dekej - Wednesday, June 15, 2005 4:12 PM | Last reply by Keith Thomson - Tuesday, June 21, 2005 5:00 PM -
0 Votes
Rows and Columns
What I have is a list of numbers and then columns that are the results of my Query.Answered | 3 Replies | 7189 Views | Created by Arkanoid - Wednesday, January 3, 2007 8:05 PM | Last reply by Arkanoid - Wednesday, January 3, 2007 10:06 PM -
0 Votes
Datetime conversion error in a row - how to locate the bad rows
The conversion error occurs when the varchar value is in the format of e.g 30/04/2010.Answered | 4 Replies | 4186 Views | Created by Vipstercular - Monday, May 24, 2010 1:02 PM | Last reply by Vipstercular - Monday, May 24, 2010 2:35 PM -
0 Votes
Conversion error for the varchar column
The following article deals with DATE / DATETIME functions, conversions and issues: http://www.sqlusa.com/bestpractices/datetimeconversion/ You can ...Answered | 7 Replies | 2879 Views | Created by srisql - Wednesday, December 21, 2011 7:41 PM | Last reply by Kalman Toth - Monday, December 26, 2011 6:04 PM -
0 Votes
Selecting rows based on Timestamp column
Conversion is implicit, should be no problems there.Answered | 11 Replies | 7150 Views | Created by rockstar2831 - Monday, November 18, 2013 10:40 PM | Last reply by Vedran Kesegic - Tuesday, November 19, 2013 8:55 AM -
1 Votes
Ignore Column after data conversion transformaiton
See this post of Todd:Answered | 3 Replies | 2543 Views | Created by Tech_consultant - Saturday, September 22, 2012 8:29 AM | Last reply by SSISJoost - Saturday, September 22, 2012 6:08 PM -
2 Votes
derieved column string to date conversion
Basically there was a comma in one of the fields which was making other fields shift one column and hance wrong data in date column.Answered | 10 Replies | 4135 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
SSIS Derived Column and Data Conversion Task
You cannot directly use the data conversion component to convert into date.Answered | 3 Replies | 8907 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
SSIS data conversion error
If the destination table has column of numeric data type, it would be loaded into the destination column.Answered | 4 Replies | 4366 Views | Created by Ven Raja - Tuesday, June 4, 2013 10:25 AM | Last reply by Harry Bal - Tuesday, June 4, 2013 5:10 PM -
1 Votes
rows to columns
Hi Friend Below link help to you http://stackoverflow.com/questions/15745042/efficiently-convert-rows-to-columns-in-sql-server Vignesh MAnswered | 2 Replies | 680 Views | Created by arkiboys - Wednesday, July 20, 2016 2:08 PM | Last reply by M.Vignesh - Wednesday, July 20, 2016 3:53 PM -
0 Votes
Conversion error
The number of failing rows exceeds the maximum specified.Answered | 2 Replies | 10246 Views | Created by AdrianOConnor - Wednesday, December 21, 2005 10:13 PM | Last reply by Chongtham Rajen Singh - Sunday, February 23, 2014 11:28 AM -
0 Votes
Derived Column Multiple rows...
Use a conditional split before the derived column and split the data based on Column 1 = 30 and Column 2 <> '000'.Answered | 3 Replies | 3774 Views | Created by RAGS1109 - Thursday, September 1, 2011 2:55 PM | Last reply by Reza Raad - Sunday, September 4, 2011 3:24 AM -
0 Votes
Flat File Source > Derived Column > Data Conversion > OLE DB Destination
Data Conversion 4.)Answered | 23 Replies | 3285 Views | Created by GrifMan - Tuesday, July 18, 2017 12:36 AM | Last reply by GrifMan - Tuesday, August 15, 2017 9:58 PM -
0 Votes
How to display columns as Rows
Hi, I need a query to bring all columns to row, can any one let me know how can we achieve the below scenario.Answered | 1 Replies | 5720 Views | Created by Fazlu - Monday, January 11, 2010 8:12 AM | Last reply by ramireddy - Monday, January 11, 2010 8:26 AM -
1 Votes
Listview Rows and Columns
Hey, I don`t think there is a scrollBar value you can get but, you can get the (TopItem.Index) which tells you which row index is showing at the top of the Listview.Answered | 3 Replies | 1830 Views | Created by Wilrodiz - Sunday, May 12, 2013 8:50 PM | Last reply by IronRazerz - Monday, May 13, 2013 2:01 AM -
0 Votes
Data Conversion Wrror Output
Do two (sequential) (linked) Data Conversions.Answered | 2 Replies | 4720 Views | Created by abc123sr - Wednesday, May 11, 2011 3:28 PM | Last reply by ArthurZ - Wednesday, May 11, 2011 6:53 PM -
0 Votes
Converting columns to rows.
Check this blog post to find your solution: http://sqlwithmanoj.wordpress.com/2010/09/16/combine-multiple-rows-to-csv-string-and-vice-versa/ ~manoj | email: ...Answered | 3 Replies | 2278 Views | Created by SSASStarter - Thursday, June 14, 2012 11:46 AM | Last reply by Krishnakumar S - Thursday, June 14, 2012 12:12 PM - Items 1 to 20 of 698516 Next ›
No announcements
