Thank you, so much!! you are the Master.. Appreciate !!!!!

Thank you so much, Scott!! Really appreciate you help..

Thank you, So much!!

Thank you for you reply, but columns will dynamic from pivot.. So I would like to create table  like  select * into table_bak from table

Thanks for all your support

Thanks Jeff .. please help if you have time..

Hello jeff thank you so much for yours help..

1.I am happy even TSql .. as per given DDL statement in my post data will be there in table.. just find...

• This reply was modified 4 years, 6 months ago by  DBA.k.
• This reply was modified 4 years, 6 months ago by  DBA.k.

I tried to C# code and something skip the rows and load data , based on variable.. but that one i configure in Package configuration .. but the requirement is...

Thank you.. Jeff .. Please help on this when ever you have time.. The other thread i unsubscribed..

can you please help on this task

Thanks Jeff..

This is test file

...

fhgjhjlj,nnhhjhjj

ID,name,sal

10,mahi,2000

20,ravi,1000

30,ram,3000

total : 3

This is test file

...

fhgjhjlj;nnhhjhjj

ID;name;sal;city

10;mahi;2000;HYD

20;ravi;1000;ban

30;ram;3000;Mum

total : 3

Please assume like above 2 files in txt files that i need to load in DB...

Yes boss you are correct, really file will come may be cama , delimiter or semicolon delimiter etc... also header will be there in one 3rd row and some other...

Thank you.. I am sorry But that unanswered question is regarding SSIS process from txt file.. This having next task which is data will be in Sql server table.. From...

• This reply was modified 4 years, 6 months ago by  DBA.k.

correct but noting in my hand to fix source data.. different clients will provide different  sources.. requirement is we have to load that different sources need to load  into database...

yes thanks.. please help me how to handle to find header row and create table with that header and load data.. also how can we handle dynamic  delimiter ..