DSXchange

I forgot to mention that all the triggers are unconditional for all the sequences

The options are checked in the job properties of the Job Sequnce


1. Add checkpoints so sequence is restartable on failure

2. Automatically handle activites that fail


If i am wrong, please do explain me


Thank you Ray.

Routine | | job ActivitY1---->job ActivitY2---->job ActivitY3--->job ActivitY4--->job ActivitY5--->job ActivitY6 Each Sequnce is calling a set of sequences with the jobs Example job Activity1 J1--J2---J3 so on I am passing a Routine.$returnvalue in the first sequence as a parameter and then as BATCH...

This is the error when i use the datatype as timestamp on the target TCorp..Transformer_2.DSLink4: DSD.BCIPut call to SQLExecute failed. SQL statement:INSERT INTO test_Cashier_Writeback(property, data_date, cashier_id, dept, category, outlet, cashier_fname, cashier_lname, Infogen_cash, priorday_cash...

Ray, It worked when i used datatype as datetime. Oconv(Iconv(DSLink3.Field001, "DMDY"), "D-YMD[4,2,2]") : " 00:00:00" Result is: 1/06/2008 2008-01-06 00:00:00.000 how can i display in this format >>> 01-06-2008 00:00:00:000 <<<it's not working when i use timestamp as da...

Ray I dropped the date column , and deleted the date values from the csv file moved the data which is working fine, infact there were some issues with the csv file which i fixed then the job running fine...but when i view the data in the target table under the data_data column 0x0000000000026983 0x0...

Ray, First of all i really appreciate you for time.Thank you I have tried both ways but still the same error.i am sure you would notice the data_date output value when i used the 1st and 2nd code Oconv(Iconv(InLink.data_date, "DMDY"), "D-YMD[4,2,2]") Fmt(Field(InLink.data_date,&q...

Ray ,

Any help on how can i organize the date component.

DateBad2[1,4]:"-":DateBad2[5,2]:"-":DateBad2[7,2]:" 00:00:00" OCONV(DSLink2.data_date,'D-YMD[4,2,2]') Oconv(Iconv(%ARG1%, "DYMD[4,2,2]"), "D-YMD[4,2,2]") i have tried all the above ways., nothing seems working, i must be doing something wrong, i am v...

this is how i used in trn DateTimeStampToODBC(DSLink2.data_date) Corp..Transformer_4.DSLink5: DSD.BCIPut call to SQLExecute failed. SQL statement:INSERT INTO test_Cashier_Writeback(property, data_date, cashier_id, dept, category, outlet, cashier_fname, cashier_lname, Infogen_cash, priorday_cash_timi...

i have tried but i guess i was not using the right routine in a right way, so it didnt worked ...can you give me a hint to use it in the transformer

How do i convert the source varchar to target timestamp in transformer.i am new to using SQL server databases.


Thank you for your patiency and help

This is another error i see in the director log Corp_Strategy_Upload.MGM1.Transformer_16.DSLink19: DSD.BCIPut call to SQLExecute failed. SQL statement:INSERT INTO test_Cashier_Writeback(property, data_date, cashier_id, dept, category, outlet, cashier_fname, cashier_lname, Infogen_cash, priorday_cash...

This is the sql INSERT INTO test_Cashier_Writeback(property, data_date, cashier_id, dept, category, outlet, cashier_fname, cashier_lname, Infogen_cash, priorday_cash_timing, currentday_cash_timing, tips_paidout, priorday_tip_adj, currentday_tip_adj, accountable_cash, cashdrop_amt, dueback_amt, bank_...

I have a csv file with with tab delimited, a date column (i.e 1/6/2008) which i am loading into a SQL server(2005) table ( mm/dd//yyyy) Seqstage >>> trn >>>>ODBC(sql server table) varchar timestamp I am using line termination as DOS Style delimeter as 009(tab) i can view the data ( i.e 1/6/2008) usi...