Dear Elliott

Thanks for your reply, i'd followed some links in net and started creating the package, but could not acheive what i wanted to, in your post u'd...

Dear sir, happy to receive your reply, i was off for a week so i could not reply my apologies, if you wish i would like to elaborate my query...

Hi guys,

i've solved the exception, the mistake was with the connection string format

the previous connection string was

"Provider=SQLNCLI10;Server=1DTWN0023;Database= AdventureWorks;Uid=sa; Pwd=sa@123; Trusted_Connection=yes;";

but the correct format is

"Data Source=(local);Initial Catalog=AdventureWorks;Provider=SQLNCLI.1;Integrated Security=SSPI;Auto...

Hi Gianluca

Thanks for your reply, i found it in the Binn folder, thanks a lot...

Thanks dude...

nw i'm able to run the package from my code, the problem is even after i change the destination server name and database name in the xml file, the...

vikas i've one more doubt...

if i have connection managers for both source and destination, then wt is the use of xml file???

bcoz basically while v r adding the...

Hi vikas thanks for ur interest dude...

i've made it work... actually i was missing the password value in my xml....

once i updated the xml file with the password it...

i'm sorry i'd uploaded the image but got lost... here is the error message.....

Information: 0x40016041 at Package: The package is attempting to configure from the XML file "C:\Documents and...

Does the package accesses the file when you run it from VS IDE?

No, its is not accessing the configuration file, when i run the package it is displaying...

Hi vikas thanks for your reply...

i've created the xml file, and followed the steps to configure the file, but when i execute the package from my .net application, it...