sql server dts: DTS - Soruce EXCEL -- sql server dts

DTS - Soruce EXCEL

Swami
9/27/2005 4:37:01 PM

sql server dts:

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

Re: DTS - Soruce EXCEL

Allan Mitchell
9/28/2005 12:00:00 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

[quoted text, click to view]

RE: DTS - Soruce EXCEL

Swami
9/28/2005 11:33:04 AM

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

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.