Post reply

How to call .sql file from SSIS?

  • April 22, 2009 at 10:48 am

    #220520

    I have a SQL Script file with Begin Transacition and End Transaction. Instead of putting the script in

    SQL statement in Execute SQL Task, I would like to maintain a external file contianing this script. How do I call a .sql file from SSIS?

    Thanks much in advance.

  • April 22, 2009 at 5:14 pm

    #982607

    Not done it myself, but in the Execute SQL task change source type to FileConnection and then set the FileConnection property accordingly ... Looks like it should work.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

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

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