Have a look here for the general principle.

Your outputs would, of course, each contain different columns, depending on the...

Have a read here[/url].

I suspect that the package protection level has been set to EncryptAllWithUserKey. That is where I would start looking.

I'd be tempted to use an asynchronous Script Component Transformation with five (or however many tables you have) outputs.

--Edit: changed 'asymmetric' to 'asynchronous', oops 🙂

pete.olding (10/22/2015)

---

We've had the SQL server 2005 installed for a while. The only reason we are moving the DTS packages across is because we are decommissing the old SQL server....

It's right there in my first post on this thread.

pete.olding (10/22/2015)

---

Hi all,

Trying to set up new SSIS packages on a SQL 2005 machine to replace all my DTS packages on a previous SQL box. The packages are mostly transferring...

And why are you converting the dates to VARCHARs?

Looks to me like this would be simpler, faster and easier to maintain as one query, rather than a bunch of UNIONs. Are you open to a rewrite?

+ISNULL(x.code,'')+' '

Where x is the alias of the joined table.

I'm 99%...

Minnu (10/21/2015)

---

Table : Unify

id desc code

1 HSBOM 002

table 'JKS'

code | Desc

-------------

001 | LCC

002 |...

Minnu (10/21/2015)

---

I have a select query on table unify, here i want to display the "Desc" value from JKS table instead of "u.code" field

SELECT

u.id,

(...

reddychaitanyakrishna (10/21/2015)

---

Hi Guys,

Getting an error while connecting to SQL Server Management Studio (SSMS) i.e connecting via Database Engine.

Please check the first Screenshot for error. (1)

I tried to start SQL Server...

Dave Convery (10/13/2015)

---

Currently there are filters based on post numbers, with automatic approval for people over a certain number of posts. This is a bit more robust than just the...

What do you mean by this?

Is this a separate application that you are talking about?

John Mitchell-245523 (10/20/2015)

---

I'm wondering whether SSIS adds some stuff to the beginning of the batch - maybe SET statements or such like. MERGE requires the preceding statement to be...