Post reply

DTS Question: Is this possible?

  • November 19, 2003 at 12:25 pm

    #160973

    I am setting up a package that will export data from a table to a text file. My dilemna is that I need to tell the package what to export. For example, I only want records that are dated within the range that my client enters on an .asp page. I thought I was on the right track with a Data Driven Query Task, but I can't enter a variable as the value for the Input Global Variable, at least not so far.

    Does anyone know a solution to this problem? I am a web developer who knows a little about SQL Server, but I need to know so much more!!

    Thanks so much,

    Michelle

  • November 19, 2003 at 1:08 pm

    #482736

    You could have your ASP page enter the query parameters into a database table then start the DTS package. The package could read the parameters with an execute SQL task.

    "I met Larry Niven at ConClave 27...AND I fixed his computer. How cool is that?"

    (Memoirs of a geek)


    "I met Larry Niven at ConClave 27...AND I fixed his computer. How cool is that?"
    (Memoirs of a geek)

  • November 19, 2003 at 1:42 pm

    #482748

    I passed my variables from asp page to a user stored procedure which in turn created a DTS package (sp_OACreate 'DTS.Package') which set the global variables using (sp_OASetProperty). Works great, its all in the BOL


    A.S.

    MCSE, ASE, DBA

    Webmaster

    Applications Developer

  • November 19, 2003 at 2:51 pm

    #482755

    Thanks for the help! I am going to give both ideas a try and see how they each work out!

    Michelle

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

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