VS 2008 - Works one day but not the next

Hi Experts,

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

Now:
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:
From:
VS2008 - SSIS 2008:
  Fileids, Input, Long, 0, -1
Tblnms, Input, Varchar, 1, -1
StartTime, Input, DATE, 2, -1
ReRunFlag, Input, Long, 3, -1

To:
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.
Amour22015Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
>"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.
0
Amour22015Author Commented:
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
0
Amour22015Author Commented:
Check whatever the source of data is

That source is:
System::StartTime

Thanks
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
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.
0
Amour22015Author Commented:
I expanded the Variable(s) section.  There is a long list:
0
Amour22015Author Commented:
+		System::ContainerStartTime	{8/11/2014 2:10:58 PM}	DateTime
+		System::CreationName	{Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=10.0.0.0, 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
+		User::Database	{OPID_POSTPAY_WELLPOINT_CENTRAL_EDWARD}	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..
0
Amour22015Author Commented:
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=9.0.0.0, 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
0
Amour22015Author Commented:
But:

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.
PackageLoadFailure.docx
0
Amour22015Author Commented:
Ok,

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
0
Amour22015Author Commented:
I guess there is no one able to help on experts anymore?
0
Amour22015Author Commented:
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.

Thanks
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.