New answers tagged

0 votes

Error message when importing data into SQL (Import & Export Data Wizard)

Just want to share a file from Microsoft which has helped me to allow an easier import. I believe using this method will get around some of the conversion errors which may be difficult to locate and ...
user avatar
-1 votes

SQL Server Data Tools - Data Link Properties - Server Name Drop Down Empty

just copy your server name from sql server MSSM and add it manually by typing it
user avatar
  • 1
0 votes

Finding and locally deleting deleted records in a million-record table

try this merge statement... with trg as ( select RECID, LASTMODIFIEDDATEANDTIME, column1,column2 FROM targettable ), src as ( select * from openquery(linked_server_name,'select * from soucetable') ) ...
user avatar
  • 3,462
0 votes

SSIS Package is writing corrupt data, but only when run as a Job

After patching the SQL Server to 15.0.4223 it started to work 99%. There is a string column that is inserted into a number column in the target database. While that worked before, this still produced ...
user avatar
  • 126

Top 50 recent answers are included