Thanks for your advise. I will revise my method here.

Hi , I have an oledb connection manager using SQL server native client in my package. How can i use the same in script task (VB 2008 code) to execute some sql command. I did google around but didnt get a it done. Thanks, Ann

Your best course of action is to NOT do this. Use the Execute SQL Task to run SQL commands. If you need to use a script task to formulate the command, then do so and put it in an SSIS variable, then use that variable in an Execute SQL Task. Using the Execute SQL Task is preferred because it allows SSIS to make it participate properly in transactions and connection pooling. It also makes maintenance and debugging easier. Here's how to access OLEDB connections, but both Matt and I don't recommend it... Talk to me now on