ascii values

[Pramod Jamadagni]

PFA…

[Balachandra.S]

Interesting to know the ASCII values. It’s been long we discuss the problems in this group. Why don’t we share the problem and solution we face in every day SQL.

 

How do we map 240 columns in SSIS in easy way ?

 

--------------------------------------------------------------------------------------------------------------

Yours sincerely

Balachandra.S

Mobile: 9740966006    

Email: Balach...@gmail.com

 

From: dwhte...@googlegroups.com [mailto:dwhte...@googlegroups.com] On Behalf Of Pramod Jamadagni
Sent: Tuesday, July 15, 2014 9:12 PM
To: dwhte...@googlegroups.com
Subject: [dwhtechies:112] ascii values

 

PFA…

--
You received this message because you are subscribed to the Google Groups "DWHTechies" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dwhtechies+...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Alam Mushir]

I think there are only two ways:

1. Let the source and destination have the same name. Then SSIS will map them automatically. Try to at least have the same name for most of the columns. Then you can map the others that SSIS could not map.

2. Brute force, all 240 columns will have to be mapped manually in case the src and dest name are different. I think it is both time consuming and prone to manual errors.

A third method would be to write a Script task where you specify a logic to do the mapping.

Thanks

Mushir