Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
FreeHansje
Starting Member
3 Posts |
 Posted - 2005-12-29 : 08:53:24
|
| Hi,I have this DTSpackage, several Data Transformation tasks from a SybaseDB to a SQL2K. On the one site a have an OLE DB connection for Sybase from Sybase ASE OLE DB provider, on the other site our trusted Microsoft OLE DB Provider for SQL Server, pointing to DB1. Now I have changed something in my Data Transformationtasks, created a duplicate targetDB, DB2, and run the package. Succesfully ended, it says. I look in DB2 and see no records... I try again, and again: no records appear in DB2. I check connection parameters: yes, the targetdatabase is definitely DB2. I run it again, succesfully, and no records in DB2...I wake up and check DB1. A lot of records... Suspicious now I run the package again, no records in DB2, and lo! New records added in DB1!I check again: yes, the target IS DB2!I detach DB2 and run the package again, message: Error in Ole DB for SQL Server, unspecified error...What is going on here? I point to DB2, but DB1 is still the target, although the properties of the Connectionsource tells me otherwise.When I open the Data Transformationtask, obviously I can change the properties so it points to the right Server/DB, but there are almost a 100 Transformationtasks, you don't want to change them manually. Ofcourse I can make an ActiveX script to change this automatically, but that should not be necessery.I have tried to use MS Datalink, which is made for changing your Connectionproperties in 1 place, but to no avail: the problem still exists. I have submitted this to MS Support, but sofar they only ask for more info and suggest options, which do not touch the issue. I am running SQL2K sp3 on W2003 server.Greetz,Hans Brouwer |
|
|
mcarahul
Starting Member
11 Posts |
Posted - 2005-12-30 : 04:55:39
|
| Make a new connection for DB2 database. Then point your transformation to this new connection.Then it will work. |
 |
|
|
|
|
|
|
|
Connectionsource blues....