hey,

Send mail is really easy conceptually.

First things first, add a precedence constraint and change this to on success. This will ensure that your mail is only sent if the tasks...

Hey, readup on xp_cmdshell in BOL.

But a little footnote on this one, certain environments (like my own) do not allow xp_cmdshell to run.

~PD

I can swear I saw a posting just like this one in some of the other forums, or maybe even in this one...

Thats a rather big question to be asking....

Thanks man, will file under the references section of my favorites

All you would need is the variable Filename (which contains your filename and filepath)

- In the for each enumerator, you would have to map the Filename variable (on variable mappings,...

Read up in BOL on SSIS Configurations.

Basically, in your case, you need to set the configurations up for connections (I would assume its OLE DB or something).

Now, whenever you need...

Uhmmmm,

How do you mean "...its all the same ..."

What does the logs tell you about the error?

~PD

What I mean is that your source OLEDB connection manager is going to change (in terms of layout - n columns).

That is going to be a problem, because you have...

Just call me lazy to type but I always go for the first one, simply because repeating the word "as" it a lot of typing

But if I write a query...

Read up on the insert syntax from BOL

INSERT INTO destination

(field1, field2 ....)

Select field1, field2

from table1

Pretty straightforward

~PD

Question

Why a parameterised stored procedure? Yes you can, use the execute SQL task for this and pass the parameters in the same order.

But why not simply a merge or a...

Havent worked on x64 yet, but cant see how this will have any material impact.

Are you sure that all your settings are the same on both boxes?

Why dont you configure...

Not a sweat, hopefully we can get you to your end destination....

Okey, you posted a blank...

Ideally, you want to have a configuration for your connection string, and your connection string...

Why dont you split the table into that which cannot change from that which can change?

Your problem is actually one of two:

a) Your customer table may get very wide with...

-use package configurations which have your connection strings present. Make sure its the FULL connection string (i.e. username and password are included)

*Note: SSIS will not save sensitive info, you will...