DTS excel mapping

#1

Hi
I have an excel spreadsheet that has 6000 records hardcoded values and the
rest are dynamic links to another spreadsheet that update automatically.
I used import/export wizard to create a DTS package to import data from this
spreadsheet into a table in sql server that has not null constraints on it.

The first 6000 records load fine but at 6001 it says that there are nulls in
the records and fails to load.

Can you suggest a way by which both the hardocoded values and the dynamic
links can be loaded.

Thanks
Bob

#2

Hello Bob,

I don't know for sure but i cannot imagine that this will be possible without
using the Excel Object model.

Allan

Quote:

Hi
I have an excel spreadsheet that has 6000 records hardcoded values and
the
rest are dynamic links to another spreadsheet that update
automatically.
I used import/export wizard to create a DTS package to import data
from this
spreadsheet into a table in sql server that has not null constraints
on it.
The first 6000 records load fine but at 6001 it says that there are
nulls in the records and fails to load.

Can you suggest a way by which both the hardocoded values and the
dynamic links can be loaded.

Thanks
Bob

#3

Allan
I was able to load the dynamic links and hardcode values independently put
in two separate files.
What is the object model and how can I use it.

Bob

"Allan Mitchell" wrote:

Quote:

Hello Bob,

I don't know for sure but i cannot imagine that this will be possible without
using the Excel Object model.

Allan

Hi
I have an excel spreadsheet that has 6000 records hardcoded values and
the
rest are dynamic links to another spreadsheet that update
automatically.
I used import/export wizard to create a DTS package to import data
from this
spreadsheet into a table in sql server that has not null constraints
on it.
The first 6000 records load fine but at 6001 it says that there are
nulls in the records and fails to load.

Can you suggest a way by which both the hardocoded values and the
dynamic links can be loaded.

Thanks
Bob

#4

Hello Bob,

Ahhh so when you say it has NULLs are you seeing then this behaviour

http://www.sqldts.com/default.aspx?254

Allan

Quote:

Allan
I was able to load the dynamic links and hardcode values
independently put
in two separate files.
What is the object model and how can I use it.
Bob

"Allan Mitchell" wrote:

Hello Bob,

I don't know for sure but i cannot imagine that this will be possible
without using the Excel Object model.

Allan

Hi
I have an excel spreadsheet that has 6000 records hardcoded values
and
the
rest are dynamic links to another spreadsheet that update
automatically.
I used import/export wizard to create a DTS package to import data
from this
spreadsheet into a table in sql server that has not null constraints
on it.
The first 6000 records load fine but at 6001 it says that there are
nulls in the records and fails to load.
Can you suggest a way by which both the hardocoded values and the
dynamic links can be loaded.

Thanks
Bob

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

DTS excel mapping

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

DTS excel mapping - 02-03-2006 , 09:11 AM

Re: DTS excel mapping - 02-03-2006 , 09:21 AM

Re: DTS excel mapping - 02-03-2006 , 11:02 AM

Re: DTS excel mapping - 02-03-2006 , 11:09 AM