All geek questions in one place

How to update SQL table with CSV data?

I am trying to update one of my SQL tables with new columns in the source CSV file. These CSV records in this file are already in my SQL table, but they are missing some columns from this CSV file.

I have already added new columns to the SQL table. But now I just need to import data from the new columns. How can I do this best?

I am trying to use SSIS 2008 for this. I created a CSV data source with a flat file. Then I added the OLE DB command. And I installed the SQL command as follows:

update berkeley.dbo.j5c_ALL_DATA 
set disabilitycode=[Stu Pri Dis],
IEPID=SpecED
,[MT_AR_CR]=[Met At-Rsk Crit]
      ,[ECP]=[Early Childhood Program]
      ,[REF_CFC]=[Ref by CFC]
      ,[IEP_COM_DT]=[IEP Cmp Date]
      ,[E1_NUM]=[EI Nbr]
      ,[RDIT]=[Reason for Delay in Transition]
      ,[MT_PFA_HI]=[Met PFA Inc Crt]
      ,[FS]=[Family Structure]
      ,[Hm_Sch_RCDTS]=[RCDTS Home]
      ,[Srv-Sch_RCDTS]=[RCDTS Serve]
from berkeley.dbo.j5c_ALL_DATA A join Berkeley_CSV2 b ON
A.studentid = B.[SAP ID] and A.BegEnrollDate = B.[Enroll Date]

where Berkeley_CSV2 is the name of my connection manager for flat CSV files. But at the same time I get an error message:

The connection manager "Berkeley_CSV2" is an incorrect type.  The type required is "OLEDB".  The type available to the component is "FLATFILE".

Can anyone recommend me an alternative way to add this data or another SQL command?

+3
1

- . ; .

. . , , . , SSIS.

SSIS OLE DB , - . , , .

. " " " " . OLE DB . .

OLE DB . Control Flow ( ) OLE DB. , OLE DB.

SQL script OLE DB, . script . , SQL script .

+5

Source: https://habr.com/ru/post/1761812/

More articles:


All Articles