If I were to run this in my local SSMS, it would fail.

kmamenya (7/23/2015)

---

Hallo,

I am trying to calculate the number of hours a device has been used and I cant find how...Any help guys...I need a query that calculated and does...

You have been here long enough to know that you should post your data in a consumable format.

dwilliscp (7/23/2015)

---

How would I find out what happened to create the error below... It is hard to believe it was a time-out issue since the elapsed time is only about...

I'm with Alvin. In fact I'll be more blunt: the packages should be rewritten.

Many of the things DTS can do cannot be directly translated to SSIS. Hundreds of the...

Alvin Ramard (7/22/2015)

---

If you have many packages to migrate, then you might want to consider 3rd party tools for doing so. the only one I'm aware of is from a...

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