Are you just doing a data transfer?  No triggers, etc.  If so, maybe what you need to do is resort to an Execute SQL Task and stick a SELECT statement...

Is this field truly a plain vanilla Identity column?  Does the destination table have two different columns, one pulling the Ident from the source and the other its own Ident...

Look up the keywords "exporting packages" in Books Online for all the various methods of moving SSIS packages.  The wizard can be found by Right-clicking the package in question.  It's...

You need Identity Insert set to ON. 

The best way to do this is to insert two Execute SQL Tasks, one before the import and one after the import.  The first...

If you look under Tools -> Options in SSMS, you'll see an item called Source Control.  If you set it to Visual SourceSafe, you can create (inside SSMS) projects that...

Thanks for the info, Casper.  I'm still learning this stuff myself, so every bit of info is incredibly helpful.

Glad you got yours working.

Okay, I see your point.  I just tested it in 2k5 and got the same result when using a real Create Table / Update Table statement.  Which doesn't make sense...

You have to have a solution open before you can find it.  Then look in Solution Explorer, you'll see the project name and 3 folders underneath it.  Data Sources, Data...

You're welcome and I'm glad you could get it to work.

Well, at least you got it fixed. @=)

The way I've gotten around being able to set the root folder is this.

I create a Global Package variable and set a default value of whichever folder I want.  Then...

I have to be kind of vague because I haven't done this before.  However, a coworker has and this is what I've been told.

Create your ForEach Container with all the...

You have to jump through hoops to grant non-sysadmin users access to launch SSIS on your SQL Servers, and it requires granting them access via the Windows OS and certain...

What changed between when you ran the package 20 minutes ago and when you got that error?

RunTime support for DTS packages must be installed on SQL 2k5 in order to use them.  Here are a couple of links from Microsoft's site on the subject:

http://msdn2.microsoft.com/en-us/library/ms143706.aspx

http://msdn2.microsoft.com/en-us/library/ms137907.aspx

Let...