i need to run in sql 2000,so cte is nto working over there.i need select statement.

create table A

(id int primary key,

date1 date)

create table tableb

(id int references tableA(id),

productname varchar(40)

insert into tableA...

but when you insert record from ssis and in table i have identity column.

the first record should be like this

1 fg...

no different login and different schema.

also how to seperate 23mg into 23 and mg ,like letter should be seperated from digits

well isee that example.

but in my case, if they match i ,need to do nothing.

hwo to specify that in merge.

ok.

can i check in lookup with 2 column

for example productid and productname both should match .not OR.

thanks got solve.

but now my script component running indefinitely,

below is code in script component.

#Region "Help: Introduction to the Script Component"

' The Script Component allows you to perform virtually any...

thanks for clarification, what i need is once is get data from file, i need to store what date and time it came

in my sql server table.

do i need to...

thanks

i am goiing to store data like xyd345

i dont knwo where to store in nvarchar or varchar

i ahve attached image ,what details you want ,i can provide it

what i am doing is, going through each file in folder,putting it data into table and then moving that...

thanks got solved

ok,but we have to supply two files xml and .dat

will xml will be same for all files or it will be different,i am getting files from different companies.

if it is...

ok,but i am getting multiple file in a folder,how can i pass file in edi source so that it can pick up one by one

i am getting all this files from client ,so i cant have configuration

well my data its not hierarchical,

for example

TH*4.0*347*01**20120514*091509*P*:~,IS*8007487001*Health~

if you can see TH*4.0*347*01**20120514*091509*P*:~,

i need to store in 1 table,

IS*8007487001*Health into another table

by seperating field,

do you think its EDI,if so how can i...