TABLE A BRANCH_ID ADDRESS_NUMBER ADDRESS_SHIP_TO PRODUCT_ID_KEY ISO_LANGUAGE 1561001 NULL NULL 10005899 en-US 1561001 NULL NULL 10005899 nl-NL 1561001 35023080 NULL 10005899 en-US 1561001 35023080 35023080 10005899 en-US TABLE B BRANCH_ID ADDRESS_NUMBER ADDRESS_SHIP_TO PRODUCT_ID_KEY ISO_LANGUAGE 1561001...

how to insert the record from one table to another,the tables are in different database thanks in advance.................. sureshk

Hi There, I experience a failure in execution of DTS package failing in a DTSExecuteSQLTask, which is used to populate rows in a table. Please find the SQL Error logging for the same below Step 'DTSStep_DTSExecuteSQLTask_8' failed Step Error Source: Microsoft Data Transformation Services (DTS...

Welcome to the forum !! Would you re-phrase your question...... Do you mean how many ways one can insert data into SQL Server table? If so, you may use insert statement, you can insert data from flat file(excel,text) or you may transfer data from existing database (access,mysql,oracle etc.)

Hi, The first and simplest way is to take a backup and restore it in MSDE version, you may use import - export wizard too or you may create insert script http://vyaskn.tripod.com/code.htm#inserts ; this may also interest you http://www.codeproject.com/dotnet/ScriptDatabase.asp Do not post duplicate thread...