Hi Martin,

please see this - https://www.sqlservercentral.com/forums/topic/how-create-a-google-bigquery-connection-manager-in-ssis

I am trying to use a google bigquery connection. However It seems not so straight forward as I cant seem to find the connection...

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

with that I totally disagree - server should have 64 bit version - and workstation should have the one matching the VS version you have (32 bit if lower...

Yes, despite some rather "hacky" solutions, you can't have the x86 and x64 Redistributables installed on the same system.  Ideally, you have the one that matches what's on the...

The app is just display engine... I use the PS to export from mssql and load to PG...

This piece of code is the issue.

# Convert the image data to...

If it were me, I'd push exactly the same image into both DBs using the app.

Then you've got something to aim for.

The question is am I'm using the correct code to capture the image from mssql to csv export. It seems that when loaded to PG db that the size...

What is your question?

But other procs execute ok?

I'm thinking along similar lines to Ken, except I'd get the data over to a staging table on the linked server and then execute a proc on the linked server...

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

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...