Post reply

sp_OAMethods

  • August 5, 2004 at 12:43 pm

    #60177

     Hi everybody !!!

    I'm trying to execute a "bulk Insert" task in a DTS package from a system Extended Stored Procedure, called 'sp_OAMethod'.

    The question is: How do I set via T-SQL the "DataFile" property of my "DTSBulkInsertTask" task, before executing the package ?

  • August 13, 2004 at 12:17 pm

    #518945

    >>The question is: How do I set via T-SQL the "DataFile" property of my "DTSBulkInsertTask" task, before executing the package ? <<

    I don't believe that you can do it in T-SQL, but you should be able to do it from an ActiveX task.  As I recall, there was an article here on SQLServerCentral that may give you some insight about altering the properties of your package dynamically.

    http://www.sqlservercentral.com/columnists/kfeit/portabledtspackages.asp

    I hope this helps.

Viewing 2 posts - 1 through 2 (of 2 total)

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