|
|
-
Nirav Gandhi Commented 7 Months ago through Just Learned
HI Sudeep,
you are right....i was forget to mention this.
thanks for Comment......
|
-
Nirav Gandhi Posted 7 Months ago through Just Learned
Hello friends today i check foreign key constraint can't support in bulk insert task.please take corrective action when you upload data.
Create table Tbl1
(
id int primary key,
varname varchar(50),
fk_ID int
)
Alter table T...
|
|
|
-
Nirav Gandhi Posted 7 Months ago through Just Learned
Copy And paste Query
Create table #temp1
(
id int ,
Name varchar(50),
City varchar(50)
)
Create table #Staging_temp2
(
id int,
Name varchar(50),
City varchar(50)
)
insert into #temp1
se...
|
-
Nirav Gandhi Posted 7 Months ago through Blogs
SSIS Bulk Insert task bypasses FOREIGN KEY constraint...
|
-
Nirav Gandhi Liked 7 Months ago through Just Learned
Hello friends, one interviewer asked that suppose you have two tables
Employee_Details, Employee_Details_History
now I want to delete original table Employee_details and maintain it’s history to other table.
How can it’s possible with only single...
|
-
Nirav Gandhi Learned 7 Months ago through Just Learned
Hello friends, one interviewer asked that suppose you have two tables
Employee_Details, Employee_Details_History
now I want to delete original table Employee_details and maintain it’s history to other table.
How can it’s possible with only single...
|
-
Nirav Gandhi Liked 7 Months ago through Just Learned
Hello friends today i check foreign key constraint can't support in bulk insert task.please take corrective action when you upload data.
Create table Tbl1
(
id int primary key,
varname varchar(50),
fk_ID int
)
Alter tabl...
|
-
Nirav Gandhi Learned 7 Months ago through Just Learned
Hello friends today i check foreign key constraint can't support in bulk insert task.please take corrective action when you upload data.
Create table Tbl1
(
id int primary key,
varname varchar(50),
fk_ID int
)
Alter tabl...
|
-
Nirav Gandhi Liked 7 Months ago through Just Learned
Copy And paste Query
Create table #temp1
(
id int ,
Name varchar(50),
City varchar(50)
)
Create table #Staging_temp2
(
id int,
Name varchar(50),
City varchar(50)
)
insert into #temp1
...
|