September 16, 2009 at 6:54 am
Hello, I am trying to use multicast in a package. I think I'm either doing something wrong, or perhaps I have misunderstood what multicast is supposed to do. I am trying to copy data to tables on two different servers (production and development).
The data comes from a staging table on the production server (OLE DB source). Then I pass that through multicast. From there, I have two arrows going to my OLE DB destinations. When I run the package, all the boxes turn green. And the counter over each arrow shows the number of rows being transferred. The data going to both OLE destinations show the same number of rows. So it looks like data is going to both destinations. But when I query the table on each server, I can see the new rows only in the production table, not on the development server.
So I’m wondering why it shows rows going to that OLE destination, but they aren’t actually being added to the table.
September 16, 2009 at 7:02 am
I just noticed something else. Each data flow shows 440 rows are being transferred. But I see 880 new rows on the production server, and zero in development. So it looks like all my data is being loaded in one place (and duplicated).
September 18, 2009 at 4:14 pm
Check your connection string again. If you have variables or configuration files check them too. I have feeling that the same server is being pointed in both the destinations.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply