Thanks for the suggestion.

I had some questions on how to do error handling. I am not very concerned on the inserts into the archival db as its pretty much going...

Yes, the prod and arch table structures are similar.

I am copying across data which would fit certain criteria (one being the date for instance).Not that every table has a date...

I was working on a conversion project for a manufacturing major in 2004.

Their data was in DB2 and front end in a variety of languages and they wanted to

bring some...

Have you tried checking the logging option on package properties.

Sorry . mIssed out on the other columns in the select

select x.ID,x.MDate,y.SaleID,y.Cust from (

select ID,max(SaleDate) MDate from #tab_test group by ID)x, #tab_test y

where x.ID=y.ID and x.MDate = y.SaleDate

If i read you right this should solve the problem as well

select ID,max(SaleDate) from #tab_test group by ID

--replace #tab_test by your table.

If you have a transfer data task in you DTS then in the options tab you can mention <none> as the value for row,column delimiters. You have to type it...

I think you do not have sufficient access rights to access the error logs. thats what i can see from the error log. If you are able

to configure then...

I am not sure if you mention this in the connextion to sql server in DTS package.

But you could do either 1 of this.

1.set the arithabort on at database level

ALTER...

Just update the @end to 2000 in your case.

This will work too.

declare

@start int

declare

@end int

set

@start=1

set

@end=100

while

try this. Column Names i used are StartDate and EndDate in Employee table. You can use a lot of dateparts - like mi,ss,hh . Look that up in SQL server...

Have you turned on logging in the DTS package. Open package in SQL server and clikc on Pakcage --> Properties from menu. In the logging tab you can have it...

DTS will not be able to dynamically change its mappings once your source table changes.

The other way i know is to use VB code to execute your DTS package. You...

Hi,

I have seen the "general error" messages at times when the network just fails. Like suppose you are connecting to some network resource etc and the network just fails for...