How should I write the code in the script component? I mean how can i refer to the columns in the code?

I have to import the excel sheet data into multiple tables in the database. For example the column name Region goes in the Region table and the Region Id for...

Yes, the error outout is configured as Redirect row, but still i get the warning and i dont see the data.

Thanks, thats working.

I figured it out. SSIS 2005 packages can only be created and edited with VS 2005. There is no plan to ever support editing SSIS 2005 packages with VS 2008....

Yes, I'm installing Developer edition on my machine for development and using Enterprise edition on the clients site during production.

Thanks for the help.

Thanks for the time and pain to find the information and type it. I really appreciate your help. It really helped me out.

Thanks once again.

Thanks, where can i find the details of developer edition and also I have to send the pricing to my manager.......

Would be great if you can help me out..

Thank again

Hi Jack,

This is what I have as the requirement:

•When an agency Name changes then all Users associated with that agency should be updated to the new agency name.

•When a...

Yes, I will be operating on 2 different databases but on same server. There is one active connection. The look up will be against the userids who have different agency...

Is this approach possible:

Use an OleDB source:

Read all the Agencies

Look up transformation for any Agency name changes

Use Oledb Command to update the tables in Database

And use second OleDB command...

Yes, I think so, but there is a password set on the Packages ,and I have no idea what the password is.

I'm sorry, actually the software architect confused me saying documentation at top level. I figured it out he meant the package at the top level.

Thanks

Thanks, it solved the problem.

Hey,

I'm using ADO.net connection as Connection type....will this work for it, b'coz I received an error while careting the object type variable.

Thanks