Please do not crosspost. Duplicate message, please see post/replies in http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=6517&FORUM_ID=6&CAT_ID=1&Topic_Title=Fail+when+execute+DTS+package&Forum_Title=Security

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

If you need a standard sequence number 1-... then you can use

ALTER TABLE tblname ADD column_name INT NOT NULL IDENTITY(1,1)

Keep in mind INT can only handle so many records, if...

Where is the program running, is it on the server or at a workstation? If the later have you tried running the DTS package thru EM and verify the issue...

In that situation both should provide approximately the same result as for speed. If you test with conditions almost exactly the same the lag between each would be minimal if...

The fastest is to always execute at the server itself. If you do from a client machine the data wil cross the client to the server so extra traffic on...

When Excel is parse in DTS there is a mapping generation that occurrs. When you connect to the file in the transformation, the tab for excel should tell you what...

Good advice, thanks for adding that in.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Check it out here http://www.sqlservercentral.com/columnists/bknight/transferdiagram.asp

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

I have changed between IP addresses without issue in 2000, the only thing that might affect you is config of name to IP in Client Network utility may need to...

Keep in mind you have three fields and a count column. I would expect to see something like this at minimum if the termnum was unique and only had one...

When you say you are running these traces, is this is profiler or xp_trace... procdures to create a queue? If profiler then what happens when you close profiler, can they...

Set the process to on success run the same step or step 1. Then in the step add a WAITFOR DELAY '000:00:10' to have the process pause for 10 secounds....

First I don't know how you can tell if the tape is full until full. I will look some more when I get a chance.

As for the older sets, I...

Try running sp_resetstatus [ @DBName = ] 'database' to reset the suspect flag then try repair.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston...

You might try adding logging or an error fil by openin the properties of the package and setting these. Shoul be able to tell you where the process stopped or...