That is an excellent question. When I do the following for the conversion data flow, the import works!

ISNULL([FiscalYearNumber])? "2012" : [FiscalYearNumber]

Thank you.

when I look at the input properties for fiscalyearnumber column it shows expected datatype DT-I2 which is what I am supposed to use when SQL table expects smallint.

OK, thank you very much for replying!!!

so, I've changed my approach. I've manually added the column in source file and on destination sql table as smallint.

My flow...

I found the syntax that worked: ISNULL(FiscalYearNumber) ? "FY12" : FiscalYearNumber

In my case I added a fiscalyearcolumn to the destination table, for which there is no corrolary in the source spreadsheet, but the value will always be '2012' for each...

Discovered source of problem was that once I created copies of original columns (in Data Converstion object) with new datatypes I needed to return to Excel DataFlow object and remap...

I am using AliasRules table. I need clarity regarding this warning:

"Warning! The maximum key length is 900 bytes. The index 'PK_AliasRules' has maximum length of 1025 bytes. For some combination...

The answer to my question is that Michael's sproc creates a table in the db. It is called AliasRules. All you have to do is insert into that...

Hi there. Sorry, here it is

http://www.sqlservercentral.com/scripts/constraints/71340/ .

Thank Lowell! Thanks for the demo on how to use rownumber with rank as more sophisticated alternative to my expression. Appreciate it.

Michael Sondergaards sproc is really smart. It identifies multicolumn...

Thanks Jack Corbett, I'll look at this row number solution. Appreciate it.

Hi Jeff. Yep, his sproc identifies duplicate keys, not duplicate names. You can look at it as I've provided the link.

As far as having identified the duplicates, I think Michael Sondergaards sproc works really well for that and I have examined the results. Works good.

But, I agree with the reservations....

I think this will work

where RC.Constraint_Name LIKE '%[0-9]%'

Thank you GilaMonster!