 | |
Uploading optional columns from an Excel data source in SSIS
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Uploading optional columns from an Excel data source in SSIS -
04-07-2006
, 09:25 AM
#2
| |||
| |||
|
|
Hallo Everyone, I have an excel datasource that contains 5 mandatory columns and 20 optional columns. I would like to insert all the data a recieve into a table in an SQL2005 database. What is the best way to do this? Thanks... Nigel... |
#3
| |||
| |||
|
|
By "optional" do you mean the column values will be blank, or the column itself would not be present? "Nigel" wrote: Hallo Everyone, I have an excel datasource that contains 5 mandatory columns and 20 optional columns. I would like to insert all the data a recieve into a table in an SQL2005 database. What is the best way to do this? Thanks... Nigel... |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.