Re: Simple questions
From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 03/22/04
- Next message: Partha Mandayam: "Re: SQL Task inserting duplicate rows"
- Previous message: Allan Mitchell: "Re: connection failed"
- In reply to: mklapp: "Simple questions"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 22 Mar 2004 15:34:55 -0000
#1 = yep
#2 = Have a look at
Problems With IDENTITY() and the DataPump task.
(http://www.sqldts.com/default.aspx?293)
#3 = I see now you are using the copy object task. personally I do not like
this task much and try to avoid it. I script out my procs and apply them
manually or through SQLDMO.
-- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "mklapp" <mklapp@zippy.com> wrote in message news:5374D9E5-C9D0-4936-A94D-EB640E7F6E79@microsoft.com... > Hello, > > In setting up a DTS package in DTS Designer, I notice we have the option to create the destination table. > > 1. If I already have a table setup (with indices, identity and timestamp columns), can I use the DTS Designer package to preserve the destination table and just fill it? > > 2. I have a field in some of the destination tables, which is an autonumber in Access and, going forward, will be an identity column in SQL Server. Because the identity value is tied to another table, I want to preserve the ones that come over, but want new rows inserted by the new application to express the Identity column functionality. My first impulse is to turn off the Identity attribute, import the data, then turn the attribute back on. Will that work? > > 3. Should stored procedures be copied only after the tables have been copied?
- Next message: Partha Mandayam: "Re: SQL Task inserting duplicate rows"
- Previous message: Allan Mitchell: "Re: connection failed"
- In reply to: mklapp: "Simple questions"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
