Questions tagged [mssql-tools]
9 questions
3
votes
1 answer
What does it mean when BCP fails ("BCP copy in failed"), but not -e error log contents generated?
Using BCP from mssql-tools on CentOS7 and trying to copy some TSV data into a local MSSQL DB, BCP fails to do the copy and throws error "BCP copy in failed". The command being run is:
TO_SERVER_ODBCDSN="-D -S…
lampShadesDrifter
- 3,925
- 8
- 40
- 102
3
votes
1 answer
Docker Login Failed Using mssql-tools
SSMS connects just fine. Run this code in PowerShell to duplicate the following error.
Any advice? Thanks!
Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Login failed for user 'SA'..
docker pull mcr.microsoft.com/mssql/server
#Sql Server…
Ian Frantz
- 41
- 3
3
votes
2 answers
How to install Microsoft Drivers for PHP for SQL Server on Amazon Linux AMI
I am trying to install Microsoft Drivers for PHP for SQL Server using the document provided by Microsoft. Link is https://github.com/Microsoft/msphpsql
It provides installation steps for Ubuntu and Redhat but not Amazon Linux. To install Microsoft…
Ravinder Reddy
- 3,869
- 1
- 13
- 22
1
vote
1 answer
BCP throwing "String data, right truncation @#" even though data types match
Attempting to copy a TSV file data into an MSSQL DB via bcp from mssql-tools package. Getting bcp error logs of the form:
#@ Row 1, Column 20: String data, right truncation @#
"1234" "ASDFG Z ZXCCVVB" "Physician" "ASDFG ZXCVB" "" "" "" "" …
lampShadesDrifter
- 3,925
- 8
- 40
- 102
0
votes
2 answers
kubernetes pod (mssql-tools) failing with CrashLoopBackOff error and restarting
I'm using Rancher Dekstop for K8 in WSL 2 in Windows 11.
I'm trying to create a pod using the simple yaml:
apiVersion: v1
kind: Pod
metadata:
name: mssql-tools
labels:
name: mssql-tools
spec:
containers:
- name: mssql-tools
image:…
Farrukh Waheed
- 2,163
- 2
- 29
- 59
0
votes
0 answers
How to execute a data script from inside of a .dacpac file (SSDT project) using powershell or any other tool?
When I publish an SSDT project, as shown in the attached image, it generates the .dacpac file. From that .dacpac file, I want to execute a specific script after publishing the .dacpac. Is it possible to do so? I mean is it even possible to access…
Mukesh Kumar
- 656
- 5
- 26
0
votes
1 answer
Apple Silicon M1 + docker
I have a dockerfile and docker-compose that works fine on Intel and/or AMD based chips, but there are some issues when it's expected to build on a M1 Apple Silicon chip.
It follows the errors:
#6 12.11 Reading state information...
#6 12.16 E:…
Felipe Novaes
- 73
- 1
- 5
0
votes
1 answer
How to run docker-based mssql-tools using a regular way
I have installed a mssql server using docker microsoft/mssql-server-linux. It behaves the same as a regular mssql server. i.e my client can access it exactly the same way they access a regular mssql server.
Now I am installing mssql-tools using…
user389955
- 9,605
- 14
- 56
- 98
0
votes
0 answers
Dumping data from view to excel
In a database one view is there,every day that view updted with adding one new column,now i want to design a ssis package to dump that data into excel sheet each day with seperate sheet. Can anyone please help me out of this. Thanks in advance
THEJESH THEJA
- 1
- 1