dbTalk Databases Forums  

Loading files into database with incomple data

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


Discuss Loading files into database with incomple data in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Andre
 
Posts: n/a

Default Loading files into database with incomple data - 08-20-2008 , 12:19 PM






Hi, all,

I have the following scenario:
I have one file with multiple lines, but each table's record may
contain data regarding more than one line of the file.

The key is the same, but two lines of the file may have different
parameters and they should be joined and loaded into a single record
of the database.

How should this be done? May I create a temporary table with a 1:1
mapping for file / database and then run execute another SQL statement
joining this data?

Thanks,

--
Andre

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.