Have an Execute SQL task that gets the value you need from the destination, and then configure your data flow so that it only imports the data you require according...

I think if you use your favourite search engine to search for "Is there any query to get the size of all indexes in a database", you'd get the answer...

Whilst that's true in the strictest sense, all but the simplest of packages should...

I'm not totally clear what you're trying to do, but have you tried CROSS JOINing the two tables?

John

I know it's not what you're going to want to hear, but every environment, every workload is different. I'm afraid you're going to need to make the change (preferably...

OK, so HAVING isn't going to work. But never mind. What you're looking for is something like this:

BETWEEN...

Changing the fill factor in the way you suggest is likely to have a positive effect on write performance (because there will be fewer page splits) but a negative effect...

The parentheses still don't match.

TRUNCATE isn't an aggregate function in T-SQL, as far as I know. What does it do in MySQL? If you could supply some table...

I don't think that will even parse, since (a) you've used HAVING instead of WHERE and (b) your parentheses don't match. Also, why do you declare @trig and not...

OK, you seem to have changed your collation, so here's what to do in general:

(1) Go on to Wikipedia and search for "code page xxxx" where xxxx is the three...

You haven't shown what the data in your table looks like, but I think I can picture it.

It looks as if you have three options:

(1) Pivot in Excel then load...

If removing the space before the Z doesn't do it, please post table DDL in the form of CREATE TABLE statements, sample data in the form of INSERT statements, and...

If you want to fragment your indexes, you'll need to make lots of modifications - inserts, updates and deletes. Try to choose operations that change data in index key...

If you've got an environment variable package configuration, I think you need to restart SQL Server after you add or change it.

John

This indeed returns 0:

SELECT CAST('' AS int)

It's just the way it works. I suppose when the DBMS or the standards were being written, somebody decided that '' would convert...