Saturday, March 13, 2010

SSIS - Error Message

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