Hi,

Firstly im not using "staging tables".

This is a on of bulk insert fro csv-->sql table.

No need for primary keys, foreign keys etc..

I have managed to fix the error above...

Anyone?

I need to add a password to this package tonight as "someone" keeps editing it!

:Whistling:

Thanks!!!!!!!!!

Works! 😀

Thanks I understand what you mean.

But I have 7 SSIS packages, how can I make them all use this Variable?

Ok I have set the system variable and package configuration.

Now how do I call this variable in my SendMail Task?

This page cannot be displayed!

is this the correct URL?

Page does not open...

Woohooo ok I think iv got it working.

Now just to test this, how can I use this Variable I have now created (which stores the SMTP Server details) in another...

Ok, Iv started again.

Now when I hit "Evaluate Expression" i get the correct result (i.e. the SMTP Server address).

I have done your revised steps but I still keep getting the...

Looking back at your first steps:

1. Create 1 OLEDB SQL Connection

2. Drag 1 Execute SQL Task to Control Flow

3. In Execute SQL Task General Properties, Set Resultset = "Single row",...

Nope still not working!!! Same errors!!!

I think the Expression is incorrect:

"SmtpServer="+@[User::SMTPConnection]

I have also included the error message

Ramesh,

This process we have used we have created the variable but have we declared/save them?

Its like the SendMail tak is trying to run before the SQLTask has managed to pick up the variable from the SQL Table.

Are we using the correct exspression

This is driving me mad...:crying:

Do I need to add anything into Parameter Mapping within SQL Task Editor?

Image attched