February 28, 2008 at 9:37 pm
I want to create flat file from sql script what i can do.
which is the best way to call bcp or to call sql file from batch file.
February 28, 2008 at 9:48 pm
Or use Data Transformation Services (might be called Import/Export Data in your start menu) if you want a nice wizard interface to guide you through the process.
February 29, 2008 at 6:09 am
Actually what I am trying to do is run a SQL script from batch file. I am able to run the script successfully using osql utility (I can not use sqlcmd because I am working with SQL 2000).
But now I need to run the same osql thing from a batch file and I am not able to do so. And I need to add around 10 scripts like this.
Is there a way to get this done? I need a solution asap please!!!! :sick:
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply