How to populate the DB table... 1

[udayit55]

Hi guys,

I need your help. I have a table in the DB where the table has been defined/created. All I have to do is populate the table, and I need help to know what is the best possible way I can do it with minimal difficulty.

By the way the DB I'm using is MS SQL Server 2005.

Your help is appreciated.


Uday.

 

[ptheriault]

udayit,
You are going to have to provide us with a lot more information than that. Where is your data now. What format is it in. What is the table definition?

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[udayit55]

Hi guys,

The data is actually located on a SQL Server and are accessed by a third party application ... Now coming 2 the table definition it has many columns...If you want the columns....here they are...hope they are useful...

EMP_ID,EMP_GID,PID,FLAG_PEAK,EMPLOYEE_NAME,EMPLOYEE_TITLE,
NET_BOOKED_Y0,NET_CANCELLED_Y0,NET_SLIPPAGE_Y0,ROOMNITE_TOTAL_Y0,ROOMNITE_GOAL_Y0,ROOMNITE_VARIANCE_Y0,RATE_TOTAL_Y0,RATE_GOAL_Y0,RATE_VARIANCE_Y0,
REVENUE_TOTAL_Y0,REVENUE_GOAL_Y0,REVENUE_VARIANCE_Y0,TENTATIVE_ROOM_BOOKED_Y0,TENTATIVE_ROOM_RATE_Y0,TENTATIVE_ROOM_REVENUE_Y0,NET_BOOKED_Y1,
NET_CANCELLED_Y1,NET_SLIPPAGE_Y1,ROOMNITE_TOTAL_Y1,ROOMNITE_GOAL_Y1,ROOMNITE_VARIANCE_Y1,RATE_TOTAL_Y1,RATE_GOAL_Y1, RATE_VARIANCE_Y1,REVENUE_TOTAL_Y1,
REVENUE_GOAL_Y1,REVENUE_VARIANCE_Y1,TENTATIVE_ROOM_BOOKED_Y1,TENTATIVE_ROOM_RATE_Y1,TENTATIVE_ROOM_REVENUE_Y1,NET_BOOKED_Y2,NET_CANCELLED_Y2,NET_SLIPPAGE_Y2,
ROOMNITE_TOTAL_Y2,ROOMNITE_GOAL_Y2,ROOMNITE_VARIANCE_Y2,RATE_TOTAL_Y2,RATE_GOAL_Y2,RATE_VARIANCE_Y2,REVENUE_TOTAL_Y2,REVENUE_GOAL_Y2,REVENUE_VARIANCE_Y2,
TENTATIVE_ROOM_BOOKED_Y2,TENTATIVE_ROOM_RATE_Y2,TENTATIVE_ROOM_REVENUE_Y2,NET_BOOKED_Y3,NET_CANCELLED_Y3,NET_SLIPPAGE_Y3,ROOMNITE_TOTAL_Y3,ROOMNITE_GOAL_Y3,
ROOMNITE_VARIANCE_Y3,RATE_TOTAL_Y3,RATE_GOAL_Y3,RATE_VARIANCE_Y3,REVENUE_TOTAL_Y3,REVENUE_GOAL_Y3,REVENUE_VARIANCE_Y3,TENTATIVE_ROOM_BOOKED_Y3,
TENTATIVE_ROOM_RATE_Y3,TENTATIVE_ROOM_REVENUE_Y3,NET_BOOKED_Y4,NET_CANCELLED_Y4,NET_SLIPPAGE_Y4,ROOMNITE_TOTAL_Y4,ROOMNITE_GOAL_Y4,ROOMNITE_VARIANCE_Y4,
RATE_TOTAL_Y4,RATE_GOAL_Y4,RATE_VARIANCE_Y4,REVENUE_TOTAL_Y4,REVENUE_GOAL_Y4,REVENUE_VARIANCE_Y4,TENTATIVE_ROOM_BOOKED_Y4,TENTATIVE_ROOM_RATE_Y4,
TENTATIVE_ROOM_REVENUE_Y4,NET_BOOKED_Y5,NET_CANCELLED_Y5,NET_SLIPPAGE_Y5,ROOMNITE_TOTAL_Y5,ROOMNITE_GOAL_Y5,ROOMNITE_VARIANCE_Y5,RATE_TOTAL_Y5,
RATE_GOAL_Y5,RATE_VARIANCE_Y5,REVENUE_TOTAL_Y5,REVENUE_GOAL_Y5,REVENUE_VARIANCE_Y5,TENTATIVE_ROOM_BOOKED_Y5,TENTATIVE_ROOM_RATE_Y5,
TENTATIVE_ROOM_REVENUE_Y5,NET_BOOKED_Y6,NET_CANCELLED_Y6,NET_SLIPPAGE_Y6,ROOMNITE_TOTAL_Y6,ROOMNITE_GOAL_Y6,ROOMNITE_VARIANCE_Y6,
RATE_TOTAL_Y6,RATE_GOAL_Y6,RATE_VARIANCE_Y6,REVENUE_TOTAL_Y6,REVENUE_GOAL_Y6,REVENUE_VARIANCE_Y6,TENTATIVE_ROOM_BOOKED_Y6,TENTATIVE_ROOM_RATE_Y6,
TENTATIVE_ROOM_REVENUE_Y6,OUTSIDE_CALLS_ACTUAL,OUTSIDE_CALLS_GOAL,CUSTOMER_VISITS_ACTUAL,CUSTOMER_VISITS_GOAL,TELEPHONE_CALLS_ACTUAL,
TELEPHONE_CALLS_GOAL,REVENUE_OTHER_GUESTROOM,DATE_BEGIN,DATE_END,ARRIVE_AFTER


Please let me know if you still need further information.


Uday.

 

[ptheriault]

Since the data is already in a RDBMS you can just use DTS or SSIS. I'm not sure which since you haven't told us what version of SQL Server you are using. Also is this a one time only copy?
Please provide us with as much information you have.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[udayit55]

Hi Paul,
I'm using SQL Server 2005. Frankly speaking I've never worked on SQL Server 2005. This is my first assignment.Hence, the difficulty. Please let me know if you need any further information.

 

[ptheriault]

I can understand and we are here to help. But we need all the information you have.
1. Is this new table for reports
2. Is this a one time copy?

We can not help you or give you the best solution if we don't have all the facts!


- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[udayit55]

Yes this table is for Reports and I'm using Crystal Reports 8.5. I'm done wid the design of the report but stuck with the database work. And about the one time copy even I'm not sure. Can you please tell me how can I find it.

 

[ptheriault]

Are these databases on the same server or different?
If different,
from the one of the servers.
click start->run type DTSWIZARD <hit enter>

follow the steps outlined in the wizard. You will need to supply login information to both databases.


- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[udayit55]

It prompts me for a destination...what should be the type and sever for the destination....and then asks me to select the tables to be moved...to the destination...what do i do now...

 

[ptheriault]

The destination is the name of the server and database that has your new table.
The source is where the data currently is.

Do you know then name of the table that you are getting the data from?

If you don't... get it, you can't do anything without it.

- Paul
- If at first you don't succeed, find out if the loser gets anything.