>>>>>>By the way, did you know that the foreign key constraint that you are creating is referencing the same table?  Don't you want the foreign key to reference the CategoriesStaging...

Thanks I like the disabling approach better.

Now, I need to figure a way to loop through the records without using @@ROWCOUNT since this below is no longer working because it's...

yea, indeed that may work.  Then I can just figure out the code to get the GridView to somehow post the results to a table...thanks.

calldatetime however have valid dates, example 2006-04-07 09:06:52.000

where

calldatetime > getdate()-2

so this part is fine, nothing to worry about...

1899-12-30 20:00:00.000 is 8pm

we have other values like 1899-12-30 21:00:00.000 in that column

Ok, I had the same argument though.  I told my boss that there are no dates.  But we're not looking at the date portion....there are indeeed valid times if you...

right on...thanks!

resolved;  I was simply missing the ending GO

Thanks Rick.  I wonder if th en I can fire your script off with a Script component in my SSIS project somehow.

Thanks, I acutally got it working yesterday already!!

Thanks, I've read that one before.  Unfortunately my flat file source component won't even get that far if there are line returns...it fails.  If I take the line returns out,...

cool, thanks!  I actually got it done but this is also something I can look at after the fact.

Amit, right on man!  thanks.

SELECT  1 as col,

  mnt_HeaderID as hdr_HeaderID,

  BatchDate +

  NotUsed +

  TransactionCode +

  GrossBatchTotal +

  NetBatchTotal +

  BatchTransactionCount +

  PNet_ID +

  PartnerCode +

  Filler as HeaderRow,

  PNet_ID as FilePath

FROM mnt_Header...