December 14, 2009 at 6:52 pm
i have a peoplesoft date column ..in that date column i need the recent date compared with SQL date column...if recent date in peoplesoft is equal to date in sql column ...dont execute package else pkg will continue to execute further process......plz help its most urgent...Explain in detailed...Thanks in advance
December 14, 2009 at 7:43 pm
dinu14 (12/14/2009)
i have a peoplesoft date column ..in that date column i need the recent date compared with SQL date column.
Unless someone who wants to help is already aware of Peoplesoft, it will be difficult to know format of the date datatype Peoplesoft. So my suggestion is give some details here with example data.
..if recent date in peoplesoft is equal to date in sql column ...dont execute package else pkg will continue to execute further process......
This can be done using a conditional statement. Nothing much can be suggested since there is no input from you (Table DDL or column names)
plz help its most urgent...Explain in detailed...Thanks in advance
When help is needed urgent, give more details so that any one looking at the question / problem would be able to come up with script suggestions.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 14, 2009 at 7:58 pm
More Details...
People soft Table : PS_Rev_Fact_Sum : Column in a table: RI_ACCTG_PD_ENNDT
SQL Table: PS_Rev_Fact_Sum: Column in a table: SQ_Rev_RS_ENNDT
I need to find the Max(RI_ACCTG_PD_ENNDT) and the compare it with in SQL SQ_Rev_RS_ENNDT if it Equals pkg will fails else go to futher process...
I need details... wat transformations do i need to make dis pkg successful
December 14, 2009 at 8:46 pm
dinu14 (12/14/2009)
I need details... wat transformations do i need to make dis pkg successful
Transformation? You have not mentioned anything about transformations until now and what transformations to use depends on what your requirement is.
If I say to use sort transformations, will you use it even if it is not required?
You have to let us know what your need is.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 14, 2009 at 10:51 pm
I have some understanding of PeopleSoft has I help support the databases for our Finance and HR systems; as well as helping the PeopleSoft developers with SQL queries and tuning.
You haven't given me enough to really help. You really need to provide more details as to what you are attempting to accomplish. Sample data that shows what you are attempting will go even further.
December 15, 2009 at 4:41 am
Just my Team Lead had given this much info and then he asked me to figure it out....
December 15, 2009 at 5:24 am
There is a difference, you have access to the database and the data, and to the SSIS package. This gives you a lot more info than we have, as we can't see what you do. This means we need more info if we are going to be able to help you. We aren't psychic, even if we do seem to be able to guess at what so OP's are asking with not much more.
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply