Some of SSIS stuff: variables and its assignations
Some of SSIS stuff: VARIABLES and its ASSIGNATIONS.
For a file connection log:
(ConnectionString)
@[User::RutaLog]+ @[System::PackageName] + ".log"
Where RutaLog stands for a string value which contains the path for you .LOG file
For a OLEDB Connection:
(InitialCatalog)
@[User::BD]
Where BD stands for string value which contains the name of your database
For a properties such as MessageSource (Send Mail Task) or whatever similar:
" El Modelo " + @[User::MODELO] + " del ejercicio " + (DT_WSTR,4)@[User::EJERCICIO] + " se ha cargado . \nSe han insertado " + (DT_WSTR, 8) @[User::REGISTROS] + " registros . \nSe puede comprobar desde la aplicación NS"
REMARK: I warn you the use for '\n' literals inside the main literal.
For a file connection log:
(ConnectionString)
@[User::RutaLog]+ @[System::PackageName] + ".log"
Where RutaLog stands for a string value which contains the path for you .LOG file
For a OLEDB Connection:
(InitialCatalog)
@[User::BD]
Where BD stands for string value which contains the name of your database
For a properties such as MessageSource (Send Mail Task) or whatever similar:
" El Modelo " + @[User::MODELO] + " del ejercicio " + (DT_WSTR,4)@[User::EJERCICIO] + " se ha cargado . \nSe han insertado " + (DT_WSTR, 8) @[User::REGISTROS] + " registros . \nSe puede comprobar desde la aplicación NS"
REMARK: I warn you the use for '\n' literals inside the main literal.
posted by Enric at 3:21 AM
1 Comments:
Hello. This post is likeable, and your blog is very interesting, congratulations :-). I will add in my blogroll =). If possible gives a last there on my site, it is about the CresceNet, I hope you enjoy. The address is http://www.provedorcrescenet.com . A hug.
Post a Comment
<< Home