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

cbrammer1219 (11/10/2014)

---

Hi I have a bit of a dilemma I am wanting to creating a column based on a value in a flatfile, and insert that value into the destination...

MMartin1 (11/6/2014)

---

There is also the 2208 SSIS book written by Knight and team. Professional Microsoft SQL Server 2008 Integration Services (Knight, Veerman, Dickinson, Hinson and Herbold) from Wrox. It is...

g.britton (11/6/2014)

---

The...

No problem, thanks for posting back.

Nasty.

I think I'd do it like this.

As your OLEDB source, have a query which gives you an ordered resultset

CompanyInfo1, CompanyInfo2, CustomerInfo1, CustomerInfo2 etc

order by Company, Customer

Of course, this is...

aarionsql (11/6/2014)

---

Thank you for your reply Phil ..

From your experience can you get Project Level parameters to be used in SSIS expressions along with other variables?

So you it be...