mapping a variable to a SQL parm in a Data Flow task
Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance
using SQL Server 2005
I have a package variable that I want to map to a parameter that I'm
using in the WHERE clause of a SQL statement.
I'm getting this error on the Data Flow task when executing the
package:
'Value has not been set for parameter 1.'
How can I map that parm to the variable in a Data Flow task? In the
'Execute SQL Task' it's obvious how this is done, but I can't figure it
out in the Data Flow task
.
Relevant Pages
- Re: mapping a variable to a SQL parm in a Data Flow task
... I have a package variable that I want to map to a parameter that I'm ... How can I map that parm to the variable in a Data Flow task? ... 'Execute SQL Task' it's obvious how this is done, ...
(microsoft.public.sqlserver.dts) - Error 0xc02020a1: Data Flow Task: Data conversion failed
... My text import with DTS in SQL 7 works fine. ... Error 0xc02020a1: Data Flow Task: Data conversion failed. ... (SQL Server Import and Export Wizard) ... The PrimeOutput method on component "Source - merged_txt" returned error code 0xC0202092. ...
(comp.databases.ms-sqlserver) - Re: Datasets vs. OOP
... If their intended purpose was to map back to SQL ... If they are clearly intended to map back to SQL Databases and aren't equally ... intended to map to other data sources, then why can you use an Excel Sheet ...
(microsoft.public.dotnet.framework.adonet) - Re: Datasets vs. OOP
... If their intended purpose was to map back to SQL ... If they are clearly intended to map back to SQL Databases and aren't equally ... intended to map to other data sources, then why can you use an Excel Sheet ...
(microsoft.public.dotnet.general) - Re: Passing XML data type to a SQL Server 2005 procedure (BizTalk 2006)
... I've got a sample of sending XML as a text parameter to a SQL database. ... The key is to use the map to initially construct ...
(microsoft.public.biztalk.general) |
|
