P Jones (1/29/2008)

---

Sounds like you're seriously missing the plot here! BIDS is designed to work on dtsx and you create in BIDS, deploy to either package store or SQL msdb....

That's what I thought it might be but I've been through most of...

I'm just saving the packages normally through the studio designer, which saves the .dtsx file.

Maybe there's something wrong/weird about my installation. I'll see if I can find another machine...

Anyone?

Sure this must be possible?

GilaMonster (1/15/2008)

---

Instant file initialisation requires that the account that runs SQL has permission to do volume maintenance.

Check the local security policy for the server, find the item 'Perform Volume Maintenance...

This is on SQL Server 2005 by the way.

I agree with everything you're saying Jeff but at the same time, with all the best laid plans, sometimes things don't work...

The variable is set from within the package. I just added a variable, set the property EvaluateAsExpression to True and filled in the expression. The Scope of the...

It's fairly easy to do.

Just open up SQL Server Business Intelligence Studio and create a new project.

On the left hand side, in the Tool Box, select the Transfer Logins Task...

You can use SSIS to transfer the logins from the primary server to the secondary server. Just make sure you specify the option to copy the SIDs with the...

lenardd (11/26/2007)

---

Hi All,

My two questions relate to this schema and documentation.

Why is a composite PK needed for the SalesOrderDetail table when SalesOrderDetailID is already an identity column?

Second, is it ideal...

There are various things you can do here.  Import the file into a table and then do the join, use openrowset or opendatasource.  Here are a couple of examples.....

I can't say for sure whether you'd need to rebuild your clustered indexes but it's always worthwhile running a dbcc showcontig regularly and rebuilding your indexes if they need to...

You could do this by first creating 4 additional files.

Then run dbcc shrinkfile (file_id, emptyfile) on the original file, which will migrate the data in the original file and spread...

You could do as Kiran has suggested but be aware that if you're logged in to a SQL Server remotely using sql authentication then there is no windows login name...

That query returns the login name of the logged in user, which in the original posters case is a sql server login, not a windows login.  What the poster wants...