Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bhushanhegde
Starting Member
14 Posts |
 Posted - 2008-12-18 : 05:06:13
|
| Hi,my query in procedure is as follows:SET @VSQL='SELECT @STORE_DATA=DUMMYCOL1_FILLER,@STORE_LENGTH=LEN(DUMMYCOL1_FILLER) FROM OPENROWSET(BULK N'''+@P_DATA_FILE+''',formatfile=''D:\BCP\COUNT.FMT'', FIRSTROW=1, LASTROW=1 )as document'exec @vsqlI faced following error:Could not locate entry in sysdatabases for database 'SELECT @STORE_DATA=DUMMYCOL1_FILLER,@STORE_LENGTH=LEN(DUMMYCOL1_FILLER) FROM OPENROWSET (BULK N'D:\bcp\temp'. No entry found with that name. Make sure that the name is entered correctly.All path correct only.pls help me.bhushan |
|
|
|
|
|
error in output