Thanks for what? Did you understand my post?

Presumably this is in SSIS?

What is the source system? Are you sure that the value, at database level (rather than when viewed through an app, for example), is as you...

Can you provide some consumable sample data?

If a single account has multiple rows, how are those rows to be ordered?

We've got upwards of 40 SSIS solutions all stored in one GIT repository in teams.  I thought this was the proper way to go.  The problem is managing this...

That was an artifact of me testing different combinations of values and nulls....

DECLARE @Var1 DATETIME = NULL
       ,@Var2 DATETIME;

SELECT Result = CASE
           ...

The LEFT_SHIFT and RIGHT_SHIFT functions in SQL Server provide an efficient way to manipulate numbers at the binary level. These functions are indispensable in tasks like data encryption, compression, and...

Save yourself the trouble and install Redgate's SQL Search (link).

Can I ask why you have set a custom page size, instead of 8.5 x 11?

To make sure you avoid the blank page issue, you need to be sure that

Palette...

Are you able to post images showing the Report Properties?

Can you post your code?

Just for clarity, are you saying that they are generating INTs (or whatever) as keys in dim tables as part of a DW load and that those INT values can...

• This reply was modified 1 years, 7 months ago by Phil Parkin.

This may be relevant:

https://community.fabric.microsoft.com/t5/Power-Query/ODBC-ERROR-07002-Snowflake-ODBC-10690-Expected-descriptor-record/td-p/3194442

Perhaps try making the proc very simple and seeing whether the error goes away. If it does, you will know that the problem relates (somehow) to...

1. Are the file paths local to the server on which the command is executing, or on a network?
2. Does the account running the SSIS package have the necessary rights...

The following solution assumes that the data should be ordered by (DocEntry, Itemcode)

DROP TABLE IF EXISTS #Test;

CREATE TABLE #Test
(
    DocEntry INT NOT NULL
 ...