Hi MMartin1

Thanks for your response, while my tables do have check and RI constraints I also use surrogate keys and therefore most of my data import type packages perform some...

Your project sounds cool. An 'expected format' validation has been on my wishlist for awhile and while I try to live

there is always enough time to do it right

......

Hi Phil

The scenario I am trying to deal when importing data from a flat. End result is if any of the data in the flat file is invalid, e.g. required...

Hi Phil,

Thanks for the input. Yes I think I am going to a RAW file mainly because I discovered while there is a Record Set Destination there is no Record...

Hi John, BrainDonor

I had obviously missed the the whole SET Col1 = Col1 part, thanks very much for that.

As for the default being a value never used that is...

Hi durga.palepu

Thanks for the quick response.

For sample data, so keep things simple, assume the following structure

CREATE Table UpdateTest (ID INTEGER , Field1 CHAR(5) NULL, Field2 CHAR(5) NOT NULL)

INSERT dbo.UpdateTest...

Hi pietlinden,

Thanks for the quick response.

So I guess what your saying is there is no way to do what I want.

Disappointing to say the least. I don't think the DBA's...

Thanks for the link pietlinden.

I was having a hard time find stuff that was related to actually producing the report

Cheer,

Steve

Thanks Spiff. I have never had to admin a Report Server before, obviously 🙂

Hi Ansuman,

Thanks for the reply... actually that is what I am currently doing and I should have said that, my bad.

My general philosophy when writing code is to make...

I haven't used the List before either, will give it a go.

Thanks again Spiff, enjoy the weekend!

Steve

Hi Spiff,

I have never tried putting a group in rows directly above the detail that way before, I might give it a go. Though I had thought, and this might...

Thanks John, this is definitely a much better approach and gets me where I wanted to be in terms of it being configurable via my application admins.

Take Care,

Steve

Hi John,

Actually I was thinking, and would prefer, that it would be a value in a table however I couldn't think how I might JOIN that table to all tables...

Hi Gail,

Thanks for the quick response.

My background programming so the idea of create a class/method to do this is 2nd nature that is why I want to ask on...