Post reply

I badly need to insert filename along with data in DTS package and am losing on this one

  • November 2, 2006 at 7:56 am

    #669473

    I think I have a simple solution for you, but I want to be sure that I know what you want.

    Do you want the column name to be the filename, or do you want the filename to be a value in the column of the table? 

    Live to Throw
    Throw to Live
    Will Summers

  • November 2, 2006 at 9:50 am

    #669554

    Thanks for the follow up Will. I actually figured it out in that I just used this notation

    oPKG.GlobalVariables("sFilename") = f1.name

    and in the child package the DTSDestination... worked fine.

    I have a book on DTS that actually encompasses VBSccript, but it doesn't really give enough "sensica;" detail for solutions.

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

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