You will likely have to look at the data from your source before import to see why there is errant data.  But first you might try importing the data into...

It would be helpful to see the schemea for the customer master table.  It could be that some columns are set to not allow nulls, or possibly there is a...

you should be able to remove the WHERE clause from your derived table and use it in your JOIN.  You are already partially doing this. Try this:

SELECT  uu.History_Duty_ID, uu.Day_Date, uu.Employee_No,...

What is the data type of the batch column?

From SQL Server Books Online:

In queries that include a correlated subquery(also known as a repeating subquery), the subquery depends on the outer query for its values. This means that the...

Sukhoi, I have never had a problem using @@IDENTITY in the way that I described.  However, please don't dismiss Jeff's suggestion of using scope_identity().  It can replace @@IDENTITY in the same...

Hi,

You can use @@IDENTITY to obtain the inserted ID value: 

INSERT INTO MASTERTABLE(val1,val2)Values('hello','world')

declare @MyID int

Select @MyID = @@IDENTITY

INSERT INTO CHILDTABLE(ForeignKey,val1)Values(@MyID,'value')

Good Luck

You can dynamically change the name of a text file.  One option is to use the ActiveX Script Task in your DTS to perform this name change.  Example:

'**********************************************************************

'  Visual Basic...

I could be wrong about this as I've never attempted it, but if she performed a backup of the Transaction Logs, (assuming they have not been truncated) and then performed...

My Bad.  It hasn't been depracated.  Something I heard. I shouldn't go around spreading rumors.

My Bad.  It hasn't been depracated.  Something I heard. I shouldn't go around spreading rumors.

It sounds like you need to increase the CommandTimeout Property of your Command object.  Or, possibly the ConnectionTimeout Property of the Connection object if you are using one.

Pete

I'm not sure on that one.  But if you are using a VB COM object, you may wish to use the DTS.BulkInsertTask object to perform your batch processing.  You can use...

It may be possible, if your transaction logs have not been truncated, to perform a backup now and then perform a restore to a point in time. 

To restore...

I think I've figured it out.  T-SQL treats the sub-query as a correlated sub-query when a field does not exist.  I'm not sure if this is a feature of the optimizer, or...