Haven't seen this either. A couple things.

- On your workstation, one server does not work and others do?

- On the affected server, can you view properties from other servers? Just...

Thanks for the feedback.

Steve Jones

steve@dkranch.net

I've had this a few times with v6.5 and had to call MS to get debugging support from the Level 3 support team.

Steve Jones

steve@dkranch.net

Here's a VB example. You can modify this to run in script.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdmthappendchunkx.asp

Steve Jones

steve@dkranch.net

Here's a VB example. You can modify this to run in script.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdmthappendchunkx.asp

Steve Jones

steve@dkranch.net

look up convert in BOL.

convert( datetime, @var, <format>)

Steve Jones

steve@dkranch.net

your welcome and thanks for the comments.

Steve Jones

steve@dkranch.net

Shouldn't be. What is the filename and path? Any spaces.

Steve Jones

steve@dkranch.net

Perf does this automatically. In profiler, there is a data column for starttime.

Steve Jones

steve@dkranch.net

This is an old example and article from Les and I'm not sure he will update this. I'll build an example soon and post it.

Steve Jones

steve@dkranch.net

Thanks for the feedback and I may update the article with some of these items (or write a more detailed one).

You are correct in your assumptions. I manually order the...

If this is SQL 2000, you can use the Dynamic Properties task to change the data pump.

Steve Jones

steve@dkranch.net

This error looks like you do not have change rights to the file. Ave you checked that?

There might be a 255 char limit.

Steve Jones

steve@dkranch.net

Follow Pau;s advice. This is not possible directly except with dynamic sql.

Steve Jones

steve@dkranch.net

Also the information_schema.xx views are SQL standards. There are:

tables

columns

etc. check master/views for the list.

Steve Jones

steve@dkranch.net