Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need help in populating data into the tables...

Status
Not open for further replies.
udayit55

udayit55

Technical User
Jun 12, 2007
16
US
Hi

I'm new to SQL Server 2005 and I have the tables created already by another person earlier..but the tables are not populated, I need to fill in the data tables in the data base with an already existing database which holds the raw data.


Backlog
Actual Raw Database -------------------> Summary database

The above was a pictorical view of what my data looks like...Now I need to extract the information from the raw database to the summary database.
 
Sort by date Sort by votes
You would use SSIS Import wizard. Where is the data? Is it on another server or another database or a flat file? Do you need to transform the data in any way? You haven't really provided us with enough information.

- Paul
10qkyfp.gif

- If at first you don't succeed, find out if the loser gets anything.
 
Upvote 0 Downvote
Thanks for the reply..and I'm really sorry abt that...

Now...first I'm using crystal reports and trying to connect to the database...finally i was able to do it and when i created a report i was surprised to see there was no data on it...then i queried the SQL Server dB to find that there was no data...There were just the tables...i mean the tables were created...but when I asked my tech lead abt it he said...v already have the data and the current proj shud hit the already existing data or the backlog file to fill the data to the current database... can some one help me with this...or do i need to be more clear...
 
Upvote 0 Downvote
What is the "backlog file" is it a flat file on the server somewhere.

- Paul
10qkyfp.gif

- If at first you don't succeed, find out if the loser gets anything.
 
Upvote 0 Downvote
I guess so...So what do I do now...how do i extract the data into my SQL Server from the 'BACKLOG' file...
 
Upvote 0 Downvote
I guess so...So what do I do now..
Click to expand...

First: Find out for sure if it IS a flat file on the server!

Second: Find out where the file is.

Thrid: Create an SSIS package to import the data into the table!

- Paul
10qkyfp.gif

- If at first you don't succeed, find out if the loser gets anything.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question
SQL Server in Windows
Replies
1
Views
262
pjw001
pjw001
grnzbra
  • Locked
  • Question
Get Excel Data > 255 Characters
Replies
3
Views
225
grnzbra
grnzbra
CodeWell
  • Locked
  • Question
SQL Server 2017 Install Issue - Database Not in Configuration Manager
Replies
0
Views
247
CodeWell
CodeWell
RRinTetons
  • Locked
  • Question
Logging into a database using SSMS from non-domain machine
Replies
1
Views
220
fredericofonseca
fredericofonseca
TheBugSlayer
  • Locked
  • Question
High Availability - insert fails on primary replica but runs on secondary after failover.
Replies
0
Views
173
TheBugSlayer
TheBugSlayer

Part and Inventory Search

Sponsor

Back
Top