The wrapper was unable to set the variable value

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.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

The wrapper was unable to set the variable value

Author

Topic

LOOKUP_BI
Constraint Violating Yak Guru

295 Posts

Posted - 2010-07-15 : 11:27:10

Oledb Source > SQL Command >
Select * from TableA where Date= ?
** Date datatype is DateTime in TableA

Going Into
Oledb Destination > sql Table B

SSIS Variable
Name : Date
Data Type : DateTime
Value : 3/3/2010

Forced Execution Value : Default
Forced ExecutionValuType: DateTime
Forced ExecutionValue : True

I have no problem executing this package, Table B get loaded with rows accordingly based on the value supplied to the Date parameter.

The only problem is, I get the following error mssg
Information: 0x4004300B at Data Flow Task, DTS.Pipeline: "component "OLE DB Destination" (198)" wrote 11 rows.
Error: 0xC001F009 at Package: The type of the value being assigned to variable "User::Date" differs from the current variable type. Variables may not change type during execution. Variable types are strict, except for variables of type Object.Task failed: Data Flow Task
Error: 0xC0019001 at Data Flow Task: The wrapper was unable to set the value of the variable specified in the ExecutionValueVariable property.Warning: 0x80019002 at Package: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (4) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
SSIS package "Package.dtsx" finished: Failure.
The program '[11460] Package.dtsx: DTS' has exited with code 0 (0x0).

lbuser
Starting Member

1 Post

Posted - 2011-08-12 : 16:39:57

I am having this same problem with a STRING variable. I can find this same question in forums all over the internet but none of them have any answers. Does anyone know how to fix this?

What I need to do - in SSIS - is read a row from an excel spreadsheet, check to see if one of the fields is the same as the one from the previous row, if it is not, then write the row to a OLEDB Destination. The caveat, of course, is that I need to retain the previous string to compare to the current string. The entire process completes correctly, 14 records are correctly selected from 196 total records, but it hits the wall on the above problem and won't write the record to the destination.

Can anyone out there help?

LBuser

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources