importing using DTS

#1

I currently run a DTS packages to import data from an SQL
server into an excel worksheet. It is set up to run the
data every night, but the problem I'm having is that it is
importing the entire table each time it runs and I only
want new records. Please advise.

#2

Sounds like you have a spreadsheet that is being appended to. If that's the
case, you'll need to import into a working table and only grab new rows from
there.

-Pete

"Pam" <pcoleman (AT) police (DOT) nashville.org> wrote:

Quote:

I currently run a DTS packages to import data from an SQL
server into an excel worksheet. It is set up to run the
data every night, but the problem I'm having is that it is
importing the entire table each time it runs and I only
want new records. Please advise.

#3

You will need to be able to identify these new rows.
I presume you can do that with the key values.
What about changed rows?

You have a number of choices.

1. Use a linked server to the spreadsheet and query that
as you would a normal table comparing against key values
in the SQL Server

2. Import the spredsheet into a staging table and then
use TSQL to do the comparisons sending the differences
back to Excel (Horribly messy)

Quote:

-----Original Message-----
I currently run a DTS packages to import data from an SQL
server into an excel worksheet. It is set up to run the
data every night, but the problem I'm having is that it
is
importing the entire table each time it runs and I only
want new records. Please advise.
.

#4

Will this append the new records to the existing?

Quote:

-----Original Message-----
You will need to be able to identify these new rows.
I presume you can do that with the key values.
What about changed rows?

You have a number of choices.

1. Use a linked server to the spreadsheet and query that
as you would a normal table comparing against key values
in the SQL Server

2. Import the spredsheet into a staging table and then
use TSQL to do the comparisons sending the differences
back to Excel (Horribly messy)

-----Original Message-----
I currently run a DTS packages to import data from an
SQL
server into an excel worksheet. It is set up to run the
data every night, but the problem I'm having is that it
is
importing the entire table each time it runs and I only
want new records. Please advise.
.

.

#5

Please do not carry on the same subject in multiple threads. i have answered
your Q in the other thread titled "Import to Excel using DTS"

"Pam" wrote:

Quote:

Will this append the new records to the existing?
-----Original Message-----
You will need to be able to identify these new rows.
I presume you can do that with the key values.
What about changed rows?

You have a number of choices.

1. Use a linked server to the spreadsheet and query that
as you would a normal table comparing against key values
in the SQL Server

2. Import the spredsheet into a staging table and then
use TSQL to do the comparisons sending the differences
back to Excel (Horribly messy)

-----Original Message-----
I currently run a DTS packages to import data from an
SQL
server into an excel worksheet. It is set up to run the
data every night, but the problem I'm having is that it
is
importing the entire table each time it runs and I only
want new records. Please advise.
.

.

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

importing using DTS

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

importing using DTS - 09-23-2004 , 02:18 PM

Re: importing using DTS - 09-23-2004 , 03:47 PM

importing using DTS - 09-24-2004 , 04:32 AM

importing using DTS - 09-24-2004 , 07:29 AM

RE: importing using DTS - 09-24-2004 , 08:03 AM