Data Cleansing SSIS - 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)

Data Cleansing SSIS

Author

Topic

mushy
Starting Member

12 Posts

Posted - 2010-02-10 : 12:03:28

Hi Gurus,

we are trying to create application catalog,I have few excel workbooks(approx 100) ,where user entered applications used by their respective process. Now there is no standard format they entered the application names

for example: Excel and Microsoft Excel , SAP and SAP 4.0

I have to create a application table with these excel workbooks, can you guys suggest me, how can i architect this process

Thanks

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-02-10 : 12:06:52

something like ApplnName,Abbreviation could be column name and you could save values like
Microsoft Excel,Excel
MS Excel,EXcel
SAP 4.0,SAP
..

------------------------------------------------------------------------------------------------------
SQL Server MVP

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources