No announcements
Found 2046437 threads
-
0 VotesSSIS data conversion error
It will allow data insertion and SSIS do implicit conversion from varchar to numeric.Answered | 4 Replies | 4611 Views | Created by Ven Raja - Tuesday, June 4, 2013 10:25 AM | Last reply by Harry Bal - Tuesday, June 4, 2013 5:10 PM
-
0 Votes
SSIS conversion failed with data
Because now I cannot change the data in their database or let them fix the data, I have to use some way to avoid those records.Answered | 2 Replies | 1517 Views | Created by msloy - Tuesday, May 14, 2013 10:47 PM | Last reply by msloy - Tuesday, May 14, 2013 11:49 PM -
1 Votes
SSIS Package - Data Conversion Error
Hi Dave - have you updated the data type in SSIS as well?Answered | 14 Replies | 21813 Views | Created by MotoX_Dave - Saturday, February 18, 2012 5:07 PM | Last reply by MotoX_Dave - Thursday, February 23, 2012 4:25 PM -
0 Votes
Data conversion failed in ssis
I would suggest you to debug and get to the row with is causing it to through error..Answered | 1 Replies | 4992 Views | Created by VBala - Friday, May 21, 2010 4:34 AM | Last reply by Rahul Sherawat - Friday, May 21, 2010 4:39 AM -
0 Votes
Data conversion issues in SSIS
I am getting one more error while updating oracle table by using OLEDB command control.Answered | 4 Replies | 2810 Views | Created by ESQL5 - Thursday, November 5, 2015 8:05 PM | Last reply by Katherine Xiong - Monday, November 9, 2015 3:08 AM -
0 Votes
ssis - data conversion
2nd Step you need add Data Conversion transformation in between source and destination and Convert accordingly example is ...Answered | 2 Replies | 1409 Views | Created by --_-- - Thursday, April 3, 2014 9:30 AM | Last reply by Ibrahim Basha Shaik - Thursday, April 3, 2014 10:22 AM -
0 Votes
Data conversion in SSIS
I have resolved the issue , by doing this: Instated of Data Source reader I am using OLEDB source with OLEDB connection - Micorosoft ...Answered | 3 Replies | 8984 Views | Created by developer_zone1 - Wednesday, August 25, 2010 10:27 PM | Last reply by developer_zone1 - Monday, August 30, 2010 6:28 PM -
0 Votes
SSIS conversion error ??
Hi Ramu thoutu, This issue most likely is cased by data conversion.Answered | 6 Replies | 1221 Views | Created by Ramu thoutu - Monday, May 16, 2016 1:56 PM | Last reply by Seif Wang - Tuesday, May 17, 2016 7:51 AM -
0 Votes
data type conversion using ssis
Data conversion transform turns to green. but the flat file remain the white.Answered | 46 Replies | 8608 Views | Created by SQL_BOSS - Monday, November 29, 2010 6:15 PM | Last reply by SQL_BOSS - Wednesday, December 1, 2010 5:52 PM -
0 Votes
SSIS Data Conversion
The issue is if the data in the Service Code field is more 255 characters long,thats where its erroring out .Answered | 8 Replies | 2439 Views | Created by Anita A - Tuesday, August 27, 2013 1:47 PM | Last reply by Harry Bal - Tuesday, September 3, 2013 8:33 PM -
1 Votes
SSIS Data Conversion without using the Data Conversion Transformation
how can i convert a record from a flat file to a different data type without using the data conversion task?Answered | 9 Replies | 4571 Views | Created by zoomwell - Tuesday, September 28, 2010 6:33 AM | Last reply by BeginnerBachi - Tuesday, September 28, 2010 1:21 PM -
0 Votes
Data conversion error
Possible cause of error: Source has more characters than what is allowed by the conversion.Answered | 2 Replies | 8140 Views | Created by Khushi N - Wednesday, September 25, 2013 1:25 PM | Last reply by clark_ussr - Monday, May 19, 2014 12:37 PM -
0 Votes
Getting a conversation error in SSIS package
Then you will find that the column under External Columns group has four-byte signed integer [DT_I4] data type, while it has unique identifier [DT_GUID] data type under ...Answered | 2 Replies | 3799 Views | Created by Amit Kumar Sahoo - Tuesday, November 3, 2015 11:55 AM | Last reply by Katherine Xiong - Wednesday, November 4, 2015 3:30 AM -
0 Votes
DateTime Conversion Issues in SSIS
You can then use the Derived Column component itself to convert them to DT_DBTIMESTAMP, or use a following Data Conversion component - your choice.Answered | 5 Replies | 7726 Views | Created by Srinivas Vinnakota - Friday, October 8, 2010 9:17 PM | Last reply by Reza Raad - Sunday, October 10, 2010 3:27 PM -
0 Votes
Data Conversion
After execute the package, the error you post occurs.Answered | 4 Replies | 1746 Views | Created by DapperDev_ - Tuesday, October 14, 2014 3:24 PM | Last reply by Katherine Xiong - Wednesday, October 15, 2014 11:40 AM -
0 Votes
data conversion SSIS
Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com |Answered | 5 Replies | 2905 Views | Created by Brown256 - Friday, July 13, 2012 2:04 PM | Last reply by SSISJoost - Friday, July 13, 2012 4:07 PM -
2 Votes
SSIS data conversion
Hi Rachel,Downstream, I would add a Data Conversion Task that converts the above result to DT_NUMERIC with the proper amount of fractional digits.Answered | 5 Replies | 751 Views | Created by RachelM.A - Friday, February 16, 2018 4:55 PM | Last reply by RachelM.A - Sunday, February 18, 2018 6:04 AM -
0 Votes
SSIS Data Conversion issue, dt_wstr to DT_Decimal
I've need to convert data from a cube to sql server in SSIS 2010.Answered | 1 Replies | 2115 Views | Created by ddahome - Thursday, May 29, 2014 9:39 PM | Last reply by Ernest Ostrander - Thursday, May 29, 2014 9:58 PM -
0 Votes
Data Conversion
Just execute the data flow only to test the Data Conversion Transformation (right click in data flow and select execute task)Please mark the post as answered if it ...Answered | 7 Replies | 1920 Views | Created by chaitanya kesipeddy - Friday, January 18, 2013 4:44 AM | Last reply by SSISJoost - Friday, January 18, 2013 10:28 AM -
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 | 2836 Views | Created by Tech_consultant - Tuesday, August 13, 2013 9:14 AM | Last reply by Tech_consultant - Friday, August 16, 2013 7:43 AM - Items 1 to 20 of 2046437 Next ›
No announcements
