VS2010 Database Project - BAT file in post deployment script


  I have a bat file containing bcp commandwhich I attached/added under Post-Deployment folder in database project.  
  I want to inkove this batch file from post-deployment script (Script.PostDeployment.sql).

  How do I do it?

  I tried by including the following in the post-deployment script, but it throws "Error SQL01268: SQL Execution error: Scripting warning. Command ExecuteShellCommand is not supported." error.

:!! New_Rebuild_Admin.bat

Open in new window

Who is Participating?
jogosConnect With a Mentor Commented:
exec xp_cmdshell

But this can be disabeled
Eugene ZConnect With a Mentor Commented:

•How to: Specify a Pre-build or Post-build Command Line - http://msdn2.microsoft.com/en-us/library/aa833213(VS.80).aspx
 •Pre-build Event / Post-build Event Command Line Dialog Box (Team Edition for Database Professionals)  - http://msdn2.microsoft.com/en-us/library/aa833259(VS.80).aspx
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.