Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

OLE DB Source Error Msg: The SQL command requires 1 parameters, but the parameter mapping only has 0 parameters.

1,161 views
Skip to first unread message

CTB

unread,
Apr 7, 2011, 3:09:27 PM4/7/11
to
Hello all,

I'm getting the following error message on my OLE DB Source in my data flow task when trying to debug my package in BIDS/VS2005:

"The SQL command requires 1 parameters, but the parameter mapping only has 0 parameters."

Originally, my OLE DB Source's Data access mode was set to SQL command from variable (SQL statement was being built in a script task using other package variables). This was working YESTERDAY...and nothing should have changed.

Today, (after having that error blow up my package...Bomb Squad style!!! :-D ) I switched Data Access mode to SQL command...and hard coded my SQL statement in the Source's Editor dialog box...and I'm still getting the same error message.

Anyone know what could be going on here? Please let me know if you need me to supply more info.

Thanks for any help anyone can provide,

CTB

Bob Barrows

unread,
Apr 7, 2011, 3:25:10 PM4/7/11
to

I would try creating a new data source task from scratch, hard-coding the
sql statement (which I have previously tested in my database).


0 new messages