Yup.

Lempster (3/21/2014)

---

PragmaticWorks have a SCD component that is a big improvement on the out-of-the-box SCD transformation...but of course you'll have to pay for it!

You could also use a T-SQL MERGE...

I think ? is a placeholder for a non-printable character, so you won't find it when you search for it.

Maybe you should inspect the data using a hex editor, to...

Why are you not using the cache in the lookup component?

Does the user executing the job have the required permissions?

anilraj0309 (3/21/2014)

---

Hi Koen,

Protection level is : EncryptSensitiveWithUserKey

will this make any difference?...

SCD Wizard has terrible performance for the updates as it uses the OLE DB command.

You can run the wizard and replace the OLE DB command with an OLE DB Destination,...

Duplicate post. Original thread with replies can be found here:

http://www.sqlservercentral.com/Forums/Topic1553367-148-1.aspx

What is the protection level of the package?

Generally you would store connection information indeed in a configuration table.

yuvipoy (3/21/2014)

---

Koen Verbeeck (3/21/2014)

---

If the maximum value is lower than the maximum int value, then choose int.

You don't need to know how SQL Server works internally just to create a...

If the maximum value is lower than the maximum int value, then choose int.

You don't need to know how SQL Server works internally just to create a table.

If you are...

What is the source for your report? A database or a cube?

Which character are we talking about?

Can you show us the query you wrote with the LIKE operator?

Sushant Yadav (3/20/2014)

---

Hi All,

I am Getting following error when I execute SSIS package through SQL agent job.

Executing the query "DECLARE @errorcode INT DECLARE @ErrorDesc Varchar(..." failed with the...

What is the range of values you are going to store?

This is the only thing you need to look for. Performance differences, if there are any, will most likely be...