multumesc pentru raspunsuri

AM rulat local packageul si am alta eroare :the aquieder connecion methode call to the connection manager "destinatie" fails with error code 0xc0202009.

Eu incerc sa setez connection string la conexiunea destinatie din evenimentul onpreexecutepackage dintr-un obiect de tip script cam asa:

If Dts.Variables.Contains("bazadate") = True And Dts.Variables.Contains("unitate") = True Then

Dts.Connections("destinatie").ConnectionString = "Data Source=192.168.0.45,1206;User ID=jiji;password=beecali;Initial Catalog=" + Dts.Variables("bazadate").Value.ToString() + ";Provider=SQLNCLI.1;Persist Security Info=True;Auto Translate=False;"

end if