It is certainly possible, though it is likely you would have to install things on your server which should not really be there (the Microsoft Excel application).

Once you do that,...

Hi Rechana,

Your question is interesting to me even though unfortunately I don't have any expertise to share with you. but I subscribed to see what you end up choosing...

Drew,

I feel like such an idiot. You're absolutely right about the parentheses. That solved problem #1.

I knew the text data type was deprecated but never thought to CONVERT or...

This is not a pleasant one to solve.

The only way I know of doing this is to write some C# code in a script task which will get the sheet...

May I ask what you are trying to achieve overall?

You mean if the INSERT fails? Yes, you can redirect...

The validation your are referring to has to be done manually, ie, create some queries which identify the issues you are concerned about and run them on the staged data.

If...

Secondly, do you realise that your table thoroughly violates relational database principles?

A Gender table should contain, erm, genders and only genders.

A City table would contain your cities.

A Person/Customer table would...

First of all, there is no need to shout ... please consider using some lowercase letter in future.

Secondly, please provide your data in a consumable format (one which can be...

It's tough to beat well-written SQL scripts, but it's also quite rare...

Unfortunately, your flexible architecture has resulted in a performance trade-off which is not easily remedied.

If you can buy and install third party products, you might like to think about

Indeed I did. I believe that yours demonstrates that you did not read mine.

Why are you persisting with Results to Text after I told you (implicitly) that this does not...

Did you even read my response?

You mean 'Results to File'?

You will be prompted for a file name/location when you execute the query.

Results to Text puts the results into the Results pane, in text format.

• This reply was modified 6 years, 10 months ago by Phil Parkin.

I'm just waiting for Jeff to chime in on this one ...