Phil Parkin (8/9/2011)

---

Elliott Whitlow (8/9/2011)

---

Phil Parkin (8/9/2011)

---

Elliott Whitlow (8/9/2011)

---

I have long been a fan of letting the database engine handle those kind of operations before they even get into the...

Elliott Whitlow (8/9/2011)

---

Phil Parkin (8/9/2011)

---

Elliott Whitlow (8/9/2011)

---

I have long been a fan of letting the database engine handle those kind of operations before they even get into the pipeline. ...

Grant Fritchey (8/9/2011)

---

Anytime we're in Bradford, I have a pub selected. The only...

Duplicate post. Please read original thread with replies here:

http://www.sqlservercentral.com/Forums/Topic1155393-147-1.aspx

Please do not crosspost. It wasted people's time and fragments replies.

I wouldn't do that. Encrypting all...

First of all, don't use the OLE DB command in the dataflow. It is slow.

If you do the aggregation in the source query, as Phil suggested, it will probably have...

ASCII 0 is equal to NULL, apparently.

If it bothers you, you can do a REPLACE(mySTring, CHAR(0), '').

You can add a rowcount in your dataflow. (this stores the result in a variable)

Then, after the dataflow, you can use the variable value in an expression on the precedence...

I'd suggest you'd read the Datawarehouse Toolkit by Ralph Kimball on how to design/model a data warehouse.

Once you've modeled it as a star/snowflake schema, you can populate it with data...

That is a bit of a broad question.

There are thousands of things that can go wrong:

* server has crashed

* database is corrupt

* network is down

* permissions are not set-up correctly

*...

So the variables are empy.

How do they get populated?

Nice question, thanks.

Is the application name necessary?

The servername is empty, is that because the variables are also empty?

Try the following format for the server name:

TCP:myServerName,port

Lynn Pettis (8/8/2011)

---

Actually, you did:

@SQLFRNDZ (8/5/2011)

---

...

Thanks Kraig and I will be an upcoming...

@SQLFRNDZ (8/8/2011)

---

... and I will be an upcoming MVP in near future as I love to help...