Thanks for conforming. It sounds like a pretty routine data migration project but some of the concerns mentioned earlier are going to be a challenge, specifically with the user-provided content...

IF @@SERVERNAME = 'ORLANDO-SURFACE\SQL2012'

BEGIN

INSERT INTO Table1

VALUES ('some_value', 'some_value', 'some_value', 'some_value');

END;

ELSE

BEGIN

EXEC sys.sp_executesql

...

Jeff Moden (1/13/2016)

---

Orlando Colamatteo (1/12/2016)

---

Where it will have trouble is if the header and detail lines need to have different lengths which is why I asked the OP for the...

Attached is a zip file containing three files:

1. TestData.sql is a script that will build two tables and some test data in tempdb

2. SSIS Package (InterleaveHeaderAndFooter.dtsx file) that will interleave...

Where it will have trouble is if the header and detail lines need to have different lengths which is why I asked the OP for the file-descriptor info.

That does not compute...when an Execute Process Task cannot find the executable at all you should see an error like:

Error: 0xC0029154 at Execute Process Task, Execute Process Task: File/Process "C:\MyFolder\Some.exe"...

Anyway, here is a resultset with the data in a fixed-width format and you can tweak it from here. If the header and detail lines need to have different total...

MMartin1 (1/12/2016)

---

Orlando Colamatteo (1/12/2016)

---

MMartin1 (1/12/2016)

---

Orlando Colamatteo (1/12/2016)

---

titsiros (1/12/2016)

---

The reason for the merge is because one client acquired the other and they don't want to maintain separate systems.

I know it's...

MMartin1 (1/12/2016)

---

Orlando Colamatteo (1/12/2016)

---

titsiros (1/12/2016)

---

The reason for the merge is because one client acquired the other and they don't want to maintain separate systems.

I know it's a grand task...

titsiros (1/12/2016)

---

The reason for the merge is because one client acquired the other and they don't want to maintain separate systems.

I know it's a grand task because the db...

Did they provide any guidance on the file-format itself (column order and width) or can we safely derive that from the table defs?

Greg Edwards-268690 (1/12/2016)

---

michael.welcome (1/11/2016)

---

If you want and even more difficult task, try explaining to management types why this is not simple and easy thing to do.

Adding a fixed amount to...

lmarkum (1/12/2016)

---

1. Add Logins for BI team to primary instance

2. Add Users to relevant databases for BI Team Logins and grant permissions to new Users

3. Drop Logins from primary instance...

I think you are looking for the RetainSameConnection property on the Connection Manager. If you set that to True all connections to that data source in the course of your...

Note post was several months old ...

I would recommend contacting the vendor if you can't get it sorted. y fiahing through theor documentation or doing trial and error testing with...