All Questions
Tagged with csv sql-server
67 questions
0
votes
1
answer
232
views
Import CSV to Oracle Script DB
I managed to export data from a table in an Oracle database in .csv format using SQL Plus.
I have this file locally.
Now I need to import this same .csv file into another table in another Oracle ...
1
vote
1
answer
1k
views
Can SSIS read the results of a stored procedure and write them to CSV, without populating a table?
My current workflow is as follows:
A 'Execute SQL Task' task runs a stored procedure that populates a table.
After this, a 'Dataflow Task' task does the following:
2A. Read every row from this table ...
- 1,267
0
votes
2
answers
628
views
How to Import 21k Comma Delimited Text Files having a few columns with quote delimited comma separated values into SQL Server
I inherited a broken process, need to fix it and I'm hoping you, my fellow DBAs, may have a few good solutions.
There's a Windows server folder containing 21,663 CSV files that need to be imported ...
- 1
0
votes
0
answers
304
views
I cannot write information to a filesystem file from my newly installed MS SQL Server
Hello and thank you for your help. I must write non-tabular information to a file. I have tried a few methods that invoke various stored procedures. The following SQL statement tests this and I ...
2
votes
5
answers
4k
views
Tsql help - doing a large update from CSV file to a table in ssms
I have been given a csv file with just ids in there and those ids are in a table in ssms with columns that require updating. Out of 90,000 ids in that table, only 83,000 of them require updating from ...
- 63
3
votes
2
answers
3k
views
Database Mail has incorrect encoding of CSV attachment
I have a procedure that generates a resultset, which I attach as a CSV file attachment in sp_sendmail. However, the resulting file is encoded UCS-2 LE BOM (according to notepad++). This causes the ...
- 45
1
vote
3
answers
4k
views
Japanese characters in VARCHAR column using Japanese_Unicode_CI_AS
I am loading a table with the Japanese names from CSV file that are changing into question marks into SQL Table. The table that is storing these values is a varchar column. I understand that the ...
1
vote
1
answer
5k
views
SQL Server BULK IMPORT Truncation error
I am trying to import a simple CSV file into a table on SQL Server 2017. The CSV file and table match each other in number of columns and data types. This is an extract of the CSV file:
UID,...
- 183
0
votes
3
answers
1k
views
Import daily csv with varying available headers
I receive a csv daily from an external company capturing feedback for us.
Unhelpfully the csv headings vary. There could be any combination of headers.
For example:
day1: heading1, heading2, heading3, ...
- 123
0
votes
1
answer
309
views
SSIS Import .csv
I’m new to SSIS and I’ve got an existing SSIS task which is importing a CSV file that has some unusual formatting.
The CSV has formatting like this:
TaskID, TaskName
ABC,Test Entry ABCD,Test’s ...
- 103
4
votes
2
answers
3k
views
using SQLCMD to export/extract data withot trailing spaces
I am trying to extract data from some of my tables using sqlcmd utility as SSMS does not generate appropriate csv-s for me.
My issue: all csv extract includes trailing spaces according to table ...
- 41
2
votes
0
answers
1k
views
Export and split QUERY results in multiple files
I would like to know if it's possible to export and split query results in multiple files. Let's assume I have a query returning 100 results and I want to save the results in 5 different csv files (20 ...
- 41
0
votes
1
answer
3k
views
MS SQL Server: Import Flat File with auto-increment ID
So I've downloaded a sample database. It originally didn't have an ID column so I inserted one in through Excel. Anyways, I went through DatabaseName > Tasks > Import Flat File and the usual ...
- 103
0
votes
0
answers
204
views
CommandLine for Exporting All MS SQL Tables to CSV
On my Mac, I have a docker container running an Ubuntu version of MS SQL. I have a DB running in it and I can access it via Azure Data Studio, and I can view each table individually and export it to ...
- 109
1
vote
1
answer
1k
views
How to Export MS SQL DB from Docker-Linux to Access format
I have a MS SQL database which is currently up and running on my Mac within a Docker container that is hosting the Ubuntu Linux version of MS SQL Server. I need to export the database to a format ...
- 109