You are wrong...

Hawkeye112 (10/23/2015)

---

Hi,

I have a really simple Data Flow Task with a Lookup Task in it. If I run the Task with Full Cache (inmemmory) all my records will be directed...

I am definitely in the 'IsActive', 'IsCurrent' camp.

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...