In this case it was a DEV database and may have been in this state for a long time. it did have a primary file group full error in the...

run this statement to see the result:

SELECT CAST(STUFF(STUFF('01052011',5,0,'-'),3,0,'-') AS DATETIME)

In your select query use the above statement replacing '01052011' with your column name.

The other issue you may run into is...

OK, here is the 3rd option:

if you are currently running separate jobs for each package add a job step for failure then if the job fails have it go to...

here are a couple solutions to that.

First when I need control over package execution what we generally do is call all packages from within another package, you can wrap those...

this is what I ended up with:

Note: the GRANT VIEW ANY DEFINITION appeared to allow the user to change a stored procedure.

From http://msdn.microsoft.com/en-us/library/ms175808.aspx

Server Scope

VIEW ANY DEFINITION permission granted at...

Thanks for the reply, the data source I was using was Pervasive. Probably just needed to research a bit more on how to write a statement that will always return...

this is the command I was playing around with:

EXECUTE master.sys.sp_MSforeachdb 'USE [?]; exec sp_addrolemember ''db_datareader'',''Domain\MyNTGroup'' '

It would only be for a single windows group.

this is probably because SSIS gets the meta data from the source. You can change it but once it re-validates it must change it back.

Besides you still need to...

I did review the licensing and we can have 1 or all SQL services installed under the same license. I wanted to avoid the extra resource usage so we'll just...

We are going to install the SQL engine on the new server so we can use the agent. This is a better option since we will have use of the...

I didn't realize this until just now, the job is not being executed on the remote 2008 SSIS server it's grabbing the package from the remote server and attempting to...

ssills (2/25/2011)

---

The path in Explorer actually begins with http. It's easy enough to get: go to a document library, select Actions, then Open with Windows Explorer, and copy that address...

michael.french 172 (2/23/2011)

---

As it turns out, it was an issue with connection pooling with OLE DB connections.[/Quote]

What type of data source is this? I've had a similar issue with a...

In addition to what Elliot said make sure that either the SQL agent or the proxy account has access to the files. I suggest using a proxy account you don't...