How can fix the problem so it will populate all the data

I am a web programmer I am just doing this on the back end.

I wrote stored procedures and they worked, but the company does not want to use SP....

I broke the query down but still unable to update the table

Function Main()

Dim cn '* As New ADODB Connection

Dim strConn

dim rs

Dim strSQL

Set cn= CreateObject("ADODB.Connection")

Set rs = CreateObject("ADODB.RecordSet")

' Connection to...

it does not give me any error it just does not update the table

Because the table contains other data

I am trying to update the table Since I already copied data the Id's on thedestination tables has been changed

fffff

Thanks it works

Yes I do have data that I need to access on the different database. That where I am getting the faculty status

By using DTS package

OK. I need to perform update. If the status change (from Full time to part time ) I need to update intCategoryId in both tables to 689

Here is the table tblItem defenition:3

intID int 4 0

intUID uniqueidentifier 16 0

intWebID int 4 0

intDataType int 4 1

intNavID int 4 1

intSubID int 4 1

intTabID int 4 1

blnFeatured bit 1 0

blnDeleted bit 1 0

blnApproved bit 1 0

intApproveUserID int 4 1

dtExpire datetime 8 1

intOrder int 4 1

intWebBackupID int 4 1

blnStagingNew bit 1 0

blnStagingChange bit 1 0

intCategoryID int 4 1

blnNeedsTranslation bit 1 0

intLastLevel int 4 0

and tblFacultyListing Definition:

3 intID int 4 0

0 intUID uniqueidentifier 16 0

0 intFacID int 4 1

0 txtTitle nvarchar 500 1

0 intCategoryID int 4 1

0 txtAbstract ntext 16 1

0 blnNotification bit 1 1

0 blnPrivate bit 1 1

0 txtDescription ntext 16 1

0 intItemID int 4 1

0 intResourceID int 4 1

0 blnLive bit 1 1

0 dtAdded datetime 8 1

0 dtStart datetime 8 1

0 dtEnd datetime 8 1

0 txtMetaKeywords ntext 16 1

0 txtMetaDescription ntext 16 1

0 intMetaID int 4 1

0 intImageID int 4 1

The sample data is for tblFacultyListing

8732 {2501F879-FD04-45F7-8BCE-E46BE9118C0C} 486 Agresti, William 688 0 10231 0

8733 {DF9DD2A5-01C5-4AA1-9486-B09562B0A3F7} 406 Anikeeff, Michael 688 0 10232 1

8734 {05254D4E-5019-4F61-A47D-AACBD23BF730} 1115 Baker Sr., John 688 0 10233 1

8735 {5BD132D0-856D-485C-B50E-1D9DFB04AAD3} 1901 Brunetti, Celso 688 0 10234 1

8736 {CAE6ACDB-B1D6-4B81-8D95-CF469CBD8B8F} 1158 Calvin, James 688 0 10235 1

8737 {726A46E7-22A9-447F-8AE3-58AAFE1BF232} 1327 Cheong, Kwang Soo 688 0 10236 1

8738 {012C1F40-4287-44B3-BB29-5306A26E13A4} 1155 Crain, Thomas 688 0 Thomas Crain, AM, holds the position of Director,...

Thanks

But I am using the right approach because my task will has to be scheduled every day

 

 

Hi I have problem here. I am trying to copy the data from 1 table to another but only want to copy the unique records. I wrote dts package that...