I am working w/ SQL Server 2005 and Management Studio Express.......I have set up my first SQL database, based on data definition and data files that have been provided to me........I executed ran a series of queries setting up the database, adding the tables,
and creating the indexes, with no problem......so I think the shell is set up properly......
My next step is to run an ImportData.bat file that generates a bcp script which I have copied and pasted below....my problem is that, although this script seems to load, my database is still empty -- i.e. it does not seem to be actually importing the data......is
there someone out there who might be able to help walk me through this? it seems like a simple thing that I'm not doing......
Thanks!!!!
set dataFolder=.\TX_SOR
set formatFolder=.\SqlBcpFormatFiles
@ECHO OFF
cls
set /p s=SQL Server:
set /p u=SQL Usr:
set /p p=SQL Pwd:
...
Go to the complete details ...