If you look at the screenshot you'll see that month is at the top, then year, followed by date. This is incorrect, year should be at the top.

I guess you are trying to connect with SQL Server authentication, right?

How do you input the password into the Execute Process Task?

Isn't it easier to use the Execute Package Task?...

I don't think your hierarchy is built correctly.

It should be year -> month -> date.

Indeed. Very annoying. And dissapointing as well, since I thought I could win a fun award. :angry:

gupta.sreekanth (1/12/2011)

---

i,can any one help me in populating time dimensions in sql from 2000 to 2030 for every 15 min.now i need to create time dimensions from 2000 jan 01...

kln2020 (1/17/2011)

---

ok, how can I know the defult time that sql define for checkpoint ?

I ask you this because when I run some Insert query into table, I sea the...

gvrsony (1/16/2011)

---

I want to transfer data from any database table to MS SQL server, so that we can do the same job again and again for day today job. I...

This is indeed a great project I wasn't aware of. Thanks for highlighting...

Lynn Pettis (1/16/2011)

---

And then there are those responses that are simply confusing. Truely some people have the gift of confusion. (No, I am not providing a link to...

Lynn Pettis (1/16/2011)

---

Gail, just read this thread. Interesting how the OP couldn't deduce what you were saying from your original answer. I guess the real problem we...

Glad that you found the solution!

But for...

What do you mean with no luck when using the data conversion component?

Where there any errors? if yes, please post them here.

Try changing the data type in the advanced editor...

Great question.

I had to do some research to rule out extent, so I definately learned something.

That's the most important thing.

Good luck!

And if the website is up, let us know...

I'm glad you found the solution! (rather easy...