Case sensitivity in DTS transformations?

[MrPeds]

Hi,

Very simple this question.

If I have a source database table with the columns:

id, name, address

and a destination table with the same fields but in upper case:
ID, NAME, ADDRESS

am i correct in thinking that the data transformation will break if i move between databases where the destination is in upper case?

Basically i've developed a few dts packages on the assumption that the source is upper case, only to find that they are lower case

Any suggestions are appreciated,

Thanks,

MrPeds

 

[SQLDenis]

That shouldn't matter

try this
select id, name, addreSS from table
select id, nAmE, address from table
select id, NAME, address from table
select ID, name, ADDress from table

tjis should all work without a problem

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/