Are you writing a thesis, or is there some practical reason for your questions?

Phil Parkin (11/13/2014)

---

Of course. Just remove the...

Of course. Just remove the CTE and...

Another slightly simpler version (thanks pietlinden for the data subquery):

with data

as (select 'P1' as Product_Name

...

Yep, this includes me. I...

OK, so is this solved now?

If not, please provide three or four sample file names, so that we can help with the Derived Column expression.

When you are retrieving the file name in the Foreach loop, consider selecting the 'Name only' option to avoid having to dissect the entire path string with your derived column...

Just a quick check. Can you confirm the data type (in SQL Server) of the new date column please?

Koen Verbeeck (11/12/2014)

---

Phil Parkin (11/12/2014)

---

arunnrj87 (11/12/2014)

---

I have added by going to DataFlow Task -->Flatfile Source -- >Right Click Show Advanced Editor-->

Component Properties -- > Under Custom Properties-->In FileNameColumnName--> i have...

arunnrj87 (11/12/2014)

---

I have added by going to DataFlow Task -->Flatfile Source -- >Right Click Show Advanced Editor-->

Component Properties -- > Under Custom Properties-->In FileNameColumnName--> i have five the Column Name...

Koen Verbeeck (11/12/2014)

---

There is an advanced property in the flat file source where you can add a column that contains the filename of the flat file you are loading.

FileNameColumnName property,...

arunnrj87 (11/12/2014)

---

Hi Friends,

Actually i have Flatfile as a TXT files .In that i have 100 Columns and i need to import those datas in to SQL Server 2012 by using...

Try removing the group by completely:

select count(distinct msdb.dbo.backupset.database_name)

from msdb.dbo.backupset

where datediff(day, backup_finish_date, getdate()) > 1 -- or is null

...

klineandking (11/10/2014)

---

i have 2 tables with this schema

CREATE TABLE tableValues(

[LASTENCRYPTIONDT] [datetime] NULL,

[ENCRYPTIONID] [int] NULL,

[NAME] [varchar](50) NULL

)

CREATE TABLE TableToupdate(

[LASTENCRYPTIONDT] [datetime] NULL,

[ENCRYPTIONID] [int] NULL,

[NAME] [varchar](50) NULL

)

tablevalues has...

Does table A have an IDENTITY(1,1) as a PK, by any chance?

If yes, you might be able to do something like this:

1) Set SSIS variable to SELECT Max(ID) from tableB.

2)...