Thanks, and yeah GETDATE( ) or actually NOW( ) would be basically correct, I believe.

Note I have worked with so many languages sometimes the exact function names get a...

Edit your package in VS and change the definition of the flat file destination so...

@Phil Parkin,  simply a query which removes them from the rows that are selected.

I don't have any CREATE statements. I am just selecting rows from CTE.

You have >600 points, so...

By 'remove', do you mean you want these rows deleted from the database?

Or simply a query which removes them from the rows which are selected?

Please provide your sample data in...

GETNOW()? Do you mean GETDATE()?

Sounds like you're having a lot of fun with this one!

If you know the following two pieces of information:

a) How many chunks are required

b) How many rows are in the...

No worries.

If your intention is to make this completely dynamic, such that the usual inputs the table name and the desired number of chunks as a parameter, you are going...

This is an interesting one. This is what I would try, I think:

First, change the way that the file-naming works. I'd use a static file name (somefile.txt, or whatever), and...

HECK NO! I am not the same person as that weirdo spammer posting things about  hair removal after my sql server post.

FYI!

I am a real person as is pretty...

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 3 years, 3 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...