thx phil do you mean data flow in the cloud service or more down to earth as in ssis?   i noticed in a separate post you mentioned an ssis...

Please take a look at this link. It's easier than you think!

https://www.tutorialgateway.org/copy-files-using-file-system-task-in-ssis/

But I usually use a Script Task when performing file operations. You get a greater level of flexibility...

Importing data from a specific Excel range is perfectly doable – and that range can be a single cell. No need to resort to PBI or VBA, just a standard...

Not that I know of. However, I suggest that you add some steps to your process which help handle the issue.

Step 1: copy the file from source to a path...

I'm away from a proper PC at the moment, so could not come up with any possibilities. But as you make no mention of DAX in your post, is there...

If you read the help for sp_ExecuteSQL, you can see that this point is explicitly mentioned:

sp_executesql has the same behavior as EXECUTE regarding batches, the scope of names, and database context. The...

Thank you. While I may have...

That all makes sense! Thanks for explaining and well done on solving it.

That is not a query … it looks more like a proc. definition.

Does it time-out from within SSMS, or is this called from somewhere else?

Sure. This method creates a temp table containing the desired results & then modifies the main table via a DELETE followed by an INSERT.

If there are millions of rows in...

You have set things up using the legacy method of deployment. Have you done this deliberately? If not, please consider deploying your packages to SSISDB and configuring parameters using SSISDB...

This gives you close to what you have asked for (but using a temp table, for convenience):

DROP TABLE IF EXISTS #Priority;
 
CREATE TABLE #Priority (Airplane NVARCHAR(50) NULL,...

• This reply was modified 12 months ago by Phil Parkin.

Running out, I'm afraid. I haven't used packages deployed to the file system for years. I would guess that there's something going on with .NET versions, but the errors you...

OK, got it!

My next suggestion would be to create a simple script task that does nothing external, eg

int z = 1;

and delete the script component and then try running it...

Deleted

• This reply was modified 12 months ago by Phil Parkin.