In this case, use Temp table.

suppose you try to update CTE, It will update the source table value. it will lead data loss.

I created 2 variable . one for File location and one for flag to determine for file extension.

I wrote the following code in script task

if (DTs.Variables['Filelocation"].value.ToString()).Contains (".txt"))

...

hi,

i have a flat file.

Temp table name : ##Temp

Main Table name : Main_Table

this is the flow

Execute sql task1 ---> Data flow task 1 --->Execute sql...

hi,

yes, i m doing that in Data flow task only.

creating temp table is done in Execute sql task

inserting into temp table form flatfile is in data flow task

inserting into...

hey,

Use Drived Column Component before Data conversion and use this expression

TRIM(birth_date) == "" ? (DT_DBTIMESTAMP)NULL(DT_DBTIMESTAMP) : (DT_DBTIMESTAMP)(DT_STR,10,1252)(SUBSTRING(TRIM(birth_date),5,4) + "/" + SUBSTRING(TRIM(birth_date),1,2) + "/" + SUBSTRING(TRIM(birth_date),3,2))

it will replace the empty string...

hi,

if it s string variable with null values, i wont get error, it is executing.

if i use other data type ( datatime, int) then i got error

hi,

yes, it s nullable column ..

hi,

i created a new variable(scope:package) 'xx' as string with value of 2

i can get the values in script component. when i convert that as interger, it wil give the...

hi,

thanx for reply.

i have only integer value in the flat file.

some of the records haev empty value also ..

hi plz see the attachment

Hi, thanks for reply..

yes. i m going to insert value from one table(Source_Table) to another table(Destination_Table)

step 1: i will get Source_Table in xml format. i will send that to Script...

hi,

thanks for ur reply.

i also tried this query as bellow.becoz i have to check 2 primary columns

[

insert into Source ( batch_id,First_Name,Last_Name,Sid,Mid)

select s.batch_id,s.First_Name,s.Last_Name,s.Street_Address1,s.DOB,s.Sex,s.Subsid,s.Mid from

Source s WHERE not exists

(select f.batch_id,f.First_Name,f.Last_Name,...

hi,

i created Execute sql task and i retrieve value from source table.

i also tried with insert values into destination table foreach loop container

but i can t do...

Thanks for replay,

The both table are in sql server itself. how to use Execute sql task for this.

explain me some more.