Thank you for the video, what changes would l need to make to the flow, if 1 or 2 of the records in the flat file load has been rejected? In this situation I would not want to move the file to archive.
i tried same thing but i got error([Flat File Source [2]] Error: Cannot open the datafile "C:\Users\ChanduGani\Desktop\flats ewfiles\Input folder\C:\Users\ChanduGani\Desktop\flats ewfiles\Input folder\a.txt". )
Hi sir! i need help. I have both of Data flow for two table in SQL, and i must create 2 ArchFile and 2 ESQL_Insert, they can be work, how i can just 1 ArchFile and 1 ESQL_Insert for 2 Data Flow, Thank sir!
I have created the for each loop with 3 types of file in 3 dataflow... first set of file processed successfully, and go for second only one file is processed and then loop got error. can you advice for this issue
After Deploying this package, it would be nice if the SQL Agent job throws an error while rejecting already loaded files, otherwise job will run successfully for both scenarios and one would never know if the file was loaded or rejected.
Hi Aamir thank you for the wonderful video. I am facing an error in Execute SQL task,where in the expression is written for picking up the file name. as soon as I insert the singe apostrophe after the variable @filename, the package is failing n the error is incorrect syntax.
DECLARE @FileName VARCHAR(100) SET @FileName= IF EXISTS (SELECT 1 FROM [dbo].[FileLoadStatus] WHERE filename =@FileName) BEGIN SELECT 1 AS FileExistsFlg END ELSE BEGIN Select 0 AS FileExistsFlg END am using above code but getting below error [Execute SQL Task] Error: Executing the query "DECLARE @FileName VARCHAR(100) SET @FileName=Pipe_..." failed with the following error: "The multi-part identifier "Pipe_Del_File.txt" could not be bound.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. Even i took file from foreach loop container and Execute sql task result set is kept single row
hello Aamir Sir, If we use expression in Connection Manager (FullFilePath) property then we do not have to use Delay Validation property to True? Can you please throw some light on it? thank you kindly in advance!
it trows me an error: [Execute SQL Task] Error: An error occurred while assigning a value to variable "LoadStatusFlg": "The type of the value being assigned to variable "User::LoadStatusFlg" differs from the current variable type. Variables may not change type during execution. Variable types are strict, except for variables of type Object.
Amazing video, exactly what i need
Hi. Just used this method where I have many files with different names and it worked perfectly! That you so much!
amazing tutorial all well explained thank you sir!
Thank you for the video, what changes would l need to make to the flow, if 1 or 2 of the records in the flat file load has been rejected? In this situation I would not want to move the file to archive.
i tried same thing but i got error([Flat File Source [2]] Error: Cannot open the datafile "C:\Users\ChanduGani\Desktop\flats
ewfiles\Input folder\C:\Users\ChanduGani\Desktop\flats
ewfiles\Input folder\a.txt".
)
Hi sir! i need help. I have both of Data flow for two table in SQL, and i must create 2 ArchFile and 2 ESQL_Insert, they can be work, how i can just 1 ArchFile and 1 ESQL_Insert for 2 Data Flow, Thank sir!
you're amazing thanks!!
thanks
I have created the for each loop with 3 types of file in 3 dataflow... first set of file processed successfully, and go for second only one file is processed and then loop got error. can you advice for this issue
After Deploying this package, it would be nice if the SQL Agent job throws an error while rejecting already loaded files, otherwise job will run successfully for both scenarios and one would never know if the file was loaded or rejected.
Hi Aamir thank you for the wonderful video. I am facing an error in Execute SQL task,where in the expression is written for picking up the file name. as soon as I insert the singe apostrophe after the variable @filename, the package is failing n the error is incorrect syntax.
DECLARE @FileName VARCHAR(100)
SET @FileName=
IF EXISTS (SELECT 1
FROM [dbo].[FileLoadStatus]
WHERE filename =@FileName)
BEGIN
SELECT 1 AS FileExistsFlg
END
ELSE
BEGIN
Select 0 AS FileExistsFlg
END
am using above code but getting below error
[Execute SQL Task] Error: Executing the query "DECLARE @FileName VARCHAR(100)
SET @FileName=Pipe_..." failed with the following error:
"The multi-part identifier "Pipe_Del_File.txt" could not be bound.".
Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Even i took file from foreach loop container and Execute sql task result set is kept single row
Fantastic video! awesome work! Thank you very much!
fabulous sir great work
hello Aamir Sir, If we use expression in Connection Manager (FullFilePath) property then we do not have to use Delay Validation property to True? Can you please throw some light on it? thank you kindly in advance!
Hi, Please check my reply below
techbrothersforum.com/pages/details/346/Should-I-set-Delay-Validation-On-Connection-Manager-if-using-Expressions-in-SSIS-Package
This is an amazing tutorial! Thanks sooo much
Loved it
it was a error from my end thank u
it trows me an error:
[Execute SQL Task] Error: An error occurred while assigning a value to variable "LoadStatusFlg": "The type of the value being assigned to variable "User::LoadStatusFlg" differs from the current variable type. Variables may not change type during execution. Variable types are strict, except for variables of type Object.
+Ivan Jankovic Check the data type of your variable.
+TechBrothersIT
I changed data type from int16 to int32 and it works now.
Thanks a lot!
Glad to hear that it worked for you!
Super man..its really good
Thanks Man😊❤
Perfect