ActionType VARCHAR(50)

Seemed excessive ?

Could be ActionType VARCHAR(6)

for:

UPDATE, INSERT, DELETE

?

As per Jeff's comment:As per Jeff's comment:

DELETE FROM TableA
WHERE EXISTS (SELECT 1
FROM TableB
WHERE TableB.DeleteDate = TableA.RecDate and TableB.ID = TableA.ID);

Because of duplicates in TableA on ID and...

• This reply was modified 5 years, 2 months ago by  allan.ford17.

Thinking further, I want to capture the success and error counts coming out of the  "Insert Destination" component and not prior to this component.   i.e. counting insert attempts (will be...

I managed to resolve this issue for one of my SSIS projects.

I did this by putting the dtsx file back in place as per wanted by the project/solution and then...

I found some help here on viewing with and working with SSIS user variables.

i.e. see:
https://docs.microsoft.com/en-us/sql/integration-services/add-delete-change-scope-of-user-defined-variable-in-a-package?view=sql-server-2014 

especially this step:
On the SSIS menu, click Variables. You can optionally display...

Lots of excellent advice and answers .. thank you all  .. 

Appreciate warnings from Jeff about the ISNUMERIC function.

For what I wanted .. rough data profiling .....

Does anyone have data examples? e.g. what is allowed and not allowed in each of varchar and nvarchar ?
e.g. for a surname ... should nvarchar be used ? or...

The answer to my own question is to deploy process from Visual Studio .. and then create a job in SSMS and schedule it ..
and monitor it via the...

I progressed with an SSIS ETL design and was happy with end result.
Some notes as per these:
http://members.iinet.net.au/~allanford17/A_Stock_Standard_ETL_Process_Using_SSIS.htm
https://github.com/foral66/SSIS-standard-ETL

actually ...
I am getting an error from this expression regarding null values ..
0xC0049067    -1073442713    DTS_E_EXPREVALSTATIC_FUNCTIONCOMPUTEFAILED    An error occurred while evaluating the function.
even though I have tried to cater for nulls...

I worked out a solution for myself for this question ..

I had to open the Lookup component, and use the checkboxes to mark more columns in the "available lookup...

I think I was in some kind of state where I was looking at a data flow ... but didn't have solution open ..
i.e. along these lines ..

Thanks for this reply Sue.

An excellent online training course for SSRS by Lynda.com is  ":Followers