Help Help Urgent

[SQLbie]

SQL doubt
na daggara .csv file vundi i need to transfer to a table using SSIS...

na csv file lo 8th row nunchi start avuthundi columns ...c# rayali anta code(script task) emiana idea vunte cheppandi plsssssss.

back up tesukovataniki vallu system kuda ivvatam ledu intiki

8th row nunchi ila vundi data vundi with column names before that reporting time ani edo matter vundi 7 rows varaku ...

[SQLbie]

[size=4] [/size]
[size=4] [/size]
[size=4] [/size]

[ramu]

ltt

[pachimirchi]

base idea
script component lo text file ni read line function use chey.. condition split lo if linecount>=7 then insert

[Kedi No.486]

[url="http://blog.sqlauthority.com/2011/05/12/sql-server-import-csv-file-into-database-table-using-ssis/"]http://blog.sqlauthority.com/2011/05/12/sql-server-import-csv-file-into-database-table-using-ssis/[/url]


Check this out ,may help you .

[Nisacharudu]

help ltt

[JAPAN]

ltt

[loveindia]

In your package -> data Flow
1 - Excel Source -> Variables -> In Data Access Mode select "Table name or view name variable"
2- In the variable name select a variable that you had made before "MyVar"
3- Go To variable select "MyVar" and type "TabName$A6:B6000"

A pakkana number is for u to select from where to start..
B(ur last colomn deni meeda end aitey adi) and how many rows untey anta number...

Enjoy...

[Josh]

[quote name='loveindia' timestamp='1374723505' post='1304007365']
In your package -> data Flow
1 - Excel Source -> Variables -> In Data Access Mode select "Table name or view name variable"
2- In the variable name select a variable that you had made before "MyVar"
3- Go To variable select "MyVar" and type "TabName$A6:B6000"

A pakkana number is for u to select from where to start..
B(ur last colomn deni meeda end aitey adi) and how many rows untey anta number...

Enjoy...
[/quote]
GP