What technique are you using to create the files? A data flow within a loop, perhaps?

What method are you currently using to name the files? Script task? Dynamic variable? Something...

However, this query is very simple. It is literally just select column one column two column 3 from table and then there is an order by and a fetch...

• This reply was modified 2 years, 6 months ago by Phil Parkin.

I must be missing something, but can't you just replicate what's on the server, in terms of drivers?

Those data conversion errors should be investigated in VS. Are they completely bogus, or maybe there is an easy fix?

The other error I have never seen before.

I suggest that you run one or two of these 'dynamic' queries in SSMS and take a look at the actual execution plan. I agree with Jeffrey in that it...

Can I ask why you do not want to use temp tables? For a query of this length, there is a reasonable chance that the 'divide and conquer' approach which...

It's been so long since I've used 2008, I have no idea. Config files have been replaced by SSISDB environments and I suggest that that is the ideal way forward...

Is the file at the location mentioned in the error? If not, the message seems reasonable.

I'm assuming you mean something more than comments in the code itself? Where are you expecting/hoping the help will be displayed?

Out of interest, can you try this version?

INSERT ...
SELECT TOP((@i_sequence_end - @i_sequence_start + 1) / @i_inc_val)
       value = (ROW_NUMBER () OVER...

OK, is the SQL Server service running under the same account as one of the users you have tested?

Are you saying that permissions have definitely not been changed?

Have you got multiple versions of PowerShell installed? Eg 5.x and 7.x

Sounds like there may be an error occurring which is forcing the window to close despite the Sleep.

Try this instead:

Read-Host -Prompt "Press any key to continue"

though I don't expect it...

A source control repository contains a (technical term) bunch of files which form some sort of logical grouping. That grouping is your choice.

An example repo would be 'Databases'. This could...