Is it UTC...

You should be able to use the FoxPro OLE DB Driver to access the data. It will need to be downloaded and installed on the SSIS development machine and...

What property do you have the expression in?

I would put this expression in the Font Family Property:

IIF(Fields!xxx.Value = "N/A", "Arial", "WingDings")

Then in the Value property of the TextBox:

=SWITCH(ISNOTHING(Fields!xxx.Value),"o",

Fields!xxxl.Value= "True","x",

Fields!xxx.Value= "N/A",Fields!xxx.Value)

See...

Thanks to the 3 G's (Grant, Gus, and Gail) for weighing in on the Index Fragmentation thread. Fortunately, for me, you confirmed what I would have said, I feel...

kramaswamy (11/16/2009)

---

I take it then, that despite my original intuition, the leaf level is actually index level 0, not the highest index level? In that case, your explanation makes sense,...

According to the Bulk Insert entry in BOL there is an ORDER argument for Bulk Insert.

If you are explicitly doing an ORDER BY on your select the data should be...

There are a lot of things that could be happening here, but without table and index definitions, and the specific query it is hard to say what could be the...

What are you using to do the import (DTS, SSIS, bcp, bulk insert)?

Do you have an indexes on the table?

By design RDBMS's do not guarantee any specific order...

A primary key uniquely identifies a row.

An identity column is an auto incrementing/decrementing column that has no meaning other than as a row identifier. These columns are often used...

Is this a mapped drive?

How are you running the package, in BIDS, SQL Server Agent Job, batch file?

Have you done index maintenance and updated statistics on both servers?

I'll answer question 2. In my opinion, you should try to avoid having to handle security within your application. If you do not have situations where the data...

Duplicate question. Please answer here

I'd try something like this:

SELECT

O.user_id

FROM

dbo.orders AS O

GROUP BY

O.user_id

HAVING

MIN(created_date) >= DATEADD(DAY, DATEDIFF(DAY, 0, GETDATE())-1, 0) AND

MIN(created_date) <...

I believe that once you have passed the data through some transforms that SSIS no longer considers the input to the MERGE JOIN as sorted, the transform just before the...