.SQL files are not...

No apologies are needed here!

What I assumed you did was as follows:

a) Have a sheet called AllDogs in your trial spreadsheet ... imports successfully.

b) Have a sheet called (whatever) in...

So this bit

BTW, I did try renaming the sheets after the C & P to no avail

wasn't quite true? 🙂

Changing your code to accommodate the space character should be trivial.

Can you create a couple of screenshots & paste them in, as follows:

1. Showing the trial Excel file, with headings & first 10 rows
2. Showing the prod Excel file, with...

• This reply was modified 6 years, 3 months ago by Phil Parkin. Reason: Fix typo

I don't understand the logic for setting rownum. Can you explain it, please?

Sheet names being different is critical ... unless you are handling it dynamically in your package, which is a little advanced.

Try renaming the sheet after cut & paste from trial...

Are you using code (rather than a data flow) to transfer the data? If so, please explain why. And consider adding some TRY/CATCH error handling to help you diagnose the...

I sympathise!

On which component is the error happening, exactly?

Are your production files stored locally, or on a network drive somewhere?

I usually have a bad reaction when people use absolutes. Never say never 🙂

            
October 8, 2019 at 12:44 pm
            
#3686952

            
            
                                                
        

Hi folks, I have a 2012 sql and it works very fast, one of the most used queries is a table function. This function over time becomes slow and...

I imagine that you've called your variable something like 'FileName', and not "C:\SCRIPTS\SQLServersExport_20191007.csv"!

Thus, I suspect you need to revisit the various relevant properties in your package components, looking for incorrect...

Please expand on what you have provided, to include

a) Your question

b) Which line throws the error, and an outline of what you are trying to achieve

C#, maybe.

As long as max level is the same for all of the lowest-level items, that is. Otherwise, it gets trickier.

Add hierarchy level to your CTE and base your selection on that?