to go from 2012 to 2008 your only option is to recreate the package from scratch.

you can go higher easily, sometimes without even doing a package upgrade, but not lower

have a look at https://stackoverflow.com/questions/6921105/given-a-filesystem-path-is-there-a-shorter-way-to-extract-the-filename-without

from your code above "path" is not a System.IO object but rather a string - so you should even just be getting an error on the...

as I told you above you need to test your system and see if they are required.

Nothing we may say should influence you on that - we may tell you...

google is your friend - sadly most people don't use it.

https://stackoverflow.com/questions/4095627/blank-lines-at-end-of-ssrs-csv-export

Please stop posting  the same question over and over.

you were given the answer before on https://www.sqlservercentral.com/forums/topic/the-tabular-view-feature-is-not-included-in-the-64-bit-standard-edition-of - and as you seem not to like the answer please go and read...

• This reply was modified 6 years, 4 months ago by frederico_fonseca.

That's not really the best way to do it as you have multiple "joins" to the same table when you can do it with a single one

try like this

            
April 24, 2020 at 10:00 pm
            
#3746210

            
            
                                                
        

Hi Frederico Fonseca,

Yes, that might change the collation of my database, but not that of TEMPDB. So any query using a #temp table would need to be checked (and...

Henrik - you can change its collation - just not as easy as doing it on Prem

see https://www.mssqltips.com/sqlservertip/5530/how-to-change-an-azure-sql-database-collation/

could you please explain in more detail the layout of your DV with regards to this transaction data, both hub, links and sats - having their DDL including indexes would...

you should have the indexes that are required to support your queries - having them as Columnstore or not will depend on your needs and on your testing that have...

SELECT REPLACE(oldvalue,'*', replicate('0', 12 - len(t.oldvalue) + 1)) newvalue
from (values 
         ('ABC*1')
       ...

• This reply was modified 6 years, 4 months ago by frederico_fonseca.

another one - just weeding out options as not quite sure of what the issue is.

EXEC xp_logininfo 'xxx'

and another option - it is possible that the user is setup on...

• This reply was modified 6 years, 4 months ago by frederico_fonseca.

its now necessarily as you think - just by looking at the image you have tasks running in parallel - maybe it was just timing of when you took the...

the way you have it setup it should execute them in parallel - except potentially the drop of indexes as that locks system tables - but that should be fast...

Test it - easy enough for you to create a table with normal compression and...