For the record, OLE DB SQL Command is a horrendous transformation to use. It updates records on a row-by-row basis (RBAR) instead of by a set based solution. This causes...

Trey Staker (6/15/2011)

---

SQLRNNR (6/15/2011)

---

Ninja's_RGR'us (6/15/2011)

---

Steve Jones - SSC Editor (6/15/2011)

---

Brandie Tarvin (6/15/2011)

---

SQLRNNR (6/15/2011)

---

Whut? No way. Not...

GilaMonster (6/15/2011)

---

Brandie Tarvin (6/15/2011)

---

msenel (6/15/2011)

---

in this case SQL server works just like Oracle, restore Full backup and then TRN log until the point where you dropped the table ( using...

robin 86662 (6/15/2011)

---

It's the Destination that uses the parameters. The Source is a straight table. In the SQL Command property of the OLE DB Command, I am using...

Whereas in my office, we have so many feeds coming in from different places (or are grabbing feeds from different sources) that we just include the grab as part of...

Can you please tell us how you have your Source set up to use the parameters?

Also, tell us what the parameter sources are. (I just want to verify something).

Yes way.

For example: If you haven't figured it out, Steve...

Oh, wait. I forgot to grab some points for me too.

Congrats, Grant. @=)

I think y'all are just adding posts to get extra points!

:w00t:

High

robin 86662 (6/14/2011)

---

Can someone help me using T-SQL to convert this value: '2011-06-11 16:34:29.123' into this format '6/11/2011 4:34:29.123 PM' (this is the legacy format). Then maybe I can...

Smoke

FYI: We don't know what you mean by Retails Domain project. That reference is lost on us. All we can do is tell you what an SSAS developer usually does...

Ditto to opc.three's comment. But just to clarify, you can do these two pieces in the same SSIS package (I'm sure that's what he meant).

SSIS isn't meant to do...

Can't access anything?

Please be more specific in the steps you use to create your Data flow. Tell us what items you are choosing and how you're connecting them together.