Re: Importing Multiple text files into one sql table

anonymous_at_discussions.microsoft.com
Date: 03/16/04 

Date: Tue, 16 Mar 2004 11:36:37 -0800

no

>-----Original Message-----
>OK
>
>1 - 6 are the same except the destination is your working
table
>After step 6 i.e. once all the files in the directory
have been loaded to
>the working table you then need to run a series of TSQL
statements in an
>ExecuteSQL task.
>
>
>You will build these up by
>
>Inserts:
>
>The key of the rows on the working table do not exist on
your real table
>
>Deletes
>
>The key of the rows on your real table do not exist in
your working table
>
>Updates
>
>Keys on both working and real table match and values have
changed in the
>attributes
>
>Does that help enough?
>
>
>
>--
>
>Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
>www.allisonmitchell.com - Expert SQL Server Consultancy.
>www.SQLDTS.com - The site for all your DTS needs.
>I support PASS - the definitive, global community
>for SQL Server professionals - http://www.sqlpass.org
>
>
><anonymous@discussions.microsoft.com> wrote in message
>news:e25301c40b78$fa1074a0$a401280a@phx.gbl...
>> Sorry, this doesn't help me enough.
>>
>> Are you refering to step 5, (Data transformation?)
>>
>> What exactly is the code neeeded and where do I put it
>> (Which step)?
>>
>> Thanks,
>>
>> Paul
>>
>>
>> >-----Original Message-----
>> >I never do anything too special with a text file so I
>> would modify slightly
>> >
>> >Start Loop
>> > Pump text file to working table
>> > Use TSQL in ExecuteSQL task to do your UPDATE,
>> INSERT, DELETEs
>> > Loop around
>> >
>> >--
>> >
>> >Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
>> >www.allisonmitchell.com - Expert SQL Server
Consultancy.
>> >www.SQLDTS.com - The site for all your DTS needs.
>> >I support PASS - the definitive, global community
>> >for SQL Server professionals - http://www.sqlpass.org
>> >
>> >
>> >"Paul" <anonymous@discussions.microsoft.com> wrote in
>> message
>> >news:e56601c40b72$bd873ab0$a101280a@phx.gbl...
>> >> Looping, Importing and Archiving found at :
>> >> http://www.sqldts.com/?246
>> >>
>> >> How can the package above be re-written to append
data
>> >> from multiple files to one sql table, instead of
>> importing
>> >> the entire file again?
>> >>
>> >> Thanks
>> >
>> >
>> >.
>> >
>
>
>.
>

Relevant Pages

  • Re: which authentication mechanism should I use?
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... Set the SQLStatement property of the following ExecuteSQL Task ... >> Allan Mitchell MCSE,MCDBA, ... >>> I'd love to use ExecuteSQL task but I don't know how to execute it from my activeX. ...
    (microsoft.public.sqlserver.dts)
  • Re: Why Oracle does not allow rollback of DDL statements?
    ... TSQL did suffer from a lack of modern exception handling. ... So I think we cannot blame transactional DDL for lacking of exception handlers. ... When porting SQL Server apps to another DBMS the problem of lost errors is a major issue in general since TSQL developers have this nasty tendency to only do error checking wherher they think an error could appear. ...
    (comp.databases.oracle.server)
  • Re: DTS object model
    ... Can I do validation & mapping, if I use BulkInsert Command in TSQL? ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... I want to create a text file connection and set the ...
    (microsoft.public.sqlserver.dts)
  • Re: XPSMTP parameters
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... >> I am going to presume that you want to do this in an ExecuteSQL task. ... >> Allan Mitchell MCSE,MCDBA, ... >> I support PASS - the definitive, global community ...
    (microsoft.public.sqlserver.dts)
  • Re: Access Project
    ... Although I have never worked in an Access ADP I believe you need to use TSQL ... You probably want to replace the IIF() constructs with TSQL CASE function. ... Sql Server BOL has a good explanation and lots of examples. ...
    (microsoft.public.access.forms)
Loading