No worries JOHN. I learned how to generate identity value in the pipelines. can be helpful in the future.

No, the first process ie reading from flat file and loading into sql tmp tbl and then from tmp tbl to sql hist tbl. So here we have 2 dataflow....

Thanks JOhn.

If u remember, you were the one who helped me to produce that identity property in the dataflow pipelines. But the fact is, the first way of loading is...

CozyRow,

I have no doubts that indeed it is a great tool. and i always wished that my company ( or any place i have been or will be) allow me...

Ryan,

its a truncation error while reading from flat file. What u can do is go to the flat file source and select Error Output on left side of ur source...

wadep,

So far my understanding is - there is no dynamic connections for multiple file schema. You define schema at the connection and it uses that connection for that file. The...

Thanks JOHn

Worked. Th problme was IDTSVariable90 in the script was changed to IDTSVariable100 and Ident variable was named Pipilinerows.

Its gonna save my half time for the amount of load. and...

John thanks.....for all the help. STill i am getting validation error on script component.

here are the steps and detail info.

1. Declare variable "Ident" of type int32, scoped to package.

2. inside...

John, I think I know what u trying to say using derived column. but is there somewhere where i can find code to do the increment.

Probabaly what i am thinking...

Yes john we need data in both tables. load_Cus is used as a loading tbl for daily load which gets truncated for every load. and hist_cus is used to keep...

Anyone? ANy thoughts ..............

Sorry Guys looks liek I posted in wrong section..........It should be in SSIS.............section.......my whole day was wrong!!!!

I am using SSIS to load. Inside my dataflow i have a source and destination. SOurce is my flat file and destination is my SQL tbl.

THis is my data...

You are right, I am not pointing to project folder. I am just asking which one to used?, Although I have always used one, inside the solution folder, not the...

Glad that I was able to do it....and I understand too,been that road so many times.....