Post reply

I dont have ExecuteSQL Task option in the tool bar...

  • August 10, 2006 at 2:16 pm

    #113260

    Hi,. All

    I am trying to do something that is related with ExecuteSQL Task.

    However I can not find this option in ToolBox..

     

    Any Idea?

     

    Thx

    Jay

     

  • August 11, 2006 at 3:34 am

    #654498

    If you are in the Control flow, it certainly should be there - in the 'Control Flow Items' grouping - make sure it is expanded. If you are in the Data Flow, you need to build up your 'task' using the items provided. Bear in mind, you can also use SQL inside some of the items - for example the data source components.

    What are you trying to do?

  • August 11, 2006 at 7:47 am

    #654544

    Thx..

    Probably I was on drug..

    I couldnt find that one but right now,I can find it..

    What I am going to do is doing some kind of SQL command thing that I can move some of files before I populate that files again..

    However I am not sure that this can do it.. 2000DTS has that function that I can use.. Seems like I can not find similar function in 2005DTS.. I want to use DOS command to move file..

     

    Any Idea will help?

    Thx

    Jay

     

     

     

  • August 11, 2006 at 8:20 am

    #654567

    no problems.

    Yes, SSIS has the 'File system Task' is the Control Flow pane which covers most of these operations. There are a few that are missing, like MOVE DIRECTORY CONTENTS, but this task covers, amonst other things, MOVE FILE, COPY FILE, DELETE FILE, COPY DIR, DELETE DIR CONTENT, CREATE DIR, etc. etc.

  • August 11, 2006 at 8:26 am

    #654569

    Thx..

    Let me try..

    Jay

     

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply