Apparently copying reportviewer DLLs into BIN directory is not enough for some features to work due to bugs in Reportviewer component that was supplied with original .Net 2.0. Furthermore a...

ramyamahrous: the code hides properly. The unhide is the one dorsn't work once something is hidden. Did you try to download the files linked? It's very self-explanatory. thanks!

Same here: just after .NET framework along with VS Studio.NET were installed, EM became slower. This particular one also connects to both SQL7 and SQL2000, but that's pretty normal.

Can someone answer ( see above)?

Thanks!

The question really was what collation I have to install on SQL2000 to match mine on SQL7 ( see sp_helpsort result above in first message)

If ping/telnet works, next you can try

ODBCping ( if applied).

Thanks guys!

Provided I can't get additional drives beyond 4, I do RAID5, but how about logical drives/partitions considerations?

Thanks!

Andy: I do pass the point to select source and destination. The problem comes when it actually tries to execute. It says "Cannot create share ...". As I said the...

I know that it works with Windows Authentication, but what if I can't use win authentication? I just wanted to ask if it works for anyone with SQL Authentication.

No matter what I've tried, it doesn't work with SQL Authentication. Yes, I do have Admin righs on both machines, but if they are not on the same network, you're...

How could I miss that? Since it wasn't listed, I just simply trusted the interface. I wasted so much time on VB, but learned a couple of things.

Thanks Andy.

It's goPackage.SaveToSQLServer "(local)", "sa", ""

'goPackage.Execute

'to execute a package instead of saving it, comment out the save line above and uncomment the execute line

Andyj93: SQL 7 doesn't have dynamic properties task.

Andy W: I was able to find vb code to script DTS. I found the delimiter oConnection.ConnectionProperties("Text Qualifier")...

Andy, how can I save DTS as VB file in SQL 7?

Could you also spell out "replace operation" for me?

Thanks

It sounds like a mystery. Maybe someone was joking with you, but stopped when knew you started the investigation.