[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

VS 2008 - Works one day but not the next

Posted on 2014-08-11
11
Medium Priority
?
338 Views
Last Modified: 2016-02-11
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.
0
Comment
Question by:Amour22015
  • 9
  • 2
11 Comments
 
LVL 66

Expert Comment

by:Jim Horn
ID: 40253829
>"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
 

Author Comment

by:Amour22015
ID: 40253850
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
 

Author Comment

by:Amour22015
ID: 40253855
Check whatever the source of data is

That source is:
System::StartTime

Thanks
0
Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

 
LVL 66

Expert Comment

by:Jim Horn
ID: 40253883
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
 

Author Comment

by:Amour22015
ID: 40253956
I expanded the Variable(s) section.  There is a long list:
0
 

Author Comment

by:Amour22015
ID: 40253960
+		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
 

Author Comment

by:Amour22015
ID: 40255375
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
 

Author Comment

by:Amour22015
ID: 40255392
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
 

Author Comment

by:Amour22015
ID: 40255789
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
 

Author Comment

by:Amour22015
ID: 40255949
I guess there is no one able to help on experts anymore?
0
 

Accepted Solution

by:
Amour22015 earned 0 total points
ID: 40256559
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

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses

873 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