Actually, this bit is not quite correct. SSDT and SSDT-BI were...

After attaching the databases, you should consider upping their compatibility levels, to take advantage of all the new features. After testing, of course.

acortina68 (10/15/2016)

---

Hi, I've been searching and working on this topic for a while, and there are not tools to cover all scenarios. While there are "standard" rules that should be...

mcfarlandparkway (10/14/2016)

---

Is there any example or link should I refer to?

I am confused here ..If you have any proper links where I can see and implement please forward it to...

wiam.elab (10/14/2016)

---

Hello everybody,

I have a little story to tell about SSIS,

As I have to retrieve a parameter from the result of a Tsql Stored Procedure,

It'll be passed to a variable...

Lynn Pettis (10/13/2016)

---

Sean Lange (10/13/2016)

---

Lynn Pettis (10/13/2016)

---

I am really getting tired of Mr. Celko. And obviously he is losing it as he can't seem to type English sentences without...

haichells (10/14/2016)

---

In "Show Advanced Editor" of a OLE DB Source i see Input/Output Columns tab where each column's data type was listing as per the database type and length. And...

tim.ffitch 25252 (10/14/2016)

---

Hi Phil.

Not sure how the final solution will pan out at the moment as everything is moving over to AWS, so lets say development will be done on...

Data in flat files has no data type, so this requirement is not possible. Perhaps you can clarify.

So you want to set up a single SSIS server containing multiple version of packages, is that correct?

Or merely have the same packages using different variable values, depending on target...

Jack Corbett (10/12/2016)

---

Do you mean when you deploy to a new server or when you re-deploy to the same server because you made changes?

I have never seen this...

If this is not your network, it's probably not your decision. Talk to the vendor and ask them what they can provide.

sqlguy-736318 (10/12/2016)

---

I'm calling a sproc via ADO.NET in a C# console app. However, it appears that old sproc columns are being returned. I had another developer double-check that the connection...

Barkingdog (10/12/2016)

---

We have 2 tables with the same schema on different servers. Let's call them TblSrc and TblDest. We need to "synchronize" the data in both tables based on...

Please tell us...