I was able to find the package in Execute Package Utility.

The unicode character that looks like a hyphen...

The hyphen might be a non-breaking hyphen. Here's an example of how it behaves:

declare @test-2 table (a nvarchar(10));

insert @test-2 values ('abc-def'), ('abc' + nchar(0x02010) + 'def')

select...

David McKinney (3/23/2016)

---

A slight variation (although I've not got SQL installed to test it.)

CONSTRAINT ck_xxx CHECK ('' not in (c1,c2,c3,c4,c5))

Would you kindly check and let me know if...

Change: WHERE row_num = MAX(row_num)

To: WHERE row_num = 1

This is a quick guess based on what you've posted, without any testing. But I think MAX (row_num) will be returning the...

Apparently VS 2013 (SSDT 2014) still uses VS 2012 for scripts by design. So it looks like the script didn't migrate, but in reality, no migration is needed. More details...

I'm having the same issue upgrading a package from SSIS 2012 to SSIS 2014. What exactly is the "totally manual" upgrade process? Re-create the script component? Edit the XML? I...

Several threads on the Internet suggest disabling Check for publisher's certificate revocation in the Internet Options, Advanced control panel.

The Messages pane gives some insight. Without GO statements, this is one SQL batch. The connect commands are processed in order before any of the SQL is executed.

Connecting to server1\instance1...

Disconnecting...

Thank you to those who responded.

So it looks like the two select queries do not have to be in the same transaction. The first select statement is reading from...

Just to explain that horrible SQL script in m previous, something on the network is sniffing SQL and won't let me send it out (HTTP reset). That one finally made...

CREATETABLE outertable (a INT);

CREATETABLE innertable (b INT);

INSERToutertable VALUES (1), (2);

INSERTinnertable VALUES (10), (22), (30), (45);

SELECTCOUNT(*) AS outer_join_outer_table_has_rows

FROM (SELECT* FROM innertable LEFT JOIN outertable ON 1 = 1) AS t;

SELECTCOUNT(*) AS...

Cross join and outer join with no predicate are not the same. If there are no rows in one of the tables, cross join returns no rows.

Thanks, I will use the first one!

I keep forgetting about CROSS APPLY and OUTER APPLY and try to solve everything with joins...

kiwood (9/9/2015)

---

One thing that both DBAs and developers need to get down to is that their real job is to make other people's jobs possible and/or easier. Both need to...