hi,

Within the BIDS I can see the Table previews and be able to see the data in there. But when I try to execute I get that error. ALso I have tried solution where I use the configuration file to insert password manually but did not work. I am using 32bit version of the SQL server.

Thanks,

Jay