The tag has no wiki summary.

learn more… | top users | synonyms

-1
votes
0answers
18 views

How to see the reject/re-direct reason for rows in SSIS? (row-level) [migrated]

I use SSDT (aka SSIS or BIDS 2012 or Visual Studio 2010): I have a data conversion step and some of my rows are rejected (i.e. redirected to a reject text file). Everything is great and it seems like ...
0
votes
1answer
12 views

Field Prerequisite on Another

I would like to know if it's possible to have two fields (in this case bits) in the same table where one is prerequisite on another. For example Check2 may only be true if Check1 is true. Note: I'm ...
0
votes
1answer
79 views

Comparing Column Value and Display the Differ Column

Supposed I have table temp A and table temp B, IF OBJECT_ID('tempdb..#A') IS NOT NULL BEGIN DROP TABLE #A END IF OBJECT_ID('tempdb..#B') IS NOT NULL BEGIN DROP TABLE #B END CREATE TABLE #A ( ID ...
0
votes
1answer
24 views

Multiple queries and a report

im fairly new to databases. I have multiple query's that i normally run individually at the end of loading data to my table doing simple integrity checks like length ,char types and so on (see ...
0
votes
1answer
50 views

Compare table content from different PostgreSQL 9.3 DBs

The problem How do I efficiently and idiomatically compare the content of two tables, each in a different DB? I have 3 DBs (the classic dev, stg and prod). Each DB has a few tables which should be ...