How do I do this is SQL Server? (from an Oracle background)

[Karen]

SQL Server 2000 Ent, PowerBuilder 6.5 Ent, Window 2000 Pro

Hi,

My only experience is with Oracle,so please bear with me...

We have some new clients that require our pricing data be imported
into their Sql Server databases. The price lists are in Excel files,
which we recieve from numerous vendors on a quarterly basis.

In Oracle we take the following steps:

1. Import this data into tempory tables using bulk import utility
called sqlLoader.

2. Then we have procedures that parse in the data to our various price
tables.

3. Next we export the tables to a '.dmp' file. (contains table data
and table definitions I think).

4. Then the clients download the .dmp file

5. Our client application is then used to drop the price tables on
their local db. and import the .dmp file.

Can anyone point me in the right direction by telling me how to
approach this using SQL Server?

Thanks,
Karen

[Karen]

Sorry subject should be "How do I do this IN SQL Server? dang laptop
keyboard..

[Dan Guzman]

One approach in SQL Server is to use DTS. You could create 2 DTS packages
as follows:

DTS Package 1:

1. Import data into temporary tables using DTS Transform Data tasks. DTS
can import data directly from Excel.

2. Execute procedures to load various price tables.

3. Export tables to individual files (containing data only).
DTS Package 2:

1. Recreate price tables using DDL embedded in DTS package (or simply
truncate existing destination tables)

2. Import data into price tables
--
Hope this helps.

Dan Guzman
SQL Server MVP

"Karen" <no*****@home.com> wrote in message
news:c3********************************@4ax.com...

SQL Server 2000 Ent, PowerBuilder 6.5 Ent, Window 2000 Pro

Hi,

My only experience is with Oracle,so please bear with me...

We have some new clients that require our pricing data be imported
into their Sql Server databases. The price lists are in Excel files,
which we recieve from numerous vendors on a quarterly basis.

In Oracle we take the following steps:

1. Import this data into tempory tables using bulk import utility
called sqlLoader.

2. Then we have procedures that parse in the data to our various price
tables.

3. Next we export the tables to a '.dmp' file. (contains table data
and table definitions I think).

4. Then the clients download the .dmp file

5. Our client application is then used to drop the price tables on
their local db. and import the .dmp file.

Can anyone point me in the right direction by telling me how to
approach this using SQL Server?

Thanks,
Karen

[Karen]

Thanks Dan.

On Mon, 12 Apr 2004 02:21:12 GMT, "Dan Guzman"
<da*******@nospam-earthlink.net> wrote:

One approach in SQL Server is to use DTS. You could create 2 DTS packages
as follows:

DTS Package 1:

1. Import data into temporary tables using DTS Transform Data tasks. DTS
can import data directly from Excel.

2. Execute procedures to load various price tables.

3. Export tables to individual files (containing data only).
DTS Package 2:

1. Recreate price tables using DDL embedded in DTS package (or simply
truncate existing destination tables)

2. Import data into price tables