Yes sir.

SSIS package has an Execute SQL Task that calls the sproc "usp_RTRH" with 3 arguments. That call works in Management Studio, but when run in the...

Pretty boilerplate stuff really. Is it a "whisper down the lane" permissions issue?

select @query yields:

INSERT INTO a2db_rawhistory.dbo.tx_wb5asc ([WBKEY], [RECNO], [SEGMENTCOUNTER], [TUBINGINCHES], [TUBINGFRACTIONNUMERATOR], [TUBINGFRACTIONDENOMINATOR], [DEPTHSET], [PACKERSET], CurrentAsOf) ...

No temp tables in my spoc. Installed the NOCOUNT ON and re-ran, but got the same error.

If I run the sproc from Management Studio, it runs just fine, so I know the SQL is well formed.

This is perfect. Exactly what I was looking for.

SSC makes me look like a rockstar yet again. Something like 20:1 reduction versus the brute force method we had...

... I'm understanding the query more fully now. After checking the numbers, I realized I needed a distinct clause.

Here's my final result. Thanks again a TON for...

Thanks

Here's a sample of what your query produced:

calltime ...

the table structures for this data nugget are as of yet,...

Sorry Lynn... to address your q... I'm looking in a table that already holds the earliest and latest dates. Please see the first few lines of code I...

-- the grossly inefficient "minutely" code. Figured I'd try to get it to run fast at the minute level, then try it at seconds

declare @looper smalldatetime

declare @loopstop smalldatetime

select @looper...

Nix it. Got that sorted. Working through the report deploy.

Thanks Michael.

I would like to take you up on describing or illustrating your paradigm for assigning a date string to a variable, then using that in a File Copy operation....

Something I didn't consider... I have a report solution in SSRS with about 30 reports. They all use the same DBConnect object... Is there an equivalent "package...

this is exactly what I needed. Already got the package configuration hammered out... Thanks for the direction.

Kirk?

Anyway, thanks for the pointers Ned. I ended up getting it to work by using the "SQL Command from Variable" approach and a VB script to stick the correct...