Viewing 15 posts - 166 through 180 (of 290 total)
Really looks nice and makes sense. Thanks!
Will be testing it today. Does it make difference if I do 'Select 1 instead of Select * in each EXISTS(...... subquery?
or Select Top...
November 12, 2019 at 5:07 pm
Should I update statistics first on all tables participating in the joins? including the #temp table?
November 12, 2019 at 1:29 pm
All indexes are tuned to their best (for the current statement) so I am specifically looking for rewriting this IF statement.
May be 2 or 3 IFs are better? like populating...
November 12, 2019 at 2:39 am
Yes, I have just installed the 2nd instance, it is possible, thanks.
October 28, 2019 at 5:54 pm
Thanks! So if there is more than 1 record matching in SOURCE then MERGE picks a random one to insert?
Do you use ROW_NUMBER inside of CTE in the Source?
September 30, 2019 at 6:39 pm
Grant, thank you so much for the overview! I really appreciate it.
Question: establishing 2nd (cloud) location. Which paid service of this kind would you recommend?
or, if not cloud, then what...
April 23, 2019 at 5:55 pm
when i press ADD button to add error output it says cannot create it.
Is there a way to let package continue writing to sql table , SKIPPING (or ouputting...
February 19, 2019 at 11:16 am
February 19, 2019 at 10:41 am
I ended up doing it this way, because same scrtipt needs to be run on both 2016 and 2000 SQL Servers:
--create first table
CREATE TABLE...
December 30, 2018 at 11:12 am
i did what you said, and 1252 to 65001 everywhere, and ALwaysUseDefaultCodePage=true in destination.
But i really don't know why it worked :). i thought i tried the same before.
December 28, 2018 at 4:04 pm
shouold i try to re-create the CSV file or text file make it text file and copy and paste or recreate the data in new csv file and try....
December 28, 2018 at 3:19 pm
I changed all types via COnversion task from DT_STR to WDT_STR unicode. as on the attached pic.
then i got oledb destination error: cannot convert between non-unicode and unicode data..
December 28, 2018 at 3:07 pm
Viewing 15 posts - 166 through 180 (of 290 total)