Viewing 15 posts - 8,656 through 8,670 (of 13,876 total)
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...
February 24, 2015 at 8:30 am
er.mayankshukla (2/24/2015)
hmm,Looks like I have to use hardcodes table names in sql command in OleDB Destination
The table name in the OLEDB Destination component is a property.
I can't see what...
February 24, 2015 at 5:51 am
Silly me. I did not edit the source XML to check 🙂
To save others the bother, here is what it looks like (SSDT 2013):
...
February 24, 2015 at 4:53 am
dave hants (2/24/2015)
Were you only bothered about the 3 stored procedures in the database? Did the database not hold any data??--
I have code-library databases like this.
But they're still source-controlled.
February 24, 2015 at 4:38 am
Did you mean OLEDB Command, by the way?
OLEDB Destination does not have a SQLCommand.
February 24, 2015 at 4:36 am
er.mayankshukla (2/24/2015)
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...
February 24, 2015 at 4:34 am
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...
February 24, 2015 at 12:16 am
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.
February 23, 2015 at 12:51 pm
Luis Cazares (2/23/2015)
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...
February 23, 2015 at 11:59 am
February 23, 2015 at 11:26 am
Luis Cazares (2/23/2015)
You need to use the TO_CHAR() function to format dates and TO_DATE()...
February 23, 2015 at 7:30 am
SQL_Kills (2/23/2015)
NULL
*CORRECT*
***FAILED***
'' (Empty)
Then it does not meet the condition so It will not get passed...
February 23, 2015 at 3:03 am
A quick reformat may help
ISNULL(KeyRef) ? FALSE :
(KeyRef == "*CORRECT*" ? FALSE :
(KeyRef == "***FAILED***" ? FALSE :
(KeyRef == "" ?...
February 23, 2015 at 2:36 am
sk88 (2/22/2015)
I thought its related to SQL so I came here 😀 hahah sorry. I will post in the Oracle forum.Thanksss!!
That would be fine, if all dialects of SQL were...
February 22, 2015 at 11:44 am
Viewing 15 posts - 8,656 through 8,670 (of 13,876 total)