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 |
|
Ali Chadorbaf
Starting Member
44 Posts |
 Posted - 2007-11-07 : 11:08:23
|
| HiWe have a list of 40-50 SSIS packages and could grow up to 100. Each one loads 5-20 tables. I’d like to write a program (probably another package utilizing "Script task/component") to:1- List all the packages by name 2- List input and output tables and/or file systems for each package 3- List child packages and procedures that are referenced in each package So I need to have access to the Package properties.I would like to hear your idea/clue/tips and or any helpfull direction.Thanks so much. |
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2007-11-07 : 13:59:42
|
| Check out MSDB, which typically is the default place for all SSIS.dbo.sysdtspackages is the master table.Select [name] from MSDB.dbo.sysdtspackageswill give you the names of all your packages. |
 |
|
|
Ali Chadorbaf
Starting Member
44 Posts |
Posted - 2007-11-12 : 13:15:23
|
| Thanks. However, our ssis packages stored in the file systems not MSDB. Any idea on this? |
|
|
|
Ali Chadorbaf
Starting Member
44 Posts |
Posted - 2007-11-12 : 23:55:54
|
| I am trying to write a VB.NET program to list all ssis packages we have stored in a file folder (not in MSDB) where both SqlServer and ssis servers are located. These packages currently running on daily basis by automated jobs with no problem. I have found the following link on the web that includes VB.Net program. If you scroll down under Example (SSIS Package Store) , you'll see a VB.NET program that I am trying to get it to work for me but keep getting error message like "Cannot find folder...." http://msdn2.microsoft.com/en-us/library/ms403343.aspx My goal is to: 1. List all ssis packages stored in the file systems (.dstx) 2. List DB source and distination providers(tables in/out) in a ssis package 3. List properties for DB providers 4. List FlatFile & Excel file provider properties in a ssis package. My assumption is that I should somehow register this file folder (where packages are located) to the SqlServer ???? I would appreciate to hear your idea. |
|
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2007-11-13 : 00:11:53
|
Make sure you are specifying the correct folder path, the method works if the correct information is passed, and make sure that you are looking at the server name or localhost not (local)
Poor planning on your part does not constitute an emergency on my part. |
|
|
|
|
|
|
Pragmatically access to Package Properties?