Viewing 15 posts - 1,906 through 1,920 (of 11,678 total)
thava (9/8/2014)
Thanks, for the info, but switching my career is not possible, I think i know little bit of the clustered index and...
September 8, 2014 at 1:23 am
How does such an expression look like?
September 8, 2014 at 12:33 am
Since you have the comma as a delimiter and the address data contains a comma as well, you are bound for trouble.
SSIS will think a new column has started.
You either...
September 5, 2014 at 5:39 am
er.mayankshukla (9/5/2014)
Buffer Size is Default i.e. 10485760And BatchSize, I guess is MaxInsertCommitSize viz. 100
There is also a commit at the end of a buffer, if I'm not mistaken.
September 5, 2014 at 5:16 am
What is the batch size and what is the buffer size of the data flow?
September 5, 2014 at 2:51 am
Ugh. 🙂
This is bad design, because a table doesn't have an order. You should be able to random mix the rows in the table and still achieve the same result.
If...
September 5, 2014 at 2:44 am
patelmohamad (9/5/2014)
instead of taking loop I...
September 5, 2014 at 2:30 am
If a single driver has multiple logged in dates and multiple logged out dates, you need to join on something else as well.
How do you know which logged in date...
September 5, 2014 at 2:25 am
Does this work?
SELECT
DDLH_IN.DRIVER_ID
,DDLH_IN.IS_LOGGED_IN
,DDLH_OUT.IS_LOGGED_IN
,DRIVER_NAME
,LOGGED_IN_DATETIME= DDLH_IN.LOGGED_DATETIME
,LOGGED_OUT_DATETIME= DDLH_OUT.LOGGED_DATETIME
FROM dbo.D_DRIVER_LOGGED_HISTORY DDLH_IN
JOIN dbo.D_DRIVER_LOGGED_HISTORY DDLH_OUT ON DDLH_IN.DRIVER_ID = DDLH_OUT.DRIVER_ID
WHERE DDLH_IN.DRIVER_ID = 4 AND DDLH_IN.IS_LOGGED_IN = 1 AND DDLH_OUT.IS_LOGGED_IN = 0;
September 5, 2014 at 1:38 am
patelmohamad (9/5/2014)
I have tried it but no luck, I have 81 Records for that particular driver but it is multiplying the records and the output value is 6561...
September 5, 2014 at 1:34 am
Phil Parkin (9/5/2014)
There is an SSIS System Variable called 'StartTime'.You may be able to create an Expression which uses this, thus avoiding the need for a Script Task.
+1
The system variables...
September 5, 2014 at 1:17 am
Ah I see. Use an INNER JOIN on DriverID instead of the union all.
September 5, 2014 at 1:13 am
What exactly is your desired output?
September 5, 2014 at 1:07 am
Viewing 15 posts - 1,906 through 1,920 (of 11,678 total)