update thru ssis

Tech-Archive recommends: Speed Up your PC by fixing your registry

hello all,

i know ssis allows to insert from a csv file into sqlserver (2005) tables
but is it possible to either update and/or delete records with an ssis
package based on a csv file?

thanks for you help.


.

Relevant Pages

  • Re: INSERT new RECORDS into a table from another table
    ... i really dont know what to do after that to transfer it to the main ... Unless you have a reason to do otherwise, you might consider loading data diretly into the main table from the SSIS package. ... So what i am trying to do is dump some data form CSV file to a table ... I have learnt how to import data from the csv file to a data base ...
    (microsoft.public.sqlserver.dts)
  • ssis update or delete
    ... i know ssis allows to insert from a csv file into sqlserver tables ... package based on a csv file? ...
    (microsoft.public.sqlserver.tools)
  • Re: update thru ssis
    ... come on folks, ... I am willing to take up reading ... i know ssis allows to insert from a csv file into sqlserver tables ...
    (microsoft.public.sqlserver.dts)
  • Mapping columns of Flat File to DB table columns.
    ... How can we use SSIS for transfering data between flat file source to ... SqlServer DB existing table. ... Consider a scenario of an flat file where there is one column "Company ...
    (microsoft.public.sqlserver.dts)
  • Re: Import to dbase via excel
    ... Upload the csv file in a folder monitored by a SQLServer 2000 sheduled DTS. ... The only step of the DTS is importing the file in the db ...
    (microsoft.public.dotnet.framework.aspnet)