Sean Lange (5/12/2014)

---

Lynn Pettis (5/12/2014)

---

Sean Lange (5/12/2014)

---

Ed Wagner (5/12/2014)

---

Sean Lange (5/12/2014)

---

paul.knibbs (5/12/2014)

---

You can always use good ol' Character Map that ships with Windows to grab the symbol--bit of a pain,...

I pretty much laughed with the "I have a working and...

Locking? Deadlock?

What do you mean with table scan?

Did you use a SELECT statement in a query?

This was a funny topic 😀 (especially the last replies)

http://www.sqlservercentral.com/Forums/Topic1570700-2799-1.aspx

The easiest solution would be to use a date table that contains the different years.

That way you won't have any gaps. Join the date table against the table with the...

Is the password for the connection manager stored in the package, or provided through package configurations?

Is this syntax valid?

Seems a bit odd to have Parameters!myParameter.value(expression).

For me it is important - especially as a consultant I need to stay on top of new technologies - but it is not everything.

I'm not going to take a...

Great question, thanks!

AdityaSingh (5/14/2014)

---

Hey there, I have created a same,

Do one thing, deploy 2 sql task on your etl which will update the CustomLog table (which you will create) upon success...

+1

When a package runs in BIDS but not in Agent it is 90% of the...

You add a row to your table with all of the columns set to NONE. Make sure it is outside the group of the detail rows.

Then set the visibility of...

You create an OLE DB connection using the Oracle OLE DB provider.

Make sure the Oracle client tools and the ODAC components are installed on the development machine.

When you run a package through a SQL Server Agent job, it uses the permissions of the Agent service account.

You either give that service account sufficient permissions on the SQL...

Not...