|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
SSIS Boolean Questions
Please write YES/NO against point number in your answer i.e. for example:
1) YES, 2) YES, 3) NO, 4) YES etc. We have source SQL Server 200 databases in one instance and target SQL Server 2005 in another instance both being on different windows 2000 server systems. Target OLAP DB design is derived from source OLTP. Most master & transaction tables are as is but some target tables are a result of merging source tables. We need to do SSIS packages based migration using data flow task based on column mapping & queries using Business Intelligence Development Studio (BIDS). There are no transformations required. 1) Can I group packages under project into sub-groups i.e. super packages? 2) Can I execute a set of packages together which are logically/physically grouped? 3) Can we execute set of ordered packages/individual packages from command line and even stored procedure? 4) Can we maintain transaction integrity across the entire set of ordered packages we execute? 5) Can we send a mail to mail id(s) in case of events like OnError etc. 6) Can we schedule the packages? 7) Does SSIS provide via BIDS a way to compare data in source with target to decide what got inserted/deleted/updated and based on that do the necessary? 8) Can SSIS packages be developed including code for data encryption? 9) Can we pass parameters to packages that get called from stored procedure? 10) Can we call stored procedure/function in SSIS package? |
![]() |
| Viewing: Dev Articles Community Forums > Databases > Microsoft SQL Server > SSIS Boolean Questions |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|