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
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')
)
...
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 ...
Top 50 recent answers are included
Related Tags
ssis × 1052sql-server × 650
sql-server-2008-r2 × 96
sql-server-2012 × 95
sql-server-2008 × 88
etl × 67
ssis-2012 × 66
sql-server-2014 × 49
sql-server-2016 × 42
sql-server-agent × 41
ssms × 30
visual-studio × 29
ssis-2014 × 29
oracle × 28
t-sql × 25
ssdt × 25
permissions × 19
sql-server-2017 × 19
data-warehouse × 18
jobs × 17
excel × 17
ssis-2016 × 17
sql-server-2005 × 16
sql-server-2019 × 16
ssas × 15