Crispin,

We have a database server with sql 2000 and a DTS package that runs fine their. The DTS package is stored in the msdb database and when we run...

The result of running cmdshell "Dir X:\" from Query Editor on my system gives this:

>>>>

The system cannot find the path specified.

NULL

>>>>

The line "print @returncode" in

DECLARE...

I installed IIS and re-tried the sql 2005 client install. Unfortunately, the install failed again at the msxml6 step.

Barkingdog

Michael,

You wrote

>>

...Rather than saving the change, click the "Script Change" button and look at what it does.

>>

That's a good idea but I couldn't locate the "Script Change" button in...

I am amazed by the depth of responses and useful ideas. Thanks to everyone.

Bow wow!

Barkingdog

Thanks for the great info. I was familiar with those t-sql command but can you offer a hint why I need to use them after renaming the physical server? (Are...

Works great. Thanks.

barkingdog

BTW, I spoke to soon. Here's what I get for my email "Body":

user::myResults

In other words, I get the variable name, not its content. How do I get the...

"I prefer the file system"

So do I. I was just puzzled by the numerous SSIS storage places. There must be some reason for all the options, I reasoned.

Barkingdog

Todd,

You method worked fine for me! Thanks.

Another question: as you indicated, under ExecuteSQL task properties I needed to set ResultName to "0". (If I don't, I get error messages.) What...

One of my team members recommended assigning the sql server a new IP address dedicated to the new instance. We could then use the same TCP PORT as the default...

>>>Where are you getting the filenames from?

A seperate non-sql application generates the files and their name upon demand. THen the app ships them over to a directory, which is...

>>Where are you getting the filenames from?

A sepearted, no sq

The general issue we are having is this: inserting 10,000 rows into a clean table is quick. If we add

another 100,000 rows to that table, then inserting another 10,000 takes...

What you LEFT/RIGHT JOIN on? ZipCode and CityName?

TIA,

barkingdog