Phil,

Parameter mapping is only used when you are passing a variable into a stored proc.

Hope my previous posting resolves this for you

~PD

For sure you can, but I have to ask why?

Why not use where fieldname = getdate().

Anyways, to use the value from a variable in a different part of your SSIS...

Any specific reason why it HAS to happen in a stored proc?

Why cant you pipe out the results from the stored proc with the use of SSIS in BIDS?

Hey Phil,

There is a forum where you can post your SSIS related questions.

In this case its actually really easy

a) Add a variable with a scope of package. Ensure that the...

No not at all...

If you click on SSIS, package configurations, have a look at what is available.

All that will happen is that whatever you are saving in a package...

http://www.sqlservercentral.com/Forums is most probably the best site that I have ever encountered which offers darn good advice.

Just shoot with your question, and you will have a relatively good answer in...

hey Nat,

Try using package configurations which you save to SQL server.

Then you dont need to save sensitive at all

Hope this helps

~PD

Hey David,

It is actually not that difficult.

a) Add a variable called varCurrentDateTime, with a variable type of datetime.

b) Add a SQL task pointing to any old OLEDB connection, with...

Oops!!!! Wrong thread. Please ignore

Hey David,

It is actually not that difficult.

a) Add a variable called varCurrentDateTime, with a variable type of datetime.

b) Add a SQL task pointing to any old OLEDB connection, with...

Oops, my bad. Forgot about the rowcount transformation.

Where I had to use the aggregator is when I had to decide if a run balances or not based on row count...

Hey,

How are you using the openquery? Are you selecting into?

Perhaps first create your table, and set the datetime field to allow nulls?

Good Luck!

~PD

hey rupalee,

a) Add a variable with a scope of package. For arguments sake, lets call the variable varRowCount.

b) On the dataflow section, add the source as being your OLEDB source....

Unfortunately this is beyond what I can help you with.

I would suggest you read up on your .NET provider documentation

What driver are you using in SSIS to query lotus notes db with?