Is that a two-way sync?

Only because that is what is assigned to it by SSIS. You can change this.

But I say again: flat file columns have no (explicit)...

Data in flat files does not have a data type.

Luis Cazares (11/16/2015)

---

Anything or nothing that...

David Tooker (11/16/2015)

---

Hi,

I need to use a Like statement with an Or statement in a where clause. below is what I am trying to do and the @ProjectType can...

OK, now I understand better. I get round that limitation (as suggested in previous posts) in a different way:

use SSISDB

go

exec catalog.set_environment_variable_value @folder_name = N'_environments', -- nvarchar(128)

@environment_name...

Mike01 (11/16/2015)

---

That's the procedure I am calling. I explicitly created a nvarchar variable and passed it into this proc. When this line runs, it returns Varchar instead of Nvarchar

SET...

Not sure whether this will work for you, but I do something similar.

I have a project deployed to SSISDB and have configured it so that certain params in the project's...

Not all columns. I am talking specifically about the single column in your...

dbman (11/16/2015)

---

Hello,

I have developed an SSIS package whereby a file is split into a number of tables. I have a conditional split, derived column and data conversion task.

The file is...

This bit

Needs to be elucidated.

I read it as

There can be only one row where...

(1) and (2) – create 2 unique indexes.

(3) needs a little more explanation. Are you saying that it's OK for

VhID ==PrID

and

PrID != ExtID

but only on a single...

Can you describe the logic please?

Work from the outside in, loading the tables with no dependencies first. The fact table comes last.

Why? Because the tables closer to the fact tables depend on the existence of...

Try

Select top 1 @Var = Col