I tried that and nothing. I'm thinking it has to do with the dashes or instance. I also tried the following

DTSRUN.exe /S~[chi-sql-servername\instance] /E /N~[package name]

and got...

Error: -2147467259 (80004005);...

DTSRun is not working for us.. error I receive

Server does not exist or access denied. Error source: Microsoft OLE DB Provider for SQL...

DTSRun from what I understand is replaced with dtexec and that is not working either.

It is in the Legacy Folder, it has not been migrated as an SSIS package but it is in the sql server 2005 as a dts package legacy.

We are trying to implement a rotational DTS Support for production. So I'm not sure the personal install and migration in one day would work, it would still involve a...

for SQL Server 2005 when you click on jobs and see all the jobs on the summary Tab on the right side, you can highligt all jobs and script all....

we use RedGate as well.

Is the user a local admin on the box?

Is there anything like this for sql server 2000?

that was it! It is now working smoooooothly.. thank you so much for your assistance and expertisse! 😀

Thank you guys! I'm having them look at it today. :w00t:

Now I get this error logging into sql server with my windows login. It is part of the domain otherwise it would not let me add myself as a...

I've been going through the sql server fine build (great doc by the way). And I get this error when trying to add the user as a principal in the...

Hey thanks! My problem was that I was not truncating the log before shrinking. I did a dump tran and it worked! thanks again.

ok. Let me take a look.