October 21, 2009 at 1:10 pm
I have an SSIS package that copies some tables from a replicated copy of a database to an archive database. It runs once a month.
I'm using the transfer SQL Server Objects task. I had it running for a few months with some problems and decided to edit it. I created a new package with the same task and fewer tables. I set it to copy the data, schema and primary keys. The data transfers but not the primary keys. One thing i changed is not to copy indexes. Is this the reason?
I don't need the indexes just the primary key because the data is used in a report that runs once a month.
October 21, 2009 at 1:22 pm
Is the PK an IDENTITY field? If so, you'll have to enable IDENTITY insert.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
October 21, 2009 at 1:40 pm
it's a varchar column in this case
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply