You can capture the current iteration's file path in a user variable.

Have a look at the Variable Mappings section here[/url] and let us know if you need more info.

antonio.estima 4150 (6/25/2014)

---

Hello Guys,

I have an activity that was created using SSIS 2008 R2, which consists of copying a file from a server within the network to a server...

imani_technology (6/24/2014)

---

Quick Update:

I decided that using a simple backup/restore might not be the best idea for staging. Why? Because:

1) We are backing up from one server on one...

You have some bizarre looking char dates there.

Are you looking to do INSERTS, or INSERTS and UPDATES or INSERTs, UPDATEs and DELETEs for your incremental load?

Do you have such columns...

Stuart Davies (6/18/2014)

---

I am a single point of failure and have been all the time in my current job (5 years) and support in house applications. Apparently we "don't have...

If you script the stored proc as CREATE from SSMS, you will see something like this at the start:

set ansi_nulls on

go

set quoted_identifier on

go

If you make sure that your set options...

Then the backup/restore idea will be fine.

Beatrix Kiddo (6/17/2014)

---

My Senior DBA likes to be the only one that knows some stuff so (in my opinion) he actively excludes me from situations where I might be able...

Via a SQL...

Yes it will. One project = one ispac...

Please note: the column is 'derived', not 'dervied' 🙂

Anamika (6/15/2014)

---

Hi,

In my ETL feed i need to identify whether the data is missing for continuous 5 hours. What could be the efficient way of doing this in SSIS....

May I thank you all for the comments and insight, especially Jeff for the detailed and interesting response.

I shall continue omitting the superfluous BEGIN/END, though I won't complain too much...

ChrisM@Work (6/11/2014)

---

CREATE TABLE #temp (colint INT, colvarchar VARCHAR(10), colcomputed AS CAST(colvarchar AS INT))

INSERT INTO #temp (colint, colvarchar) SELECT 1, '10'

SELECT * FROM #temp

CREATE INDEX ix_colcomputed ON #temp (colcomputed)

SELECT colcomputed FROM...

Add a computed persisted int column, add index and join on that?