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

Use the RIGHT() function.

Right('0' + col,2)

If you take the time to post the data in consumable form (see the link in my signature), I will show you how.

A correlated subquery is not required in this...

Nice one Scott. Must remember that trick.

Hopefully your framework allows you to set the max concurrent number of executing packages per job.

I'd suggest playing with that number a bit. Start on the low side and gradually...

That very process was recently described in this thread.

Also, literal dates are best written in 'YYYYMMDD' format, eg, '20791201', to avoid any possible DMY, MDY confusion.