DTS to Import .SQL file

[Paul Hayman]

Hi Guys, I have created a program that exports data from our old system to a .sql file that drops/creates and inserts, which works fine, the only problem I have is automating. How do you execute a SQL file from a DTS package? Obviuosly the file changes on a daily basis, but the filename can remain the same. Please help and thanks in advance, Paul.

[Mycroft Holmes]

Paul Hayman wrote:

How do you execute a SQL file from a DTS package?

that's a big ask in a forum message, you may find some tutorial and articles on Google [^]though

Never underestimate the power of human stupidity RAH

[Paul Hayman]

Actually the solution was fairly easy, just a one liner sorted it using sqlcmd. Thanks for your response though it's great that people do actually try and help. Paul.

[Mycroft Holmes]

So what was the one liner?

Never underestimate the power of human stupidity RAH

[Paul Hayman]

Sorry, was just happy to have a solution didn't think of posting.... sqlcmd -U USERNAME -P PASSWORD -S SERVER -d DATABASE_NAME -i yourfile.sql Pop that into a bat file and execute from the DTS package as a win32 process, all I need to do now is return a true or false from the bat file and pass back to the DTS package to confirm failure or success. Probably sounds easier than it will be.... Paul.