Yep,

The Expression is set against the PackageName property:

@[User::strPackageName]

If I evaluate the expression I get the following text:

\Markets\Import_BMUunit_GCDC

I have tried coping and pasting the above string into the execute task explicitly...

Yep tried that too.

The error only comes about the moment the variable is used in the expression. If I call the same package directly (i.e. no expression) there are...

Hi. I've tried this but still having the same problem, any more ideas anyone? Thanks

-------------- SOLUTION -----------------------------------

After playing around with this I now have the solution for you.

In the parameter:

Go to default values

Select Specific Values

Enter the Value(not the label)

i.e.

id name

1 ...

A simple google will help

http://technet.microsoft.com/en-us/library/bb934049.aspx

Obviously I don't know exactly what your package is trying to do but....

If your package is reading from a source file such as a csv, spreadsheet, text file etc...

Then you...

Perfect thanks, just had to move the exec statment out of the loop and it worked perfectly.

Thanks all

Thanks that helps....

but

I still have the issue where I can not execute the dynamic string after building it. I still have to copy and paste the content to another...

Jez, which ever method you choose, you should still familiarise yourself with CTEs because they are v useful.

Jez,

For an explanation on how Common Table Expressions (CTE) work please read the following article...

http://www.4guysfromrolla.com/webtech/071906-1.shtml

lmu92, I agree you could do the same in one query but I find that it...

My bad, try this one...

;WITH cteSQL1 as

(

SELECT

ROW_NUMBER() OVER (ORDER BY AREA)AS RowNumber,

...

Hi,

Using a CTE you should be able to get the desired effect.

Please see example code below...

Let me know if you have any issues...

🙂

;WITH cteSQL1 as

(

SELECT

ROW_NUMBER() OVER (ORDER BY...

Not to be too pedantic but thats assuming they use a sourcesafe solution :hehe:

Hi,

SQL Server does have a native wizard for generating object scripts.

In the Object Explorer view in SSMS.

Follow the steps below:

1. Right click on the db which has the stored procedures...

Hi,

If you want some more help then I will need you to create a example tables for the procedure.

I can not replicate your problem because I obviously don't have your...