VS 2008 - Works one day but not the next

Posted on 2014-08-11
Last Modified: 2016-02-11
Hi Experts,

One day I was able to execute this SSIS package and everything was working great.

Same SSIS package and I get this error:
Error: 0xC002F210 at Clean up History and Inbound Tables, Execute SQL Task: Executing the query "EXEC Purge_By_FileId ?,?,?,?
" failed with the following error: "Operand type clash: int is incompatible with date". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Task failed: Clean up History and Inbound Tables

I have not done any changes to the SSIS package
There has been a computer name change

There are 4 parameters:
VS2008 - SSIS 2008:
  Fileids, Input, Long, 0, -1
Tblnms, Input, Varchar, 1, -1
StartTime, Input, DATE, 2, -1
ReRunFlag, Input, Long, 3, -1

SQL Server 2008 - Stored Procedure
 @FileId int, -- File_Id from Database_Tables CLAIM
      @TBLNM varchar(40), -- Table Name from Database_Tables
      @yearmonth varchar(10),
      @rerunFlag bit

The parmaters are in order on both the SSIS and SP

Please help and thanks.
Question by:Amour22015
    LVL 65

    Expert Comment

    by:Jim Horn
    >"Operand type clash: int is incompatible with date"
    Guessing the SSIS package 'Clean up History and Inbound Tables' has a Derived Column task which converts an int column to a date, and the value in that int column is not convertable to date format.

    Check whatever the source of data is.

    Author Comment

    But this is what is funny the same SSIS package was working great and then my computer name got changed.  Now it is giving this error.

    As you can see the parameters line up:

    Like the first parameter is:
    Fileids Long => FileId int

    The date field is not until the 3rd postion?

    Maybe I just don't understand.

    Please help and thanks

    Author Comment

    Check whatever the source of data is

    That source is:

    LVL 65

    Expert Comment

    by:Jim Horn
    If it's a variable..
    Open the package in VIsual Studio
    Find that task, right-click:Edit Breakpoints, set a breakpoint on OnPreExecute
    Execute the package, observe that it stops on the breakpoint
    Click on Debug menu item > Windows... > Locals
    Then in the Locals window expand to see all the variables, and let us know what it says.

    If there's a data flow involved...
    Right before the task, on one of the arrors double-click to open Properties > Data Viewer > check the Enable Viewer checkbox, then add all columns.
    Execute the package, observe that it stops and opens the data viewer.
    Eyeball the column that should have date values and see if one does not.

    Author Comment

    I expanded the Variable(s) section.  There is a long list:

    Author Comment

    +		System::ContainerStartTime	{8/11/2014 2:10:58 PM}	DateTime
    +		System::CreationName	{Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=, Culture=neutral, PublicKeyToken=89845dcd8080cc91}	String
    +		System::LocaleID	{1033}	Int32
    +		System::ParentContainerGUID	{{c384e13a-cdd5-446b-ac76-a67edb61bbaa}}	String
    +		System::TaskID	{{b87ac863-c3c2-4bf8-bb74-fd55b50e1d9d}}	String
    +		System::TaskName	{Clean up History and Inbound Tables}	String
    +		System::TaskTransactionOption	{1}	Int32
    +		System::ContainerStartTime	{8/11/2014 2:10:58 PM}	DateTime
    +		System::LocaleID	{1033}	Int32
    +		System::ParentContainerGUID	{{5D2AA84F-40A8-43A4-82EF-13A93423D93D}}	String
    +		User::ReRunFlag	{0}	Byte
    +		User::TempTable	{0}	String
    +		User::TempTableFAC	{0}	String
    +		User::TempTableITM	{0}	String
    +		System::CancelEvent	{952}	Int32
    +		System::ContainerStartTime	{8/11/2014 2:10:56 PM}	DateTime
    +		System::CreationDate	{4/17/2014 3:39:36 PM}	DateTime
    +		System::CreatorComputerName	{FRB01X77618L1}	String
    +		System::CreatorName	{WW-CORP\\mstamour}	String
    +		System::ExecutionInstanceGUID	{{90BE3999-FEC6-4D6B-A979-421296581592}}	String
    +		System::FailedConfigurations	{}	String
    +		User::FILEIDS	{543184}	Int32
    +		System::InteractiveMode	{True}	Boolean
    +		System::LastModifiedProductVersion	{10.50.1600.1}	String
    +		System::LocaleID	{1033}	Int32
    +		System::MachineName	{FRB01S75454L1}	String
    +		System::OfflineMode	{False}	Boolean
    +		System::PackageID	{{5D2AA84F-40A8-43A4-82EF-13A93423D93D}}	String
    +		System::PackageName	{PurgeClaim}	String
    +		System::ParentContainerGUID	{}	String
    +		System::ProductVersion	{10.50.1600.1}	String
    +		User::RC	{1}	Int32
    +		System::StartTime	{8/11/2014 2:10:56 PM}	DateTime
    +		User::Table	{}	String
    +		User::TabVal	{System.__ComObject}	__ComObject
    +		User::TBLCNT	{0}	Int32
    +		User::TBLNMFC	{b}	String
    +		User::TBLNMIT	{b}	String
    +		User::TBLNMS	{CLAIM_2010_08}	String
    +		System::UserName	{WW-CORP\\mstamour}	String
    +		System::VersionBuild	{266}	Int32
    +		System::VersionComments	{}	String
    +		System::VersionGUID	{{D4ED46EF-7493-4FEE-A278-F18BB0FA81AF}}	String
    +		System::VersionMajor	{1}	Int32
    +		System::VersionMinor	{0}	Int32
    		ExecutionDuration	0	
    		ExecuteStatus	Executing	
    		ExecutionResult	Success	

    Open in new window

    Sorry here is the list..

    Author Comment

    Also I noticed that when opening the .sln I get this message:
    The Microsoft.Data.Entity.Design.Package.MicrosoftDataEntityDesignBootstrapPackage, Microsoft.Data.Entity.Design.Package, Version=, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a ({7A4E8D96-5D5B-4415-9FAB-D6DCC56F47FB}) did not load because of previous errors. For assistance, contact the package vendor. To attempt to load this package again, type 'devenv /resetskippkgs' at the command prompt.

    I have done a:
    dir devenv.*
    to see if it exists but nothing was there?

    Please help and thanks

    Author Comment


    when I type in the whole:
    'devenv /resetskippkgs'

    it brings up the VS2008 and when I try to load the .sln file it errors:
    See attachment.

    Author Comment


    I went to another computer that has VS2008 on it and there were no load errors

    So I am back to the orgininal post

    For some reason the parameters are still not lining up.

    Please help and thanks

    Author Comment

    I guess there is no one able to help on experts anymore?

    Accepted Solution

    Looks like I found the problem:

    Had nothing to do with the parameters

    Within the Stored Procedure "Purge_By_FileId"  There was an insert that did not match the select.

    Once the match then the SSIS Package executed success.


    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Suggested Solutions

    In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    My client sends a request to me that they want me to load data, which will be returned by Web Service APIs, and do some transformation before importing to database. In this article, I will provide an approach to load data with Web Service Task and X…
    Viewers will learn how the fundamental information of how to create a table.
    Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

    733 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now