for every update of the stroed proc do i have to re-map the fields b/w source and destination ? Was this any way related to data types of flat file ? Not every update, no, but it seems you do for this update. What flat file? ObjectStorageHelper<T> – A WinRT utility for Windows 8 | http://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me Not every update ?? For which i need to re-map then ? Text file . Thanks Jamie for your time ! Rajkumar Yelugu >Not every update ?? For which i need to re-map then ? Any update that changes either the number of columns that are returned and/or the data types of those columns. What text file? I'm very confused because you never actually mentioned a text file in yuor original post.ObjectStorageHelper<T> A WinRT utility for Windows 8 | http://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me

Hi Jamie , .txt file sorry about that :)Rajkumar Yelugu

Hi Jamie , .txt file sorry about that :) Sorry but I'm still totally confused why you keep mentioning a "flat file"/"text file"/".txt file" when your question is in regard to a stored procedure.ObjectStorageHelper<T> A WinRT utility for Windows 8 | http://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me

Team , I have a field which used to return NULL from OLEDB source previously ,after updating the stored proc and when the same field now returns expected value (type string ) the packages failes with below error . There was an error with output column "XX_Seen_TS" (8205) on output "OLE DB Source Output" (8148). The column status returned was: "Conversion failed because the data value overflowed the specified type.". End Error Error: 2011-12-05 04:00:35.60 Code: 0xC0209029 Source: Data Flow Task OLE DB Source [8138] Description: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "output column "XX_Seen_TS" (8205)" failed because error code 0xC0209075 occurred, and the error row disposition on "output column "XX_Seen_TS" (8205)" specifies failure on error Is this expected behaviour ? for every update of the stroed proc do i have to re-map the fields b/w source and destination ? Was this any way related to data types of flat file ? Thanks in advance for any pointers .Rajkumar Yelugu

for every update of the stroed proc do i have to re-map the fields b/w source and destination ? Was this any way related to data types of flat file ? Not every update, no, but it seems you do for this update. What flat file?ObjectStorageHelper<T> A WinRT utility for Windows 8 | http://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me

If you change the columns, column datatype or column order being returned from your stored procedure, you will need to remap the columns in your SSIS package.Jeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCITP, MCDBA Blog: Mr. Wharty's Ramblings MC ID: Microsoft Transcript Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker

for every update of the stroed proc do i have to re-map the fields b/w source and destination ? Was this any way related to data types of flat file ? Not every update, no, but it seems you do for this update. What flat file? ObjectStorageHelper<T> A WinRT utility for Windows 8 | http://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me Not every update ?? For which i need to re-map then ? Text file . Thanks Jamie for your time !Rajkumar Yelugu

Hi Jamie , .txt file sorry about that :) Sorry but I'm still totally confused why you keep mentioning a "flat file"/"text file"/".txt file" when your question is in regard to a stored procedure. ObjectStorageHelper<T> – A WinRT utility for Windows 8 | http://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me The OP may be exporting the data returned from the Stored Procedure to a flat file destination.Jeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCITP, MCDBA Blog: Mr. Wharty's Ramblings MC ID: Microsoft Transcript Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker

yes the OP is exprted to flat file !Rajkumar Yelugu

Hi Rajkumar Yelugu, According to the error message, it looks like datatype issues in source component. Please check the input/output properties in the advanced editor in OLE DB Source, and I also suggest you can redirect errors and send the error rows to a file or table and then determine the root cause of the issue. Here is a article about how to redirect error rows to a table, please see: Error Redirection with the OLE DB Destination: http://agilebi.com/jwelch/tag/error-handling/ Thanks, Eileen