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

yogi123 (10/12/2016)

---

Hello

I have one task, where i need to generate csv files which has max 500 records in it. so let's one file has 1250 records, then i need to...

dianerstein 8713 (10/12/2016)

---

I am trying to load the valid lockID values into the cust table with the following sql:

DECLARE @Startlockid INT=0

DECLARE @MyTableVar table( lockID int);

insert...