Add an EXEC SQL task and write the data to a table, then query it later. Or use a script task to append the data to a string in...

Perhaps. you could look on connect.microsoft.com and see if it was reported.

CEWII

How do you guarantee always to generate the sam sequence number for a particular meter. Is this a oneshot deal? If not each subsequent run could easily generate...

You could try sending all the variables into a script task and sending the mail from there. It also might be able to give you more insight into where...

Can I ask a different question..

Does the operational system that provides this data not have some unique identifier for the meter itself? And if not then WHY and if...

I assume those translate to Running Packages and Stored Packages. Under Stored Packages you should see "File System" and "MSDB". Under msdb you should see your structure.

CEWII

Unfortunately, sometimes when we inherit something stupid we have to just suck it up. Other times we can push back and say this is virtually unmanageable and needs to...

I'm still a little fuzzy on the WHY? I think having the same package in multiple places is generally a bad idea, and there are very few (IMO) business...

I don't believe connections are retained package-to-package only intra-package. I am personally not aware of issues. However, I usually leave it off. The new connection isn't that...

I don't know of an option to remove it. However, you could disable the service.

CEWII

What destination are you using? The column order is defined be the destination object such as a table or a flat file connection. The mappings are done on...

Why are you doing this?

CEWII

What are you specifying in the config file, the whole connection string or just a password?

CEWII

1. Yes.

2. Probably, true if you don't have any proxies configured, otherwise it will use the proxy account specified.

CEWII

Actually, that is a really good question..

CEWII