its just in 1 sheet.

yes prod1 is same, but i need uniques value from all 3 and put into 1 column in database

what do you mean by that,i need to do it in ssis,how can maintain reference integrity

thanks,

now what if i have foreign key with the table.

exalple

product

product id identity(1,1) primary key,

name varchar(50))

item

itemid identity(1,1) primarykey,

itemname varchar(5))

productitem

(productid datatype reference product(productid),

itemid datatype referenc item(itemid))

how...

hi,

why we are using + 1 or -1 after findstring,please explain me

hi,

your last name formula is working as a middle name

and middle name formula is not working for last name,

i am getting all null value.

in my table i have char(1),

what column...

hi,

but my table has different structure,how can i use muticast.

each table has different column

i know ,it has so many variation.

what is the other way in ssis, i can achieve.

plz help me

i am usinf this expression for my first column

REPLACE(SUBSTRING(product,1,FINDSTRING(product," ",1) + 0),","," ")

i need help for second and third.

please help me

i need derived column solution ,not sql

thanks sean, do we have any truncate properties in ssis,with OLEDB destination?

guys,

i want to know when i place my cursor over , OLEDB destination, there is an error symbol.

and the message is "truncate may occur due to column ."

how can i...

from oledb source to multitask to oledbdestionation in data flow task.

i am getting this error on OLEDB Destination

i m doing file->save report as

thx guys

thanks evrybdy got solve it