I am running a bulk insert sql script
Ex:
BULK
INSERT [PostcodeLookupDetail]
FROM 'C:\Users\Srinivas\Documents\Compass\SQL\LocationData\AU_complete.txt'
WITH
(
FIRSTROW = 2,
FIELDTERMINATOR = ';',
ROWTERMINATOR = '\n'
)
GO
I am replacing the txt file location with ' Sript Replacements' as
Find What Replace with
C:\Users\Srinivas\Documents\Compass\SQL\LocationData\AU_complete.txt [MY_CompletetxtFile]
MY_CompletetxtFile is a temporary file which is located in C:\Users\prabhu\AppData\Local\Temp\AU_complete.txt
My problem is when i run the script through advanced installer I am getting
An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.
When I run the same script in sql server it works fine. Please Suggest me If I do any thing wrong.
FOLLOW US
Get the latest news in Application Packaging