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,

...

Numeric data imported from Excel does not have leading...

Are you able to provide sample DDL, data with DML and desired results, as described in the link in my signature? It would make things clearer.