I got the following error when I started to create a simple SSIS package to load data from a csv file to an SQL Server table. This task is quite simple. But I was wondering why I was getting this error message?
Error Message:
"Cannot create connector. The destination component does not have any available inputs for use in creating path"
What does this error message really mean?
Finally I realised my silly mistake. Here I was using OLE DB Source, whereas I should be using OLE DB destination task.
But I think Microsoft can give a more meaningful error message...
0 comments:
Post a Comment