Erland - I read your page several times before posting the problem/question/plea.

At a previous employer this is how we got 'around' the permission situation. There was also a role...

GilaMonster - I'm talking about the 2012 SEQUENCE object type. It's there, I wanna use it when practical. Sadly most of the existing systems can't/won't be changed so...

Thanks Kraig. That's exactly the kind of thing I needed to know to help make the decision. I was looking at uniqueness and contention didn't come to mind....

I'm doing design work so there's no objects at this point. From my reading it seems that the values are unique per database (which makes sense) so if this...

Green for dev.

Yellow for test.

Red for prod.

And moved the status bar to the top of the query window so I could easily see what environment I'm in.

It's saved me a...

We deploy to the SSISDB catalog at a project level using the .ispac file. Then the DBAs use the environment to set up the connections. Is anyone else...

Just a thought but what about aliasing the columns returned by the stored procedure to give another level of protection? The real column names are hidden and the naming...

Sadly, expect to do a data conversion on every MySQL field you bring over. SSIS can be so touchy about its own data types that bringing them in from...

Working in an environment with multiple security bands, multiple networks and load balanced servers there's no way linked servers are possible, practical, or desired.

SSIS or some other tool that allows...

drew.allen (9/1/2011)

---

kramaswamy (8/31/2011)

---

That would only be the case if the database was actually located on Server 2.

If I understand the OP correctly, there's a whole bunch of servers and machines...

Thanks so much. I was hoping that was the case since it means I can get this thing set up and running, knowing it won't take forever going between...

The "dd" simply refers to what type of date value you want. And unlike T-SQL the value needs double quotes.

Another "gotcha" is sometimes the string wants a string value,...

Mind you - I'm not one of the gurus on here. Hopefully someone will correct me if I get things wrong.

To use variables in your SQL you need to...

Back on topic.

I believe the (field1 + field2) [AS] Alias is the ANSI standard. So if you're writing code to 'standards' then put the alias after the column(s).

It may...

Phil Parkin (6/17/2011)

---

If you write a lot of T-SQL, consider doing yourself a favour and omit the readability words (AS is one) - it soon becomes second nature and as...