Since you are calling the 2nd package to do the parsing, I assume that in some fashion you are telling the 2nd package the path to the file.  Are you...

How are you going to pass the ids?

Sounds like the "other developer" could include your piece into his app with realitevly little effort.  You could just supply him with the...

I am curious as to why you want to use DTS.  This sounds to me like a systematic series of steps involving interaction with a host and client server for which a...

What is the purpose of "STANDBY Mode"?  If it is merely the read only aspect of that, then couldn't you use

sp_dboption to set the read only mode of a database...

I do not have the expierence to say which method is better.  But I do know how to definitively tell the difference using the execution plan in query analyzer.  What...

You could do it several ways depending on the size of your file.

1. You could write a vbscript file to do the work and call it with xp_cmdshell using the command...

Thanks SF

I have been educated.  That is always a good thing.

I guess that I wanted to make sure that there wasn't some "HUGE" pitfall to the choice I had made.  If there is a more correct way, then I don't...

Ok

I chose the detach / re attach option.  Am I completly off base, or is that just not the best way????

As with many things there are probably a dozen ways to answer this question and it all depends on desired input.

the formula select datediff(day,@start,@end) returns the number of days in...

I am not familliar with cvs, but there might be a couple of things you can check.

1. Does the command 'cvs -d :pserver:xxxx@xxx.xxx.xxx.xxx:/usr/local/cvsroot login' run ok from a command prompt?

2. Do you...

Since you say that you made the text input box, I assume also that you have access to the vb code.  That being said, I have always used the following...

I am not sure exactly what you are attempting to achieve, but there are several possible solutions to your question.

Does this Answer your question??

declare @iCount int

SELECT @iCount=COUNT(*) FROM EMPLOYEE

Print @iCount

One thing you could do is use DTS to ensure that your file is in the correct format. Sometimes, this will point you to the area of your file...

I have come across this issue several times. When ALL else fails, you can always put the database in emergency mode, recreate all the tables in a new database,...