MS SQL Server DTS - DTS

Author

DTS - Soruce EXCEL

Swami

2005-09-27, 8:24 pm

I am trying to import data from a excel sheet, for that created a DTS
package and running the package through a scheduler. Initailly the file got
3 records and alter added 5 more rows to the sheet. Every time scheduler
runs and populating old 3 records only and I am not seeing the new 5 rows
which I added . Where as if run the DTS package from enterprise manager ,
DTS imports all the 8 records .

Any one have any clue on this and please share your thoughts

Thanks

Allan Mitchell

2005-09-28, 3:24 am

Is the result any different when you execute this package interactively
and not through the scheduler?

I have just tested on my PC and it works just fine doing it the way you
describe

What happens if you preview the data in the datapump task?

Allan

"Swami" <Swami@discussions.microsoft.com> wrote in message
news:E4AC9E96-E504-4FA8-AC99- 1E840E775BBC@microso
ft.com:

> I am trying to import data from a excel sheet, for that created a DTS
> package and running the package through a scheduler. Initailly the file got
> 3 records and alter added 5 more rows to the sheet. Every time scheduler
> runs and populating old 3 records only and I am not seeing the new 5 rows
> which I added . Where as if run the DTS package from enterprise manager ,
> DTS imports all the 8 records .
>
> Any one have any clue on this and please share your thoughts
>
> Thanks

Swami

2005-09-28, 8:24 pm

After running the DTS the table got old record only and i am not seeing the
modified record

"Swami" wrote:

> I am trying to import data from a excel sheet, for that created a DTS
> package and running the package through a scheduler. Initailly the file got
> 3 records and alter added 5 more rows to the sheet. Every time scheduler
> runs and populating old 3 records only and I am not seeing the new 5 rows
> which I added . Where as if run the DTS package from enterprise manager ,
> DTS imports all the 8 records .
>
> Any one have any clue on this and please share your thoughts
>
> Thanks

Sponsored Links