if i remove the colons i get this format:

2016721 102358 but requirment is to have hh:mm:ss

Thank you

how can we get particular time like 6am ?

yes sir, i tried. I still run into errors. i have Google analytics SSIS source in my packge. It is not even recognised by VS.

Since Stage table is raw data and destination is key columns we cannot merge Stage and destination.

my package is something like below

Stage(Column1 , column2)

|

|

Lookup1(get Column1key1)

|

|

Lookup2(get Column2key2)

|

|

Destination ( Column1key1...

I finally ending up doing with default values from derived column. Thanks.

thing is agebucket column has "(other)" as value and "65+" this is not working:(

how to check if this values exists just palce this value in the column?

all accounts are stored in TableA witrh dates specified

I have a execute task beginning of the logic in which i have this logic

Declare @Truncate bit

BEGIN TRY

EXEC [GetLoadStatus]

@Query = N'accountname',

@StatusFlag = @Truncate OUTPUT

IF @Truncate ...

Master table only updates the account ran successful or not for particular date.

Master table format

Account date ...

Thanks. I have to recreate this entire project again , as it took a while to figure out the correct logic and also something to do with date datatypes conversions.

Thanks it worked.:)

It got resolved using sequence conatineters for each data flow task.

Thanks again.

I tried putting precedent constarintsa from DFT1 to DFT2. It did not work as they both same variables and in same loop , the variables values are not assigned properly...

Can we do both dates and GA websites to loop through in for each loop?

Example : for each data , first lets say 5/26/2016 it should loop through all the...