tags:

views:

202

answers:

1
Q: 

How to copy Default Value using SSIS?

I created Transfer SQL Server Objects Task in the SSIS. It seems to work but Default Value doen't copy properly. Is there any way to copy Default Value using SSIS?

A: 

A default value is usually a constraint. Do you have the option to transfer constraints enabled?

Just a few lines down from where you define the tables to copy, there are two options

  1. CopyAllDefaults
  2. DefaultsList

Take your pick, and it should move over.

Raj More  2009-08-18 15:45:37

related questions

How to turn on FastParse in SSIS (SQL Server Integration Services)
Recommend ONE favorite SSIS component that does SFTP/FTPS
SSIS: Remove Duplicates from Flat File
SSIS read flat file, write to DB or C# app,mutli thread read/write?
SSIS gurus: Links to Great Learning Content requested
Potential Pitfalls of inserting millions of records into SQL Server 2005 from flat file
The best way for a SSIS ftp task to not fail when there are no files to copy
SSIS: How to progmatically direct work flow in dtsx package
SSIS Package Puzzle
Import *variable record length* CSV file using SSIS
Using SSIS to refresh a training database from a production database
What are the options for extracting data out of Hyperion 7.3 with SSIS
SSIS Oracle Parameter Mapping
Integration Services: Multiple-step OLE DB operation generated errors
How to insert a row into a dataset via SSIS
SSIS copy directory from FTP location to a shared network location
SQLServer Native Client Error "Connection Busy With Results From Another Command" in SSIS
How Do I Check Job Status From SSIS Control Flow?
How do I get SQL Server Integration Services to use a different database connection for Package Configuration
Can you start a scheduled Windows task from SQL Server Integration Services ?
SSIS: Adding a constant column value when doing a CSV to SQL conversion
SSIS convert image blob
Good Starting Places for SQL Server Alerts/Notifications?
Accessing Excel data source running SSIS package on 64 bit server
Execute stored procedure (SQL 2005) and place results into a CSV file on a FTP location