I believe if you create a clustered index on the partition scheme you will partition the table as configured by the partition scheme and function.

CREATE CLUSTERED INDEX [idx_Name] ON Table(column)...

Matt Miller (#4) (3/24/2008)

---

navpreet.khurmi (3/24/2008)

---

so for what you have explained Unicode can handle more then what non unicode handles. but then why would anyobe use a non unicode as non...

Thanks for your replys. I think what da-zero said makes sense as far as checking to see if the file exists before downloading it.

Specifically the file names are formatted...

I don't why but almost every interview I've had I get asked about clustered index vs non clustered....

This blog seems to be a better way...

http://sqlblog.com/blogs/rushabh_mehta/archive/2008/04/24/gracefully-handing-task-error-in-ssis-package.aspx

By setting the FTP task property ForceExecutionResult to Success and setting the Propagate system variable in the error event to false.

Jack Corbett (7/17/2008)

---

Pragmatic Works has a free custom SSIS component called File Properties Task where you can pass the file path variable obtained in the for each loop and one...

I just read through the MS Training kit book; its gets kinda boring after a while. I just bought into Transcender exams; Anyone know how accurate the Transceder Exam...