Did you download management studio? Because it should be included with the installation media of your SQL Server 2008R2 edition.

Dev (12/22/2011)

---

Nice analogy 😉 but why consider fixed / standard drawer only. Why not considering a drawer that allows us to adjust the depth based on file size...

And please get your facts straight.

I know you're just quoting the article, but a relational...

dilipd006 (12/22/2011)

---

Normalization defines a set of methods to break down tables to their constituent parts until each table represents one and only one "thing", and its columns serve to fully...

Padma-1078840 (12/21/2011)

---

Can someone please post an example on how exactly to implement changing configurations dynamically? I have about 350 packages that I need to run first on test and then...

Indeed. Is it possible to post the code snippit where you reference the...

What is the value of the property RetainSameConnection of the DestinationConnectionOLEDB connection manager?

rocky_498 (12/21/2011)

---

Guys, I thought there is no special way, just use Source (Flat File) and destination is my Oracle DB. Everything is looks ok before i run my package. I...

If you really want to be sure, you can delete the .caw file every time.

dilipd006 (12/22/2011)

---

I think 2 nd approach is not good...it is not a normalized structure

For eg: Consider a table having different drawers we can arrange the file related to verticals in...

dilipd006 (12/21/2011)

---

Hi

I am designing a database for travel application, it consist Hotel,Flight,Package,Transfers,Cars,Trains as vertical. Identified this as seperate entity and planning to create table for each verticals.In our application there...

Do you have NULL values in your source?

Try routing the error rows to a dummy destination and inspect them with a dataviewer. Maybe you'll notice something odd.

You'll need a seperate dataflow task for each file.

If I understand your requirements good enough, I believe this can be an appropriate design:

* Get the first date and the last...

Ignacio A. Salom Rangel (12/21/2011)

---

79J (12/21/2011)

---

Hi,

I have two databases in sql 2008r2 for which i will use to populate one database from another.

I have created a sql server agent job...

It's trivia time! 😀

Thanks for the question Steve.