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?

Is this a run-time error or a validation error?

When you recreated the package in 2008, did you do it from scratch, or did you try to reuse/copy/whatever bits of your...

I know what an IDENTITY column is, of course.

It seems that you are doing ETL from a source...

...Or you could just remove the IDENTITY definition from the target table 🙂

PurpleLady (6/5/2014)

---

Yes - Integration Services, Data Tools, complete Management Tools, and the Client Tools SDK also. I have at least a dozen other packages that are running on the server....

Is Integration Services installed on the server?

I can get that exact error by doing something like this:

declare @sTime varchar(5) = ' 2359'

select convert(smalldatetime, stuff(@sTime, 3, 0, ':'))

So I'm wondering whether there might be some dodgy...

.. you could also consider using a File System Task for doing the copy.

What do the cmd files do?

Please post the text of the error message.

Put everything that depends on the file's presence in the FEL container - so that appears to be all tasks.

Your file-existence-check script is rendered superfluous.