SQL Server Performance

Execute SSIS Package From SQL 2000

Discussion in 'SQL Server 2005 Integration Services' started by alimmia, Jul 24, 2007.

  1. alimmia New Member

    I need to execute SSIS package from SQL Server 2000. Is there any way? Looks like, I can not use "Execute Package Task" in DTS to call SSIS package.

    Thanks,

    Alim Mia
  2. satya Moderator

    SSIS is introduced in SQL 2005 and you will not be able to perform from a SQL 2000 instance, you could use DTS within SQL 2000 instance.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    @http://www.askasqlguru.com/

    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  3. joeyjacoby New Member

    this is a pretty straightforward processs Alim. Go linked page and commit pre processed scriplet. do you understand or do i need to use better english? Where are you from buddy?
  4. FrankKalis Moderator

    [quote user="joeyjacoby"]
    this is a pretty straightforward processs Alim. Go linked page and commit pre processed scriplet. do you understand or do i need to use better english? Where are you from buddy?
    [/quote]
    Couple of points here.
    1. You are replying to a thread that is more than 1 year old (your other reply so far is to a thread more than 2 years old). I'm not sure the original poster will read it anyway.
    2. This is an international forum. Some here are native english speakers, some, including me, are not. Please respect this and keep it in mind when you reply next time.

Share This Page