March 25, 2015 at 5:05 am
Hi Guys
I am having some trouble here. I have a package that should pick up a .csv package daily, however when I check the log from the SQL Job Activity Monitor I get the message:
The connection manager "IncomingFile" is an incorrect type. The required type is "OLEDB". The type available to the component is "FLATFILE".
Someone suggested that I should use a ADO.NET destination instead of a OLEDB destination. This solved the exact same issue on the output to a .csv, but the issue remains on the input. The package runs successfully, but doesn't do anything at all.
Also running this manually from BIDS the package runs without incident and does the import.
Any assistance in this regards will be greatly appreciated
Regards
March 25, 2015 at 5:42 am
Which component did you use in the data flow as a source?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 25, 2015 at 5:58 am
Hi Koen
I used a Flat File source component.
Thank you for your reply
March 25, 2015 at 6:00 am
coetzeehuman (3/25/2015)
Hi KoenI used a Flat File source component.
Thank you for your reply
And I guess you used a flat file connection manager?
Strange.
What happens if you rebuild the data flow from scratch? (and redeploy the package to the server)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 25, 2015 at 6:20 am
Hi Koen
I found the underlying problem.
I have a loop checking a remote server, and picking up the files from there, this is where the problem lies. The executing user doesn't have permission on the folder, so when the loop checks there is essentially no file, and it finishes up, but the flat file components sit within the loop, so the "file" it is looking at doesn't fit with the component.
Thank you for your assistance, and my apologies for the misdirection.
March 25, 2015 at 6:28 am
coetzeehuman (3/25/2015)
Hi KoenI found the underlying problem.
I have a loop checking a remote server, and picking up the files from there, this is where the problem lies. The executing user doesn't have permission on the folder, so when the loop checks there is essentially no file, and it finishes up, but the flat file components sit within the loop, so the "file" it is looking at doesn't fit with the component.
Thank you for your assistance, and my apologies for the misdirection.
OK, glad you solved the issue and thanks for posting back.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply