Hi Chrishell,

Yes it does, and ofcourse I can change that to the table it is supposed to be, which is shown as well. However, int this DTSpackage there are scores...

Tnx for responding. However, the point is, that I CANNOT change the DataSource, either directly or through Disconnect Edit. I have layed the issue down at the MS SupportDesk, hopefully...

Tnx for the replies. I am currently using tmpTables to put all needed tables in 1 DB. I was just wondering if it could be done in another way.

Hi Mike,

Yes, I have created a new connection for DB2 and used the old 1 with a new targetserver. I do use the SQLServerConnection in DTS. I run the package...

Hm..I think I did not make completely clear what I intend to accomplish.

There is this datatransfer from Table1 to Table2; these tables are similar, but for 1 extra column in...

Never mind my last posting, I think I got it running. I did a test with the real-life tables, uneven columncount and added the line to fill the last column....

Tnx Phil, I think I solved the problem with your help, but still am flabbergasted why it did not work. I had used the msgbox to check my Global end...

Problem solved, tnx all. Never thought of the dynamic properties task...

Tnx again.

'Have you tried typing a password into the property value?'

Yes I have, it makes no difference, login failed. And keep in mind, that a PW has been set when making...

I am not talking about a Package PW. I am talking about the PW used in the connectiontask.

When I look in the properties of this specific connection, I can see...

I am using an ODBC DSN from Sybase ASE ODBC driver. But does that matter? I can change all kinds of properties when in Disconnect mode, except for this passwordproblem?

That simple, huh? I was thinking about trailing blanks changing into zero...

Tnx, Noeld

Tnx Jonathan,

It still does not tell me why. But: I found that 1 too. It seems a COM is created for each mapping. Bundling the columns will create 1 COM,...

Man, Ten, I would never had gotten this together! Tnx, I think I can work from this script.

Sushila, tnx too. I should have thought of the sp_forEach... procedures myself, I...

Tnx for the help, works like a charm