Peter,

Thank you for the further explanation. I think I'm a lot closer to understanding what's happening now.

You ask:

Why do the conversion in T-SQL and not in SSIS (as...

With a similar problem, rather than change the datatype to unicode in my database (not really an option), I added a convert function to the OLE data source: CONVERT(nchar, Problem_column)...

This is a good QOD in that it prompted a careful reading of the syntax of an unfamiliar (to me, anyway) feature. The keywords "DELAY", "TIME", and "TIMEOUT" all...

You have your answer already -- DATEADD(m,6,fiscaldate) or DATEADD(m,7,fiscaldate) -- but goodness, is my curiosity piqued.

For fiscaldate values in January through June, the result will be a date...

The reference given for Update.Write as part of the answer is very clear about this:

.WRITE ( expression, @Offset , @Length )

Specifies that a section of the value of...

As an exercise, yes, you'd probably build your own conversion rates table. From there, you'll have lots of choices on correlating the data. If, as I suspect, this is a...

Just my luck... I actually expected that any answer other than those bowing to superstition would be considered correct.

It's relatively simple to run DTS packages under SQL2005 with legacy support. We decided to do that when we moved from 2000 to 2005 in order to keep the...

That link from Mahesh was not accessible through my company VPN. It's on a blacklist that returned this message:

"The URL you entered is categorized as Illegal Software and has...

Aleksandr,

The truncation happens in the concatenation of the hyphens to N'hello', step 2 in my previous post. It's truncated because the string 'hello' is cast as National characters, so...

1. The "N" prefix indicates "National" characters, that is, double-byte characters to support large-alphabet languages such as Japanese.

2. The concatenation of N'hello' to the repeated hyphens is where...

Michael,

If you do get stuck building this, an artilcle was just posted that addresses making the best of a bad situation.

Name Value Pair article on SQLServerCentral.com: http://www.sqlservercentral.com/articles/Database+Design/62804/

Jacek,

Somewhere in the middle of the avatar wars (which did entertain, JM and RB) there may an answer to this, but I'll ask here anyway. Did you you intend...

As you've found, it's nearly impossible to specify rules for every name. It may be better to use the rules to spot names that don't seem to fit the...

James,

Thanks for the full picture. As a new user of SSIS, I'd be interested in the advantages of using the VariableDispenser approach as you did in your code....