Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-02-28 : 07:45:46
|
| Senthil.S writes "Hai I have created an DTS package for exporting an result set of a SP in to Excel sheet, In this I have given my "Exec query with ?,? mark" in the SQl query window at the source, and i configured parameters using Global variables to tht SP after giving this when i go and click the Preview button in the source screen it shows the following error.Package Error Error Source : Microsoft provider for sql server Error description : No value given for one or more required parameters My SP need 5 parameters I have given all the 5 but still it shows the error. But works well with SP without parameters. Plz anyone help me is any aditional parameter is needed specifically for DTS Give No result set if i harcoded the execute qry with parameters in the source screen qry. Any word will help me." |
|
|
|
|
|
Package error in DTS Transform data Task