Difference between Destination adapter and bcp in Sql server 2005

Hi,

Will someone please tell me what is the difference between Destination adapter and bcp in Sql server 2005 ?

Thanks and Regards

Altaf Nizamuddin

BCP is a utility with which you can do import and export of data

Destination Adapters are all directly impacted by the performance of the file system. File IO isn't always a bottleneck, but when combined with low memory conditions, causing spooling or with other disk intense operations, it can significantly impact performance. Components that read and write to disk should be scrutinized carefully, and if possible, configured to read and write to dedicated hard drives. Look for ways to optimize the performance of the hard drives using RAID, defragmentation and/or correct partitioning.

The Destination Adapter must connect to your SQL Server 2005 MSDB database. After defining the connection you will try to select the dbo.sysdtspackages table in the destination but it will not show up in the drop down list. I found you need to define a variable at the package level using the string data type and provide a value of "dbo.sysdtspackages". Then go back to your destination's Data Access Mode drop down list and select "Table name and view name variable". This will activate the Variable name drop down list. Select the variable you just created with the dbo.sysdtspackages value.

Difference between Destination adapter and bcp in Sql server 2005

Hi,

Will someone please tell me what is the difference between Destination adapter and bcp in Sql server 2005 ?

Thanks and Regards

Altaf Nizamuddin

BCP is a utility with which you can do import and export of data

Destination Adapters are all directly impacted by the performance of the file system. File IO isn't always a bottleneck, but when combined with low memory conditions, causing spooling or with other disk intense operations, it can significantly impact performance. Components that read and write to disk should be scrutinized carefully, and if possible, configured to read and write to dedicated hard drives. Look for ways to optimize the performance of the hard drives using RAID, defragmentation and/or correct partitioning.

The Destination Adapter must connect to your SQL Server 2005 MSDB database. After defining the connection you will try to select the dbo.sysdtspackages table in the destination but it will not show up in the drop down list. I found you need to define a variable at the package level using the string data type and provide a value of "dbo.sysdtspackages". Then go back to your destination's Data Access Mode drop down list and select "Table name and view name variable". This will activate the Variable name drop down list. Select the variable you just created with the dbo.sysdtspackages value.

sql

difference between BCP and DTS

Hi Experts,
please tell me the difference between BCP and DTS

provide me links if possible.

thankyou very muchHai friend

refer this link
http://www.google.co.in/search?hl=en&q=difference+between+BCP+and+DTS&meta=

thanks
Vssp

Development server database refresh from production server

Hi
Can we use BCP AND/OR BULK INSERT to do development server databse refresh from production server . I have to do this by following the rules below:

- no truncation of source table
- update of changed or new records only.

I know we can use replication, dts and other methods for this but I need information about this one.

ThanksUsing BCP and/or Bulk insert to update a development server is possible, but would get complicated if you only want to update the changed records in the production server. If you want to only update the changed records you will need to somehow keep track of the records which changed in the production db, and this could lead to expanding your production db by adding extra columns or tables, which is probably not wanted. Overall I would not recommned this procedure.

Something like log shipping in SQL 2000 might be a better solution.

Good luck
Hope this helped