Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
yaman
Posting Yak Master
213 Posts |
 Posted - 2008-06-16 : 05:24:10
|
| Sir , I want to import data From Excel sheet to Sql server tables .and I want only import only Limited Columns not all Pls Help me out Yaman |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-16 : 05:29:13
|
| Add a data flow tsk to your package. Just use a Excel source connection and OLEDB destination connection.Edit the columns tab to check only columns you want. preview the data and then edit the OLEDB destination to point to your table. |
 |
|
|
yaman
Posting Yak Master
213 Posts |
Posted - 2008-06-16 : 05:31:47
|
Sir , How can i Add a data flow tsk .quote:
Originally posted by visakh16
Add a data flow tsk to your package. Just use a Excel source connection and OLEDB destination connection.Edit the columns tab to check only columns you want. preview the data and then edit the OLEDB destination to point to your table.
Yaman |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-16 : 06:23:46
|
quote:
Originally posted by yaman
Sir , How can i Add a data flow tsk .quote:
Originally posted by visakh16
Add a data flow tsk to your package. Just use a Excel source connection and OLEDB destination connection.Edit the columns tab to check only columns you want. preview the data and then edit the OLEDB destination to point to your table.
Yaman
Click View->Toolbox from top menu. Toolbox appears on left side. You will have lots of control tasks and mainatinence . Drag and drop Data Flow task appearing under control tasks to window and double click on it. A new tab opens called data flow tab. then you can add the Excel source and OLEDB destination from left toolbox under Data Flow Source and Data Flow destination. And continue editing the properties. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Import data from excel to tabels