Metadata driven SSIS

Hot Topic

Default values for a column - From a function
Runnaway UPDATE statement in SQL2005 - how to resolve?
VS/RS bugs
Native XML in SQL Express 2005 same as SQL 2005 standard, workgroup and enterprise?
Configure TCP/IP port during unattended instance installation
cannot install Northwind database in SQL Server Express
Report Publishing broken
table or view doesn't exist
Publish the cubes on the web portal
Database 'msdb' cannot be opened

SQL Server

Packages not executing right on production server?
Paging large result sets
Complex SQL Query
Cannot subscribe via email
error changing subscription properties
Hotfix for "Cannot apply value null to property Login" error available?
Export a report to Excel : Data in a column become several columns
Inserting images
Code Completion of SQL Statements in 2005
Help setting up replication on remote IIS

Metadata driven SSIS

  I am looking for some pointers on Metadata driven SSIS.  Specifically, how to automate creation of a large number of packages in SSIS using metadata.  I am looking at this as a solution to deploy multiple packages on multiple servers. Any other ideas on this would be highly appreciated.< xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

 

Thanks

 

Vishal Verma

Answer this question

Metadata driven SSIS

  • GrkEngineer

    While I cannot confirm Suresh is correct (and in fact this is the first time I'm hearing this being associated with service pack), you can go through the object model documentation and generate the packages programmatically. 

    regards,
    ash


  • Alan Fransham

    This feature is not  available right now. But seems we can get this feature in the next service pack (may be in end 2006)

  • Skorpion

    By the way, I think what Suresh may be talking about here is that we're doing some work to identify and promulgate best practices around metadata for IS that will be released as either a KB article or whitepaper. That is supposed to be available around the time IS is released. But, no new metadata features, per se.

  • Jack Patrick

    Ash is correct as usual. There are no confirmed plans for work in the SP. You may have interpreted what Kamal or Donald said as an assertion of forthcoming features. That is not correct. The planning for SPs and other releases is still under way and will not be announced for some time.
    K

  • samujob

    Well, I am not sure either. I read some posts by Microsoft guys (Ash why dont u chat with ur boss Kamal or Donald) and what I infered is that we might get something in near future.
  • Metadata driven SSIS
Answer this question