how to write script in datafolw from Excel to DBTable?

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Sekhar C
    New Member
    • Mar 2011
    • 2
    #1

    how to write script in datafolw from Excel to DBTable?



    Hi Here I am transfering data from excel file to Database file in SSIS2008r2 using package in BIDS
    my input:
    I have an Excel File as shown below
    Emp_name Salary
    ram 60k
    sam 45K

    my output:
    i want table as shown below

    Emp_name Salary
    ram 60000
    sam 45000

    please guide me how to do scripting for the above challege, please let know any other ways to completes this job

    Thanks

    Sekhar C
    Tags: None
    Previous template Next
    Working...