SSIS packages - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

SSIS packages

Author

Topic

srinivas.juluri
Starting Member

1 Post

Posted - 2010-12-01 : 06:15:07

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

nigelrivett
Master Smack Fu Yak Hacker

3385 Posts

Posted - 2010-12-01 : 06:30:05

What datatypes are you using varchar or nvarchar?

==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources