Bulk insert error column name

Help Activities
, ,
1

i am getting the below error however i don’t have a column that contains from word

Bulk insert: Deferred prepare could not be completed.
Statement(s) could not be prepared.
Incorrect syntax near the keyword ‘from’.

2

Hi @omar_ismail

Check the syntax in the insert sql query.

Give a brief at which query you’re getting the error

3

Hi @omar_ismail

Check your SQL query. Please share your query, we will help in sorting the error.

Regards

4

SELECT TOP (1000) [Id]
,[Title]
,[EmployeeName_1]
,[EmployeeName_2]
,[EmployeeName_3]
,[WaveNumber]
,[FrontImageURL]
,[BackImageURL]
,[Merged]
,[AccountName]
,[LoBName]
,[Gender]
,[NameInArabic]
,[DateOfBirth]
,[AddressInArabic]
,[Address_BuildingNo_]
,[IDNumber]
,[MobileNumber]
,[Nationality]
,[GraduationStatus]
,[University]
,[Major]
,[MaritalStatus]
,[NewHire]
,[Religion]
,[Language]
,[Recruiter]
,[Salary]
,[Basic]
,[GB]
,[KPI]
,[PersonalEmail]
,[HiringDate]
,[OnboardingSpecialistName]
,[Premises]
,[BMSID]
,[TPEmail]
,[DocType]
,[NameinEnglish]
,[PositionTitle]
,[EndDate]
,[Program]
,[ManagerIdent]
,[TPUsername]
,[CandidateID]
,[ContractType]
,[PositionType]
,[PositionDepartment]
,[City]
,[ProbationDate]
,[EmployeeLocation]
,[Modified]
,[State]
FROM [TAP_Bots].[dbo].[External_WFR]

5

@omar_ismail

Can you try with the below query

SELECT TOP 1000
    [Id],
    [Title],
    [EmployeeName_1],
    [EmployeeName_2],
    [EmployeeName_3],
    [WaveNumber],
    [FrontImageURL],
    [BackImageURL],
    [Merged],
    [AccountName],
    [LoBName],
    [Gender],
    [NameInArabic],
    [DateOfBirth],
    [AddressInArabic],
    [Address_BuildingNo_],
    [IDNumber],
    [MobileNumber],
    [Nationality],
    [GraduationStatus],
    [University],
    [Major],
    [MaritalStatus],
    [NewHire],
    [Religion],
    [Language],
    [Recruiter],
    [Salary],
    [Basic],
    [GB],
    [KPI],
    [PersonalEmail],
    [HiringDate],
    [OnboardingSpecialistName],
    [Premises],
    [BMSID],
    [TPEmail],
    [DocType],
    [NameinEnglish],
    [PositionTitle],
    [EndDate],
    [Program],
    [ManagerIdent],
    [TPUsername],
    [CandidateID],
    [ContractType],
    [PositionType],
    [PositionDepartment],
    [City],
    [ProbationDate],
    [EmployeeLocation],
    [Modified],
    [State]
FROM
    [TAP_Bots].[dbo].[External_WFR];

Hope it helps!!

6

Hi @omar_ismail

Try the below syntax:

SELECT TOP 1000 
    [Id],
    [Title],
    [EmployeeName_1],
    [EmployeeName_2],
    [EmployeeName_3],
    [WaveNumber],
    [FrontImageURL],
    [BackImageURL],
    [Merged],
    [AccountName],
    [LoBName],
    [Gender],
    [NameInArabic],
    [DateOfBirth],
    [AddressInArabic],
    [Address_BuildingNo_],
    [IDNumber],
    [MobileNumber],
    [Nationality],
    [GraduationStatus],
    [University],
    [Major],
    [MaritalStatus],
    [NewHire],
    [Religion],
    [Language],
    [Recruiter],
    [Salary],
    [Basic],
    [GB],
    [KPI],
    [PersonalEmail],
    [HiringDate],
    [OnboardingSpecialistName],
    [Premises],
    [BMSID],
    [TPEmail],
    [DocType],
    [NameinEnglish],
    [PositionTitle],
    [EndDate],
    [Program],
    [ManagerIdent],
    [TPUsername],
    [CandidateID],
    [ContractType],
    [PositionType],
    [PositionDepartment],
    [City],
    [ProbationDate],
    [EmployeeLocation],
    [Modified],
    [State]
FROM 
    [TAP_Bots].[dbo].[External_WFR];

Regards

7

My issue that the BOT can’t add the data from the query sheet to the SQL so please clarify what to do excatly with the query provided

8

@omar_ismail ,

I’m not sure how you are inserting the data with Select query. It should be something like INSERT INTO [TABLE NAME] (Column1, column2,....) VALUES (Value1, Value2,.....)

You can use this approach.

  1. Read Range into DataTable
  2. Connect to Database
  3. Use Insert Activity - Pass Database Table Name and DataTable

image
image453×642 48.9 KB

You can refer this video from @mukeshkala where he explained it very well.

Thanks,
Ashok :slight_smile: