I don't believe SSIS does dynamic imports. You could maybe use a script component to do so?

Are you after something like this?

SELECT DISTINCT ne.NewsID

FROM NewsEntities ne

LEFT JOIN (SELECT DISTINCT NewsID FROM NewsEntities WHERE EntityID = 2) tne ON tne.NewsID = ne.NewsID

WHERE ne.EntityID = 1

AND tne.NewsID IS...

Are the ldf and mdf files both in there?

Create a table to add the file names into it e.g.

CREATE TABLE EmailTask(Name VARCHAR(20))

INSERT INTO EmailTask(Name)

SELECT 'ABCD'

UNION

SELECT 'HERH'

...etc

Create a 'object' variable called 'objName' then a string variable called 'strName'.

Use 'Execute...

Does the folder 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\Documents' already exist?

I had a similar issue with a setup a while back, from what I recall the AdventureWorks2008 database is slightly different to the others (you may be able to find...

Far from elegant, but this may work

SELECT RTRIM(CASE WHEN CHARINDEX(',',Address) < CHARINDEX('*',Address)

THEN SUBSTRING(Address,0, CHARINDEX(',',Address))

WHEN CHARINDEX(',',Address) > CHARINDEX('*',Address)

THEN SUBSTRING(Address,0, CHARINDEX('*',Address))

ELSE Address

END)

Assuming the expression is typed correctly - is CEILING definitely available in 2000? (Sorry if a silly question, I don't have access to it anymore!) If it is, try prefixing...

MWise already answered this for you:

Then in...

Which property are you assigning this expression to?