quote:

---

One thing worth considering when deciding whether to run your package via a SQL Agent job, or via xp_cmdshell is timing of...

Ok I'll do it ...

You can't stop the Server

nobody can stop the Server.

Take the cold from the snow

tell the trees "don't grow"

Tell the wind "don't blow"

'cause it's easier no!

You...

Instead of using PRINT, you could insert your messages into a table in the database.

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click interface

A bit more information would be really helpful. Can you post the structure of your SQL7 and SQL 2000 tables?

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click...

Here a script that I used to change the step name in about 120 packages. This needed to be done because the powers at be didn't like the wording

If you have SQL 2000, make sure you turn on Package Logging for all the packages. This might give you an insight into what's going wrong.

Hope this helps

Phill Carter

--------------------

Colt 45...

Any chance of posting the error messages so we can see what they are?

Kind of hard to suggest a course of action when you don't know the problem

Error 273 is a logon failure.

Can you login to the server using the new account and send emails from Outlook?

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click...

On a computer that doesn't have Windows XP, open the file in Notepad. Maybe the file is in unicode format instead of ANSI.

Another thing to try. After the lines,

While oFile.AtEndOfStream...

You can use the method Allen_Cui suggested, or you can use sp_OA* procedures.

Check out http://www.sqldts.com for detailed info.

The best method I've found is to schedule the Package and diasable, or...

Done it twice and was totally succesful once. The other time we ended up doing a clean install. Not entirely sure why the second one failed, gto a feeling it...

rodalsteve: I share your sentiments, that's why I insist on the developers getting a server of their own, either on their workstation or a shared server, which they have admin...

What sort of tool/method are you using to produce your reports?

You could possibly look at using ADO MD to create a hierarchical recordset using the SHAPE command.

Hope this helps

Phill Carter

--------------------

Colt...

Public Beta for Reporting Services is due for release in 2-3 weeks.

Unfortunately, the people in the know seem to be keeping anything else close to their chests. Maybe because of...

Is this a development, or non-production, server? If so, then just give them dbo access to msdb that should cover things. I've played around giving more restrictive access but always...