If you want to store values in a variable with an Execute SQL Task, do the following:

* create a SSIS variable

* write your query in a Execute SQL Task. Make...

It would be helpful if you posted the expression(s) that you use in the derived column.

For some reason, a row has some invalid data that makes the derived column fail.

There are a number of ways to deploy a package from a file system to a server:

* if you have BIDSHelper installed, right click on the package and click deploy....

At first sight: the warning and the error are not related.

The error message says that your package crashes because the user or password are invalid. As you can preview results...

I guess that when you read your data from the SQL Server table, that you have some sort of primary key.

Use a multicast in your data flow and send all...

On the parameter mapping of your Execute SQL Task, you can specify variables that will be used in the task.

Just add your variable there, with direction input, the correct data...

Well, for a newbie you're already doing pretty OK 🙂

But regarding your question, I don't think it is possible.

But what are you exactly trying to log? Every source/destination table in...

Use the Execute SQL Task and the Send Mail Task (luckily SSIS has very logical names for its components :-))

If you do not know how to configure, open a task's...

So you're still facing the issue with records not showing in your sheets? (I am a bit confused by your reply, hence my question).

If you export all your data to...

Nice question and great follow up discussion.

SanDroid (11/17/2010)

Hugo Kornelis (11/17/2010)

So please stop this babbling about a perceived ambiguity, the question is perfectly clear.

All regulars know that I won't hesitate te criticise a question that I feel...

Glad that you solved the problem.

Why was the 32-bit option necessary?

You can try the import and export wizard in SSMS. I thinks it allows you to select multiple tables and to create tables if they don't exist yet.

I'm not sure...

Well, you could store the used configurations in string variables and then write the values of those variables to a text file using a script task.

Or, you can store the...

* data conversion: when you read the data from the source, SSIS will map it to its internal data types. If you write the data to the destination in SQL...