Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nord
Posting Yak Master
126 Posts |
 Posted - 2011-12-14 : 13:25:28
|
| Hello all!I hace some ssis and i need name of ssis insert to some table in sql,if this possiblewhy i need it?i have some folder,in folder arriving txt files,i need ssis take files txt and insert informations by ssis in table,but in txt folder exixt some files for several ssis,how i can select themthanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
nord
Posting Yak Master
126 Posts |
Posted - 2011-12-14 : 13:38:46
|
| i have 3 several package ssis and i need names of every package insert to variable |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-15 : 00:12:03
|
| hmm? i thought you're asking for data transfer from fileswhy should you insert package name for that?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
nord
Posting Yak Master
126 Posts |
Posted - 2011-12-16 : 08:40:49
|
| i get it,the system variable take name of ssis: Dts.Variables.Item("PackageName").Value |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-16 : 09:35:56
|
| yeah System::PackageName will give you the name of package------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
nord
Posting Yak Master
126 Posts |
Posted - 2011-12-16 : 16:08:20
|
| it's work it's good!!!!! |
|
|
|
|
|
|
ssis