SSIS Packages
Hi All, i'm facing an issuse while running SSIS Packages. We have a flat file with data like : AT 3131 Falk-'enhayn'- sche Säge AT 3131 Getzersdorf AT 3131 Inzersdorf-Getzersdorf GA AT 3131 Marienmühle AT 3133 Würbelmühle AT 7053 Horn' stein AT 7061 Esterhazy'sche NL 9999 XJ STITS ' WERD IT 09097 SAN-NICOLO'-D'ARCIDANO IT 26030 CA' D'ANDRE IT 26030 CA' DE' MARI IT 26039 CA' DE' STEFANI IT 98030 FOR- ZA D'AGRO'-33333 IT 39050 SAN NICOLO'- D'EGA IT 39050 SAN-NICOLO'- D'EGA123 These data are storing into SQL Server Database like: AT 3131 Falk-'enhayn sche Säge AT 3131 Getzersdorf AT 3131 Inzersdorf-Getzersdorf GA AT 3131 Marienmühle AT 3133 Würbelmühle AT 7053 Horn' stein AT 7061 Esterhazy'sche NL 9999 XJ STITS WERD IT 09097 SAN-NICOLO' D ARCIDANO IT 26030 CA' D'ANDRE IT 26030 CA' DE' MARI IT 26039 CA' DE' STEFANI IT 98030 FOR ZA D AGRO 33333 IT 39050 SAN NICOLO'- D'EGA IT 39050 SAN-NICOLO'- D'EGA123 Problem with above data is some of the data is not storing with out special characters. This script runs everyweek monday. Please suggest any inputs asap. Thanks Srinivas
November 30th, 2010 1:19am

I checked it , no problem exists, data will import exactly like flat file. what did you set as delimiters in flat file connection? did you set any text qualifier too?http://www.rad.pasfu.com
Free Windows Admin Tool Kit Click here and download it now
November 30th, 2010 1:26am

Hi All, i'm facing an issuse while running SSIS Packages. We have a flat file with data like : AT 3131 Falk-'enhayn'- sche Säge These data are storing into SQL Server Database like: AT 3131 Falk-'enhayn sche Säge Problem with above data is some of the data is not storing with out special characters. This script runs everyweek monday. Please suggest any inputs asap. Thanks Srinivas HI Srinivas can u pin point what is exactly going wrong ... U want to omit the special characters or want to be loaded as is ??? can u give sample data , type of flat file [&coding] what is ur target column datatype in which [WithOUT special characyters are been loaded ... ?]Hope that helps ... Kunal
November 30th, 2010 1:27am

Hi Kunal, Thanks for your reply. I want to store data with as it in the flat file with special characters and flat file is .txt file. Target database datatype column nvarchar. Please suggest any inputs asap. Thanks and Regards, Srinivas
Free Windows Admin Tool Kit Click here and download it now
November 30th, 2010 1:36am

We have a flat file with data like : AT 3131 Falk-'enhayn'- sche Säge These data are storing into SQL Server Database like: AT 3131 Falk-'enhayn sche Säge I want same as it is in the flat file. Thanks Srinivas
November 30th, 2010 1:42am

what COLUMN DELIMITER you set in flat file connection? http://www.rad.pasfu.com
Free Windows Admin Tool Kit Click here and download it now
November 30th, 2010 1:42am

Thanks for your reply. delimiters in flat file connection are {CR} {LF}. There is no text qualifier. We have a flat file with data like : AT 3131 Falk-'enhayn'- sche Säge These data are storing into SQL Server Database like: AT 3131 Falk-'enhayn sche Säge I want same as it is in the flat file. Thanks Srinivas
November 30th, 2010 1:45am

I tried with no Column Delimiter and Varchar datatype destination and all rows transferred exactly CORRECT.http://www.rad.pasfu.com
Free Windows Admin Tool Kit Click here and download it now
November 30th, 2010 1:47am

thanks for your reply. But when i run through SAP -> Flat File -> Database problem is coming. When i see in the flat data is coming properly but when flat file to database some of the data is not storing properly. We have a flat file with data like : AT 3131 Falk-'enhayn'- sche Säge These data are storing into SQL Server Database like: AT 3131 Falk-'enhayn sche Säge I want same as it is in the flat file. Thanks and Regards, Srinivas
November 30th, 2010 1:53am

what is your destination type? is it OLEDB or anything else? and another question: when you click on PREVIEW button in flat file source, could you see values correctly?http://www.rad.pasfu.com
Free Windows Admin Tool Kit Click here and download it now
November 30th, 2010 1:57am

Sql server 2005. When i'm clicking on PREVIEW button and able see all proper data. but when i see in the database some data is not stored properly eg: Flat file with data like : AT 3131 Falk-'enhayn'- sche Säge SQL Server Database : AT 3131 Falk-'enhayn sche Säge Thanks and Regards, Srinivas
November 30th, 2010 2:05am

I tried it with all destinations like OLEDB, ADO.NET, SQL Server and in all times, data transferred correctly like : AT 3131 Falk-'enhayn'- sche Säge I tried it with both varchar and nvarchar destination datatype. I think problem is in other place, do you have only these rows in flat file? maybe you have a row with exact "AT 3131 Falk-'enhayn sche Säge" value in flat file too.http://www.rad.pasfu.com
Free Windows Admin Tool Kit Click here and download it now
November 30th, 2010 2:23am

Hi this seems really weird ..... its the quotes ['] that are omitted in ur destination table what is the dataType for your source column in flat file connection manager ? DT_STR .. use DT_WSTR instead .. what is the code page ... can u for test purposes direct the same data into another flat file destination and see if similar data loss occuring ? what is ur flat file type is it just one column flat file with row delimiter as CRLF ?? are there any transformations u using in between source and destination ??Hope that helps ... Kunal
November 30th, 2010 3:31am

just now i haved checked there are no other data in database. Thanks Srinivas
Free Windows Admin Tool Kit Click here and download it now
November 30th, 2010 3:48am

just now i haved checked there are no other data in flat file. and sap also only one record exists. Thanks Srinivas
November 30th, 2010 3:49am

delimiters in flat file connection are {CR} {LF}. There is no text qualifier. i haved used DT_WSTR for source column. But when i run through SAP -> Flat File -> Database problem is coming. When i see in the flat data is coming properly but when flat file to database some of the data is not storing properly. We have a flat file with data like : AT 3131 Falk-'enhayn'- sche Säge These data are storing into SQL Server Database like: AT 3131 Falk-'enhayn sche Säge I want same as it is in the flat file. no transformations in between code. Thanks Srinivas
Free Windows Admin Tool Kit Click here and download it now
November 30th, 2010 3:52am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics