Viewing 15 posts - 9,136 through 9,150 (of 13,876 total)
There is another possibility.
Have two tables, t1 and t2, with identical structures.
t1 is your 'main' table. Assume that it is up to date with data.
On the next day, load table...
August 13, 2014 at 4:38 am
Is there any pattern as to when the query runs slowly? Could one of the servers be overloaded? Could some of the source tables be locked?
August 13, 2014 at 4:33 am
F/-\R//-\Z (8/12/2014)
hiI want Compare two Table data and insert changed field to the third table
who can help me
thanks a lot:-):hehe:
So all three tables have the same structure?
And...
August 13, 2014 at 4:31 am
ronan.healy (8/11/2014)
i have a tbale and after the table i want to put in a derived column that then pick just the data from the InvestmentType == "Forward Cash"
now i...
August 11, 2014 at 8:00 am
SQLTougherGuy (8/11/2014)
Thanks Phil - So what is the standard? Craigs code seemed to work.
Mine should execute slightly faster because there's no need for SSIS to go meta-data sniffing through the...
August 11, 2014 at 7:57 am
ronan.healy (8/11/2014)
a right ya sorry was getting mixed up.but the date has to be in the mmddyyyy for the system it goes into when the package runs
You mentioned...
August 11, 2014 at 4:46 am
Koen Verbeeck (8/11/2014)
Phil Parkin (8/11/2014)
ronan.healy (8/11/2014)
ok thanksand if the string is not all the same length I will probably hit problems ?
As long as the string is three or...
August 11, 2014 at 4:21 am
ronan.healy (8/11/2014)
ok thanksand if the string is not all the same length I will probably hit problems ?
As long as the string is three or more characters, you should...
August 11, 2014 at 3:11 am
ronan.healy (8/11/2014)
ok would you know any quick fix for this even a script or something to fix it
Create another derived column in 'YYYYMMDD' format and INSERT that instead.
August 11, 2014 at 3:10 am
m.mukesh.mca2009 (8/7/2014)
Hi, eID have only unique values but ID may have duplicate values
By being lazy and not providing what people are asking for, you are making this thread more painful...
August 8, 2014 at 12:07 am
Agree with previous comment. Try changing INNER JOIN to LEFT JOIN and see whether that helps you.
August 8, 2014 at 12:04 am
This behaviour (selecting from temp tables) changed in SSIS 2012. Rather than declaring dummy metadata in your proc, you should use the WITH RESULT SETS option when you run the...
August 8, 2014 at 12:00 am
m.mukesh.mca2009 (8/7/2014)
I have a table like below.
ID eIDinCountoutCount
417720NULL NULL
1000010331 7
1000010346 ...
August 7, 2014 at 8:12 am
Have a read here and see whether it makes sense, then come back with any follow-up questions.
August 7, 2014 at 5:05 am
As you're using project deployment, you must be on SSIS 2012.
So your config info should be coming straight out of an SSISDB environment - no XML required.
August 7, 2014 at 4:16 am
Viewing 15 posts - 9,136 through 9,150 (of 13,876 total)