sql server dts: Uploading optional columns from an Excel data source in SSIS -- sql server dts

Uploading optional columns from an Excel data source in SSIS

Nigel
4/7/2006 7:25:02 AM

sql server dts:

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...

RE: Uploading optional columns from an Excel data source in SSIS

sqlboy2000
4/7/2006 1:20:02 PM

By "optional" do you mean the column values will be blank, or the column
itself would not be present?

[quoted text, click to view]

RE: Uploading optional columns from an Excel data source in SSIS

Nigel
4/9/2006 10:49:02 PM

I mean that the columns may not be present...

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.