Viewing 15 posts - 8,656 through 8,670 (of 13,882 total)
Did you check the link which I provided in my previous post?
February 26, 2015 at 6:55 am
Have a look here.
February 25, 2015 at 10:32 am
PHYData DBA (2/25/2015)
GilaMonster (2/25/2015)
PHYData DBA (2/25/2015)
https://technet.microsoft.com/en-us/library/ms188270(v=sql.105).aspx
A heap is a table without a clustered...
February 25, 2015 at 9:15 am
gopi6417 (2/25/2015)
I don't know exactly.Could you please tell the syntax on Oracle.
The poster realised after posting the original question that they were in the wrong forum.
So if you are providing...
February 25, 2015 at 5:41 am
gopi6417 (2/25/2015)
select replace(CONVERT(VARCHAR(11),GETDATE(),106),' ','/')
Does this syntax work on Oracle?
February 25, 2015 at 5:33 am
Thank you Hugo. Looking forward to the rest of the series.
February 25, 2015 at 3:00 am
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
Viewing 15 posts - 8,656 through 8,670 (of 13,882 total)