New answers tagged ssis
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 ...
-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
- 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')
)
...
- 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 ...
- 126
Top 50 recent answers are included