DSXchange

Hi hari,

you can schedule the job in different timings in same day,

Add to schedule-> Daily->give specific time
and again
Add to schedule-> Daily->another timing

so that you can schedule many times to run the same job in a day

Hi ray i think open command can be used when insert array is processed. and it cannot be used for COMMIT. and it will run only one time on conductor node. but my requirement is to update the table before loading into the same table and my source is user- defined SQL , suggest me if any changes shoul...

Hi i am getting the following error [quote] main_program: [IBM(DataDirect OEM)][ODBC SQL Server Driver][SQL Server]Could not allocate new page for database 'TEMPDB'. There are no more pages available in filegroup DEFAULT. Space can be created by dropping ob Tfm_AZ_PMGProvXRef_Pass1: Error when check...

Hi all i want to update a table AZ_PMGProvXRef_Temp1 based on the below query the Query is Update AZ_PMGProvXRef_Temp1 Set ProductID = 'CO' where ProductID = '3' or productid = '0'; i want to do this in open command. but open command cannot be used to commit(i had seen this in datastage developers g...

Hi

i had converted tinyint into integer

convert(integer,SpecialtyCode) as SpecialtyCode

and my problem solved

Hi All i am getting the following error, the columns having datatypes of char,bit,tinyint and timestamp(23,3) but i am getting the error Numeric value out of range, i dont know which column having error,i can view the data and when i view the data it's seem ok. APT_CombinedOperatorController,1: [IBM...

hi all

but my source is a DB table and i want to update the same table

as per your design how to achieve this

Source ---->UpdateSQL--->Dataset

so where should i write the update SQl.

Hi all my issue is i had an update SQl as below UPDATE ds_wk_PMGProvXref SET ds_wk_PMGProvXref.HospitalGRP = imp_ProviderPrimaryHospital.Hosp_Grp_Num, ds_wk_PMGProvXref.HospitalFAC = imp_ProviderPrimaryHospital.Hosp_Num from ds_wk_PMGProvXref with(nolock) INNER JOIN imp_ProviderPrimaryHospital with(...

Hi my update query is UPDATE ds_wk_PMGProvXref SET ds_wk_PMGProvXref.HospitalGRP = imp_ProviderPrimaryHospital.Hosp_Grp_Num, ds_wk_PMGProvXref.HospitalFAC = imp_ProviderPrimaryHospital.Hosp_Num from ds_wk_PMGProvXref with(nolock) INNER JOIN imp_ProviderPrimaryHospital with(nolock) ON ( ds_wk_PMGProv...

Hi All my job will update the records and my Source and Target is same Table(and my database is SQL Server 2005) i put the Hash keys also sometimes it will work fine on the other day it get aborted. and it will run for more than 1 hour and at finally it get aborted(Actually it should update 59000 re...

hi all my job will update the table my source and target is same table(SQL Server) and i also used the HASH keys but i am getting the error message Violation of UNIQUE KEY constraint 'IX_wk_PMGProvXref'. Cannot insert duplicate key in object 'wk_PMGProvXref' The statement has been terminated. and th...

Hi Ray

so we can write any SQL for any table in close command

HI i had developed a job of inserting into dummy table ,the source & target's is dummy tables i.e, no records are inserted(no Transformation logic) now, can i write update SQL's in close command for original table i.e, another table what my doubt is we should write close command for the particul...

hi

though i change into

Cast(PrinterException as NVarchar(50))

i am getting the same error

Urgent Care (Sun. - Sat.: 12:00p.m. - 10:00 p.m.) ph # 623-977-7211)

the above quote is a text value and field name is PrinterException

it doesn't matter i remove # or ph # 623-977-7211

HI Werner i had tried with all the options like removing Closed bracket ')' but in the database the value is Urgent Care (Sun. - Sat.: 12:00p.m. - 10:00 p.m.) ph # 623-977-7211) and the field is text and if i remove substring it is showing error like Msg 8163, Level 16, State 3, Line 1 The text, nte...