Yes, the mapped drive shows up using NET USE and I have dropped & re-created this map a few times already. I even tried using different drive letters.

By the way,...

Thx for the suggestions, I'm afraid I may need more of them though...lol

The SQL agent uses a domain account I setup for just this kind of needed access. I know...

I realize your new but you should be sure to read the whole post.

This is SQL7.0 and yes you can right click and populate the cat in 7.0 as well...

Never mind...duh...

Re-installing SQL sp4 after installing Full Text fixed the problem.

I passed my variables from asp page to a user stored procedure which in turn created a DTS package (sp_OACreate 'DTS.Package') which set the global variables using (sp_OASetProperty). Works great,...

I transfer spreadsheet data into my SQL db to save the space. Those spreadsheets eat it up no matter whats in them.

Archie Smith

MCSE, ASE, DBA

Intranet IT Administrator

Web Applications Developer

Doesn't this seem like the perfect situation to build a trigger?

OK, same idea using the DTSGlobalVariable.

Go to your Transform data workflow connection(data pump). Open it's properties and go to the tranformations tab. Delete your existing mapping then select an ActiveX...

Give the client, that activates the DTS Pkg, system administrator permission on your SQL server then give it a try. It sounds like security.

Not sure I understand your problem but I'll give it another shot. The following is a sample script which re-directs an excel connection in a DTS Pkg.

'*****************************************

' Visual Basic...

SQL7 DTS only uses DTSGlobalVariables, sorry I thought I had made that clear. You must use DTSGlobalVariables. Theres no other way, period.

Dim objPackage

Set objPackage = CreateObject("DTS.Package")

objPackage.LoadFromSQLServer "servname","","","256",,,,"Pkgname"

' set the global variables

objPackage.DTSGlobalVariables.Item("somevariable").Value=somevalue objPackage.DTSGlobalVariables.Item("somevariable").Value=somevalue

' Execute the Package

objPackage.Execute

objPackage.Uninitialize()

objPackage = Nothing

Checkout http://www.SQLDTS.com

I suggest calling a stored procedure to start your DTS pkg...

Maybe you've figured it out by now but in case you haven't, what you guys need to do is have your page call a stored procedure which in turn calls...

YES! what your saying makes total sense to me. I didn't make any changes on the SQL7 server or the pc with SQL7 client. YES! I checked sysobjects and all...