Thank you,

as far as I can see, it is not wise to put things like that in the master db.

One issue that still is not clear is performance: As we...

The syntax for a type cast is , i. e. (DT_NUMERIC, 38, 0) [PROP_AST_ID]

It actually didn't start yesterday. The mails were being tagged "suspect" from 12/12/2007. I haven't receive any sqlservercentral mails from 12/15/2007. As our provider changed at the beginning of 2008...

You should ask whether it a link table is necessary at all. Maybe there exists some business rule that states that each country has all of the linkage types.

Sorry, here's the correct syntax:

Alexander G. (2/7/2008)

DATEADD("millisecond", UPDATETIME, DATEADD("day",UPDATEDATE,DT_DBTIMESTAMP("1900-01-01")))

That should work.

The way you describe it I don't have a clue either. Maybe it is a question of competence and authorization then (even if there are better ways to solve this)...

If...

I'm having the same problem. Our provider told me that sqlservercentral mails are not RFC compliant. They had to put this domain explicitly on a whitelist. Thunderbird also regards sqlservercentral...

As often the answer is: It depends.

The solution you suggested might be easier but also less flexible. Looking at the logical model this is the straight way to realize a...

Two thinks to mention I think:

First you can't use the alias in the group by clause, just repeat the whole expression there. Second, you might have to qualify your user...

Seems to be the wrong forum but:

IMHO Excel sources and destinations are a mess :sick:.

Look at the metadata SSIS determines for your excel destination. It does not matter which cell...

I think you mistake the meaning of "row by row". AFAIK "row by row" means fetching each row from a recordset and executing one (or more maybe different) commands on...

What you want is an aggregation of data. Except from using the common aggregations (max, count, ...) IMHO this is not the main scope of ETL.

What I recommend is coding...

I usually set the DelayValidation property of the data flow task to "true" so the designer does not realize those metadata changes. You have to be sure that the metadata...

I have never heard about the binary way, but I'd rather try casting date and time to strings, concatenating them and casting it to datetime.

HTH