Paul,

I assume you're running the package manually from your workstation where you have the correct ODBC DSN defined.  When you schedule a package, it runs on the database server which...

So, to summarize, when you run a package manually, it runs on your PC under your security context and when you schedule it, it runs on the server under the...

Where you executing it manually from Enterprise Manager on your PC or from the Server?  And, is the file path on your PC or the Server?

Greg

I assume you want to load all the files in a single package.  You can create 'on success' or 'on completion' workflows between each transformation task.   They would point from...

Re: vacation time

I work for a state government agency in the U.S. and my vacation time accrues monthly.  Currently, I get the equivalent of 4.4 weeks per year plus 11...

Also make sure the current database is the one that contains the stored procedure you're working with.

I happened to run across this site.  Look in the "Data Models" section.

http://www.databaseanswers.com/index.htm

Greg

You won't be able to use IDENTITY property for this.  IDENTITY, by definition automatically increments when a new row is added to a table.  You'll have to assign identification numbers programatically.

Greg

Rob,

You didn't say which task you're using to tranfer objects.  If you use the Copy SQL Server Objects task,  check 'Include all dependent objects' on the 'Copy' tab.  It hasn't...

In addition to the database owner and sysadmin members, a member of the db_ddladmin database role can also create objects with another owner.  From BOL 'Create Table':

If the...

You can leave the SQLServer service account as Local System.

Greg

...and the link:

http://www.sqlservercentral.com/columnists/sjones/recoverthosepackages.asp

Bill,

Here's an article by Steve Jones describing how he recovered packages from a backup of msdb.  It's a bit of a hack because you're inserting into a system table, but...

Yes, if the network share where the Access database is located is on a different server than SQL Server.  You'd need to use a domain account with permissions for the...

I'd put my money on a permissions problem.  When you execute a package from DTS Designer on your workstation, it runs on your workstation under your security context. ...