oh..yeh..i understood you ,but any way i used script component and then conditional split to separate the records..may be we don't want to go for staging tables...

Hi John...I got something on this...but i am not sure how far this works...

if you want to see this , then here is the URL

http://www.sqlis.com/sqlis/post/Data-Generator-Source-Adapter.aspx

if i had a condition, i would have used condition split....but the worst thing is i don't have any specific conditions....its just like that the first 500 records in one...

I am not clear, John...

Please,Could you brief me..?

is there no transformation to split the records..?

i understand the problem.....In some way the "other" is considered as null itself by the derived column.....why it does not take up to 4 char like "Othe" and insert into...

in case truncation....what should i do?

Other has 5

and Destination allows 4

i could be able to pull the image records...

the problem is i need to merge the data with another OLEDB source where both has no connection coulmn...

i need is two...

just located in a local disk's folder...

that's what i need on....thank you so much buddy...

Thanks Steve..

it was really very help full to me...

but my doubt is ....why must we specify the path of the file name in a separate CSV File?

we can't get the...

what i need is single insert statement...

insert into BigCounter(CounterID) select ?

im just passing the parameter value by a variable through parameter mapping...

or

i should need T_SQL statement top get this done..?

is...

i'm just incrementing a column value one by one through script component ...like 1,2,3,...10000...for example if the last value is 100000..i need to get that last column value and...

Thanks Guys....I got Some Idea...

if i pass transno 200501....then i need this kinda result..

incidentid isvoid transno

10001 0 ...