You can achieve this easily by using the RANK() or ROW_NUMBER () with a grouping on OrderID.

Read BOL about DTEXEC and DTUTIL and how to use them to manually modify your command line execution string.

Thanks for that answer, I just increased my file size to 110 Gigs.

I was thinking on the lines of adding a secondary file group (.ndf) file but wasn't too...

The answer to this depends on how you migrate your package from Environment to environment. If you use package configuration, that would be easier to move your package between lot...

Found something interesting for you. Hope it helps

http://connect.microsoft.com/SQLServer/feedback/details/358323/names-of-built-in-roles-in-msdb-changed-from-sql2005-to-sql2008

Like I suspected, what you are looking for is a role that was available in SQL Server 2005.

What is your code trying to achieve? Any heads and tails information would be nice for other people to help answer your question.

I am assuming that you are looking for db_ssisadmin. Of what I can tell over the top of my head, 2008 should use the db_ssisadmin whereas 2005 should use db_dtsadmin....

Log shipping/Replication are two of the most widely used high availability solutions available in SQL Server. Implementing either one depends completely on your requirement.

Usually Replication or Mirroring are used...

Answer to a very old problem..I know.

But I got into this situation when we changed our server.

The maintenance plans are SSIS packages stored in the Package Store of your...

This is such pure Microsoft BS...I gave the SQL Server agent account full rights and it failed. But when I created a credential and proxy, it failed again. So I...

Kraig,

I am working on redoing the entire table. But its heck lot of work on SSMS, SSIS package and stuff. So will report back what I find/do with this.

The transactional system has 100,000 transactions everyday and I capture those..But I am going to roll backwards to atleast 2 years to be able to report on them. Consider the...

A scheduled SQL Agent job pulls across this information from another system (UniVerse) through a ODBC connection. It gets populated everyday except for Sunday (thats when the business is closed)....

The table as of now adds approximately 100,000 rows everyday. This is not a transactional system at all. In the long run, the system is intended to replace the existing...

Jared,

I already built a cube to showcase how end users could use the data. But I guess my users dont have a clear vision of as to what they would...