maddukuru.rambabu (7/22/2015)

---

Hi,

below link is my suggestion. But here data migration only happened.

http://www.sqlservercentral.com/Forums/Topic1704137-364-1.aspx

But I am also looking for If records are new it should be inserted or if...

You are, of course, welcome to your opinion.

But if...

You're going to have to learn how to add attachments so that you can add the query plans (good and bad).

When you are creating a post, look at the bottom...

http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/75331/%5B/url%5D

happy55 (7/21/2015)

---

Thanks for the reply. Your example is talking about project deployment model.

If I am using package deployment model, then I would need my connection string to be dynamic...

happy55 (7/21/2015)

---

I have to create a script task in SSIS 2012 .Which connection manager ADO.NET or OLE DB

shall I use?

I goggled and found ADO.NET is preferred for scripts .Then I...

You cannot pass T-SQL to be executed like this.

You will have to either resort to using something like sp_executesql, or change your proc around a bit to avoid this somewhat...

Splendid.

maddukuru.rambabu (7/20/2015)

---

Hi Folks,

I am using transfer SQL Server object task. By using this task we can perform below tasks.

1) copying the schema

2) copying the data

3) truncate data from...

Chelski_blue (7/17/2015)

---

So opened the package and changed the setting (having finally found it) to use EncryptSensitiveWithPassword. The package executes ok now through the Execute Package Utility, but pending confirm...

nidhi.naina (7/17/2015)

---

Thanks.

So you think there can be some other options? As i have quite a few checks in where clauses for different tables and columns.

Or should i go with...

Give me some examples please.

Simplified version.

select *

from

where try_parse(Capacity as int) < 0;

nidhi.naina (7/17/2015)

---

Gosh... I am sorry i am not ignoring... i trying to find some simpler way if any else i have your suggestion in store. Looking for something easier as...

Srikanth vathsala (7/17/2015)

---

Hi Nidhi,

Try this,

Declare @k char(10)

Declare @l as Char(10)

Set @k ='-88'

set @L = '88'

Select IIF( ISNUMERIC(@k) = 1,

Case

When Cast(@k as integer) > 0 then 'Positive'

When Cast(@k as integer)...