Integration Services (SSIS)

Technical Article

Trash Destination Adapter

  • Article

The Trash Destination is now available for SQL Server 2005 and SQL Server 2008. The Trash Destination and this article came from early experiences of using SSIS and community feedback at the time. When developing a package it is very useful to have a destination adapter that does nothing but consume rows with no setup requirement.

2008-03-10

1,272 reads

Blogs

Making a PostgreSQL Backup in a Container

By

I needed to back up a PostgreSQL database as a part of the repro...

Azure SQL offerings

By

There are three Azure SQL products with so many different deployment options, service tiers,...

T-SQL Tuesday #183 Roundup

By

I hosted this month’s T-SQL Tuesday party with my invitation asking about tracking permissions....

Read the latest Blogs

Forums

RLS Causing RBAR

By danielfountain

Hi all, First I want to ask just a generic question.  Does RLS in...

SQL2019 STANDARD max memory is 128Gb yet my Bufferpool exceeds this value

By PearlJammer1

Reading the Microsoft documentation it says SQL2019 STANDARD EDITION has a max memory of...

Having issues installing SSIS extension for VS 2022 Community

By daniel.manke

I have installed the SSIS extension for VS 2022 community. When I go into...

Visit the forum

Question of the Day

A Simple Choice

I have this data in a table?

CatIDCatName
3Monitors
What is returned when I run this code?
SELECT CHOOSE(catid, 'Laptops', 'PCs') FROM dbo.Categories AS c
 

See possible answers