Yes!

Yes! partitioning is the best solution if you are using SQL 2005/08. If not, then I need the definition of your table to provide you with an alternative.

-Vikas Bindra

Seems like a security issue. Even if you restart the job you will get the same error.

Check this link you will find the solution

http://msdn.microsoft.com/en-us/library/ms151761(SQL.90).aspx

- Vikas Bindra

Sr. Software Engineer - BI

As you said that when you execute the package both the groups starts running in parallel, and this is what causing the error. You need to add a "precedence constaint"...

Check the credentials under which the SQL Server Agent is running. Also, check in the job properties that you have specified SQL server Agent credentails to be used to execute...

You can do it with the help of Execute SQL Task. Here is what you need to do:

- Double click on your SQL task.

- On the general tab set QueryIsStoredProcedure...

You need to do the following:

- Save the name of the new file in a variable (@myNewFile) at the time you are creating it.

- Open the Expressions of your Flat...