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.

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

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