I am trying to import a simple CSV file into SQL Server using the SSIS. I have been unsuccessful so far. Spent hours but cant figure out. Please assist.
Please Check the attached Word Document for details and Screenshots
Created tables with this query…
CREATE TABLE [dbo].[TestCSVUpload](
[OrderDate] [nvarchar](255) NULL,
[Region] [nvarchar](255) NULL,
[Rep] [nvarchar](255) NULL,
[Item] [nvarchar](255) NULL,
[Units] [numeric](18, 0) NULL,
[Cost] [numeric](18, 0) NULL,
[Total] [numeric](18, 0) NULL
) ON [PRIMARY]
Placed [testIncomingTbl.csv] in a certain folder for connection string (attached the csv file in question)
a. In SSIS, added a Flat File Source
Created connection manager for it in SSIS like this>>
Create OLE DB Destination in SSIS
Connect the green arrow from Flat File Source to this [OLE DB Destination]
Under the OLE DB Destination Editor, assigned the table as the target destination
Now this is what I am getting now >>>>
Spent hours trying to change the column formats but to no avail, this keeps showing up.
Provided the source CSV File in the question and also given the Query need to create a table in server for getting this csv data set.
Not sure where I am missing anything…