Is there a chance that you can provide a sample package with two sample text files to demonstrate this behaviour?

It should not happen, in my opinion.

If you were using Excel...

The table name in the OLEDB Destination component is a property.

I can't see what...

Silly me. I did not edit the source XML to check 🙂

To save others the bother, here is what it looks like (SSDT 2013):

...

I have code-library databases like this.

But they're still source-controlled.

Did you mean OLEDB Command, by the way?

OLEDB Destination does not have a SQLCommand.

er.mayankshukla (2/24/2015)

---

Hi all,

I need to put a dynamic query to OleDB destination SQL command (Data access mode)

But I don't find any option for that.

Lets say I have my query in...

Nice one Dwain. Interestingly, on my machine (desktop PC running W7 64-bit and SQL Server 2014 Dev), I get different results:

Create the sample data

(1000000 row(s) affected)

Multiple Conversions

SQL Server parse and...

Good work Luis. I'm a little surprised at the result, given that there are so many data-type conversions, but the proof is there clear enough.

Luis Cazares (2/23/2015)

---

There's no need to over complicate it.

Actually, if you're inserting into an integer column, you don't need the CAST() from this example as it will be implicitly converted.

declare...

Here is one way.

declare @dt varchar(12) = 'Jul 11 2014';

with dt

as (

...

Try

SUM(Cast [bitcolumn] as int)

Instead.

Luis Cazares (2/23/2015)

---

This is simple and any Oracle forum should give you the answer, but I'll include it here.

You need to use the TO_CHAR() function to format dates and TO_DATE()...

SQL_Kills (2/23/2015)

---

So am I right in saying if the field KeyRef is not one of the followings:

NULL

*CORRECT*

***FAILED***

'' (Empty)

Then it does not meet the condition so It will not get passed...

A quick reformat may help

ISNULL(KeyRef) ? FALSE :

(KeyRef == "*CORRECT*" ? FALSE :

(KeyRef == "***FAILED***" ? FALSE :

(KeyRef == "" ?...

That would be fine, if all dialects of SQL were...