I just check it agian but I still get the ERRORS;

SSIS package "C:\Visual Studio Projecten\Integration Services Project1\Integration Services Project1\Incident categorie Question.dtsx" starting.

Information: 0x4004300A at Data Flow Task, SSIS.Pipeline: Validation phase...

Do I forget something to tell ??

Tnx alot 🙂 I just see that my column incident_ref was in my database int but it must be varchar TNXXX ALOT 🙂 for the quick anwser 🙂

NO answers??!!

By selecting a customer I get a follwoing error (ofcourse I get this when I matching a Nvarchar with a INT value)

I just make a dataset 2 with the following Syntax;

select sectn_dept.dept_sc

from incident

join sectn_dept

on incident.sectn_dept_id = sectn_dept.sectn_dept_id

join sectn

on sectn_dept.sectn_id = sectn.sectn_id

join branch

on sectn.branch_id = branch.branch_id

where branch.stat_flag = 'n' and dept_sc LIKE...

rpt2ssrs (8/22/2013)

---

Formulas like this can be fully automatically converted.

Take a look at Crystal Migration Services.

http://www.crystalmigration.com[/quote%5D

Why must I pay for a service if I can do it on my...

Found that I did not select...

HanShi (8/15/2013)

---

CREATE VIEW v_WhatsUp_Assyst

AS

SELECT nDeviceID COLLATE Latin1_General_CI_AS

, nDefaultNetworkInterfaceID COLLATE Latin1_General_CI_AS

, item_id COLLATE Latin1_General_CI_AS

, item_keya COLLATE Latin1_General_CI_AS

, nDeviceGroupID COLLATE Latin1_General_CI_AS

, sGroupName COLLATE Latin1_General_CI_AS

, nDefaultNetworkInterfaceID COLLATE Latin1_General_CI_AS

, sNetworkName COLLATE Latin1_General_CI_AS

FROM WhatsUp_Assyst_replicatie.dbo.device

, WhatsUp_Assyst_replicatie.dbo.item

,...

John Mitchell-245523 (8/15/2013)

---

You have collation differences between your four databases. You need to put a [font="Courier New"]COLLATE collation_name[/font] clause after every column specification that does not have the collation...

HanShi (8/15/2013)

---

First, take a step back and clearly think about your requirements and purpose.

- Like Jeff mentioned: do you really need a duplicate of all the data in the four...

Eric M Russell (8/14/2013)

---

Rather than inserting into one table, another option would be to create a virtual table using a partitioned view.

create view v_WhatsUp_Assyst

as

SELECT nDeviceID, nDefaultNetworkInterfaceID FROM WhatsUp_Assyst_replicatie.dbo.device

union all

SELECT nDeviceID,...

The problem what i have is that i can use these qeurys but it overlapping when i make this qeury a job to update my table everytime..

Like when i do...

Louis Hillebrand (8/14/2013)

---

For the formatting you can try this,

Use the case to get the correct character in front (or an empty string), and then add the incident_ref in 5...