	[x] Posted via EE Mobile
	Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.

Question

	[x] Attachment Details

DTS packages / SSIS packages scripts

Asked by tapdev72 in SQL Server 2005, MS SQL Server, MS SQL DTS

Had 2 questions related with the script of
1. DTS package
2. SSIS package.

For both of the above, is there any system table where their script is stored. For debugging purposes, I can look at this place and see what tables or stored procedures they could be calling, instead of physically opening every package.

Thanks.

View the Solution FREE for 30 Days

20091021-EE-VQP-81 - Hierarchy / EE_QW_3_20080625

Hall of Fame

1. acperkins96,011
2. nmcdermaid65,253
3. rrjegan1752,100
4. reb7348,639
5. aneeshatti...34,920
6. PedroCGD28,511
7. angelIII25,560
8. HoggZilla25,350
9. cs97jjm318,980
10. chapmandew17,401
11. tigin4414,675
12. jimpen14,390
13. matthews...11,440
14. mark_wills10,550
15. Qlemo10,500
16. ralmada9,700
17. JestersGrind8,320
18. BrandonG...8,168
19. Sharath_...8,000
20. 8080_...7,700
21. EugeneZ7,450
22. CGLuttrell6,580
23. Wizilling6,400
23. RiteshShah6,400
25. DanielWilson6,150

1. acperkins495,695
2. nmcdermaid298,487
3. angelIII212,986
4. chapmandew169,911
5. arbert149,684
6. mark_wills99,952
7. EugeneZ94,490
8. cs97jjm392,124
9. aneeshatti...82,919
10. PedroCGD82,591
11. matthews...71,744
12. HoggZilla65,164
13. rrjegan1752,100
14. reb7348,639
15. rboyd5642,625
16. brejk40,930
17. ptjcb38,638
18. bhess138,130
19. Wizilling31,232
20. twoboats30,515
21. frankytee30,441
22. dready30,430
23. Yveau30,000
24. Sirees27,902
25. Zberteoc27,700