If you don't already, save the parameters to global variables. Then specify these global variables in the inner global variables tab on ExecutePackage task.

Check out 'Execute Package Task' in BOL.

Hope...

Have a read of the following, it may give you an idea of what is wrong,

http://msdn.microsoft.com/library/en-us/dtssql/dts_pkgmng_sec_09dl.asp?frame=true

Hope this helps

Phill Carter

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

Colt 45 - the original point and click interface

I haven't run into any problems executing from Query Analyzer, as I mentioned in my previous post I just use 3 character month names and it works wonderfully.

Hope this helps

Phill...

I haven't run into any problems executing from Query Analyzer, as I mentioned in my previous post I just use 3 character month names and it works wonderfully.

Hope this helps

Phill...

Unless you're running a Unisys ES7000, or all your databases are really small, I wouldn't restore more than one at a time. What happens if one restore doesn't work properly?...

Hey Faubus, we Aussies have the same problem. Here's how I get around it.

In stored procedures include the statement

SET DATEFORMAT dmy

at the top of the procedure.

Also, always pass dates back...

Running the package via a Citrix session is not the same as runing the package on the server itself. Citrix will create a seperate profile/workspace for you to work in.

When...

You're in the wrong forum if you want to protect/hide what your database code does. A lot of the forum members would be operational/support DBA's that need to know what's...

The only way to apply this sort of standard is to always create objects using the same tool. So as you use Visio to create the objects, don't create objects...

Not entirely sure what you want to achieve. Each database on the server is independent of each other, unless of course you specifically reference an object in another database.

Hope this...

Does this help?

http://support.microsoft.com/default.aspx?scid=kb;en-us;295378&Product=sql2k

Hope this helps

Phill Carter

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

Colt 45 - the original point and click interface

quote:

---

I have a package, in which I have a SQL task that queries an Oracle dB for two values it needs and...

Also, make sure there are no MsgBox statements. The VB app should be developed purely as a console app. It should issue no messages or requests requiring interaction from a...

Take a look over the following,

http://support.microsoft.com/default.aspx?scid=kb;en-us;324966&Product=sql2k

http://www.msdn.microsoft.com/library/en-us/dnsql2k/html/sql2k_replperf_tran4.asp?frame=true

http://msdn.microsoft.com/library/en-us/replsql/replover_694n.asp?frame=true

Hope this helps

Phill Carter

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

Colt 45 - the original point and click interface

It's the same thing that happens in the DTS datapump and also when importing into MS Access and MS Excel. The first row determines the fields and datatypes. If the...