You can export the data as text files as long as you re-import the files to check it goes smoothly. People often find commas in csv fields...

You can export the data as text files as long as you re-import the files to check it goes smoothly. People often find commas in csv fields or unescaped...

thanks for the feedback.

Just for my own learning...what order should these tasks be done in?

I am not sure...

• This reply was modified 6 months, 3 weeks ago by water490.

Instead of moving processed files to a single archive folder, create a timestamped folder in the target folder and move the file there.

You will never get collisions if you...

issue fixed.  Adding IS_MS_SHIPPED = 0 removes the SP in question.

I have made some progress on this.  I had to change the FROM table and now I can see the creation and last modified dates.  However, the query is showing...

Does encrypting the DB cause performance issues (ie run time increases) for queries?

WITH ordered
AS (SELECT UNIT
          ,ORDER_DATE
          ,rn1 = ROW_NUMBER...

You could change the approach to use a script task to execute your powershell script.  However, if you can do this in PS - then you almost certainly can...

How are you specifying to run PowerShell, as a scripting task? Spitballing here, but could you run it as an Execute Process Task, with powershell.exe as the executable? Then...

I said 'add another THROW', not 'add another THROW 51000, '2. One or more stored procedures had errors, please investigate', 1;'!

Also, surely you want the INSERT to dbo.RunTimeErrors to...

Yes I did.  If I add the second THROW then the table...

No, only 1 TV is required. You simply run multiple INSERTS to it in your code.

To make the error appear in the SSIS Output window, you need to add...

Instead of logging your errors in a physical table (whose changes are being rolled back, I assume), log them in a table variable and then insert from the table...

• This reply was modified 8 months, 2 weeks ago by water490.