uzn2010 (4/13/2016)

---

I observed this second error in Execution task

[Connection manager "Excel Connection Manager"] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.

An OLE DB...

richardmgreen1 (4/13/2016)

---

The files contain different data (and headers) and are loaded via a BCP routine.

The targets are also dealt with in a similar fashion (the target SQL table is starts...

OK, thanks.

Now, regarding this part of the error message:

There may be error messages posted before this...

uzn2010 (4/13/2016)

---

I'm seeing this error when I'm trying to use Sql Command in the Data Access mode. I'm trying to skip 9 rows. In this try i tried to skip...

That's a good start.

Do the source files and target tables have the same formats?...

richardmgreen1 (4/13/2016)

---

Hi all

I've got an SSIS package that loads 140+ files sequentially.

I want to make it process the files in parallel (for example, 4 at a time) by checking the...

Nikku (4/13/2016)

---

Hi All,

I have one predefined excel sheet where multiple columns are present in scattered form.

I want to load data for respective column in respective excel cell dynamically. Those headers...

Not that I know of.

Manic Star (4/13/2016)

---

The easiest way to do this would be to point a For-each container at the directory containing the files, set the mask to either be everything, or filter...

Has the format of the Excel file changed at all? Sheet name different? Column names different? New columns added?

PATINDEX and CHARINDEX both work just fine in T-SQL...

If you're not satisfied with this slightly inelegant solution, you could try putting all of your file-creation stuff...

RV16 (4/12/2016)

---

Hello,

I have begin_date as datetime datatype in sql server.

I am trying to create report.

In that, I just want to show only date as begin_dte. So I used...

dallas13 (4/12/2016)

---

Thanks everyone. I am only using T-SQL here and when I try this code inside my SSIS it still gives me error saying Error parsing the code.The single quotation...

Something like this may help:

DECLARE @Filename_to_be_deleted VARCHAR(100);

DECLARE @FileDate DATE;

SET @Filename_to_be_deleted = 'abc_vg-20161204.txt';

SET @FileDate = SUBSTRING(@Filename_to_be_deleted,

...