Sorry, I just ran the posted code, and the following is a sample of the results;

CustNum TxnMonth Revenue

1057      1            51.00

1057      2            68.00

1057      3            127.50

1057      12           93.50

Now I did just discover that the problem I...

The Revenue and Unit calculations have to be expressed in terms of a given month. Thus, the CASE statements that check for the month, then calculate Units and Revenue for...

I wound up creating a script solution that was pretty straight forward. I basically set up string variables using DATE to get the data portion of the file name, concatenated that...

I'm just finding out that the 'Use Fast Load' option in the Transform Data Task will cause Triggers to be bypassed. I wonder how much slower the Insert will run...

The Insert is part of a Transform Data Task. Would it do any good to use 'Begin Transaction' with the Insert statement?

Thanks again.

On the 'Options' tab of the transform where the insert takes place in the DTS package, 'Use Fast Load' is checked, and 'Insert Batch Size' = 0. According to BOL,...

DailyAccountsDownload_Tracking has a nonclustered primary key on MMS and TrackingDate. The MMS values from DailyAccountsDownload are all unique. The insert occurs in a DTS package, I'll have to go check.....

Sorry, I forgot to mention that DailyAccountsDownload_Tracking was also empty. So both tables were empty at the time that DailyAccountsDownload was repopulated.

That's what makes it a mystery.

That works until I introduce other fields into the query (sorry, I didn't tell you there were other fields)

I found that this will work:

SELECT da.MMS,da.Zip,da.TrackingDate

FROM DailyAccountsDownload_Tracking da

INNER JOIN...

I think I've isolated the problem. I'll need to post again on the specific issue.

Thanks.

Thanks for your help, I'll try this!

CSDunn

Thanks for your help!

cdun2

Thank you for your help! I implemented a similar solution with a Dynamic Properties Task, but with a SQL Statement using the string for the file path + GETDATE() (I...

I was able to come up with something using the Dynamic Properties Tranform in DTS. I created a table with twelve rows that contained a column of three letter identifiers...

Thanks for your response. I tried to run that code and got a syntax error. I checked BOL, for 'OPENQUERY', and the fuction cannot take variables for its arguments.

I tried...