Also, check if the auto-close option is set for databases on the remote server. If it is, EM will appear to hang while it opens all the databases prior to...

Try this,

SELECT db_name(), fs.*

FROM OPENQUERY(<your server>, 'SET FMTONLY OFF EXEC(''DBCC SHOWFILESTATS'')') as fs

Hope this helps

Phill Carter

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

Colt 45 - the original point and click interface

Run SELECT @@VERSION then check the version number against the list found here,

http://www.sqlsecurity.com/DesktopDefault.aspx?tabindex=3&tabid=4

Hope this helps

Phill Carter

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

Colt 45 - the original point and click interface

Haven't had this problem before. The workflow worked for me when I setup 140+ packages with 4 levels.

Are you sure you're failing the child package? We had an issue when...

quote:

---

Hello,

I have problem of making connection to the Excel file with the following connection string...

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\Test.xls;Extended Properties=Excel 8.0;"

In the above connection string...

KudahX

Can you schedule the DTS package to execute successfully? It could be a permissions problem. When you manually execute the package it is using your security credentials. Executing via scheduled...

Are there any error messages in the log? Try restoring with the STATS parameter to get progress details.

Hope this helps

Phill Carter

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

Colt 45 - the original point and click interface

What sort of error messages are you getting?

Hope this helps

Phill Carter

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

Colt 45 - the original point and click interface

When you say 'then go back in, ...', are you checking the scheduled job that was created when you click ok, or are you choosing schedule from the DTS package?

If...

There is quite possibly a better idea, but what about the USERNAME environment variable?

Hope this helps

Phill Carter

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

Colt 45 - the original point and click interface

Instead of creating a stored procedure, us a function.

If you have to use a stored procedure, try using OPENROWSET.

Your example would look like,

CREATE PROC usp_Test_SPExec

As



SELECT 1...

It doesn't matter where you create the function. You can specify the database name when you call the function.

eg: MyDb.dbo.MyFunction

Hope this helps

Phill Carter

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

Colt 45 - the original point and...

In Query Analyzer you can choose "Results to File.." and it will prompt you for a filename.

To perform the same function using OSQL, use the -o option.

Hope this helps

Phill Carter

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

Colt...

Here's a couple of good resources,

http://www.devhood.com/messages/message_threads-2.aspx?category_id=53

http://www.asp.net/Forums/Default.aspx?tabindex=1&tabid=39

http://www.vbdotnetheaven.com/

http://www.gotdotnet.com

Hope this helps

Phill Carter

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

Colt 45 - the original point and click interface

Setup your bulk insert as a scheduled job and get your user to execute sp_start_job.

Hope this helps

Phill Carter

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

Colt 45 - the original point and click interface