if you use SSIS Catalog then you can specify permission at a project level and at a folder level.

see https://learn.microsoft.com/en-us/sql/integration-services/catalog/ssis-catalog?view=sql-server-ver16#Permissions

other permissions can be set at ssisdb level but those would...

• This reply was modified 2 years, 8 months ago by frederico_fonseca.

did you try and change it from TVF to ITVF? that can make a significant difference to most queries.

even if you don't wish to put the whole code it may...

you need to have the order by on the Dataflow Source sql - not where you insert into the table as per above.

when generating csv files in SSIS (which I avoid every time I can - powershell easier for it) I normally do the conversion/formatting on the extract sql so that for...

• This reply was modified 2 years, 8 months ago by frederico_fonseca.

see if this link helps you https://stackoverflow.com/questions/57278013/using-javascriptserializer-to-deserialize-json-c-sharp-type-not-supported-for

what errors you getting? and did you try debugging the code in case the error you get does not reflect the true error?

answer in my opinion is incorrect (or question badly formed) - see https://learn.microsoft.com/en-us/sql/database-engine/install-windows/supported-version-and-edition-upgrades-2022?view=sql-server-ver16, Migrate to SQL Server 2022 (16.x).

one thing is the "from" the other is the "after"

just to be sure you are indeed producing a Valid CSV

when you define your output file do you have the "text qualifier" set to " (double quote)?

on example below it...

have a look at the function on last post from Steve (sgmunson) at https://www.sqlservercentral.com/forums/topic/how-can-convert-hex-value-to-decimal-in-sql-server-2012

based on the 100k row limit I would nearly bet this is to generate files to load to a MySQL Instance using the "Load data Local" statement (this is the...

while still putting emphasis on what Jeff stated with regards to company data on a local PC I am still supplying what I consider would be the better approach to...

according to your where clause the output is right - so maybe you only interested on the rows where both start and end time are between your filter?

something like (starttime...

I would nearly bet that the QC server does not have the SPN's set or that the connection to that server is not being done using kerberos (thus being unable...

open the file with a hex editor and see what the values are - likely they are (were) in a codepage that you aren't using and therefore it seems wrong.

put...

CXPACKET is not bad on its own - it may only be an indication that some queries are going parallel when they don't need/or could work better serially.

so those cxpacket...