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

dianerstein 8713 (10/12/2016)

---

In a sql server 2012 database, the first insert statement works that is listed below works:

insert into [dbo].Cust (custid,[number],lockid)

values (134,118692,1098)

The following insert statement does not work...

DamianC (10/12/2016)

---

Using your suggestion sergiy, I've managed to get it working

One question

You have:

declare @MaxID bigint

select @MaxID + MAX(ID) From TargetTable (TABLOCKX)

This returns NULL

I've amended it to (changed + for =)

declare...

lindsayscott23 (10/12/2016)

---

Hi Grant,

Thanks for your help and advice here - really appreciated.

That's a great suggestion to use a backup to create the development environment; I wouldn't have thought of...

Chris makes a good point. It's unclear from your initial post what a single row in the fact table represents. A transaction? A product price snapshot?