SQLSourceType of the Execute SQL Task means that the SQL command can be found in a variable, so it is expecting a string.

To use your variable in an Execute SQL...

:rolleyes: Typically Microsoft I guess.

But I'm glad it worked out...

I was thinking the same thing 🙂

spongemagnet (11/23/2010)

---

1) That error doesn't sound familiar. I was curious enough to try to build one of these...

Since you already know how to write the T-SQL statement, just ditch the Merge Join 🙂

The performance of your package will be grateful.

(but I must say, I'm intrigued why it...

I don't think it is possible. You can specify the SMTP server, but the SMTP Connection Manager in SSIS only support anonymous or Windows authentication. And I don't think your...

Do you mean that you have the necessary priviliges or that the SQL Service Account has the necessary priviliges? (just to avoid any...

Kenneth Wymore (11/23/2010)

---

How often are global temp tables actually used? I recall reading about them when I started using SQL Server but I can't remember ever seeing one used in...

Allright. At first sight nothing wrong there. Can you give a screenshot of the parameter mapping?

Can you give us some screenshots (you can attach them to your post)? Blank out any sensitive information if necessary.

Nils Gustav Stråbø (11/23/2010)

---

It's also worth mentioning that GO is not a T-SQL statement. It is a command only recognized by SSMS, sqlcmd and osql, so it can't be used...

Glad that it all worked out and that you (and me) learned something from it.

Quoting BOL:

Does this service account has the necessary priviliges to the specified location?

I like the point the question tried to make, namely using the GO statement as an instrument to loop, but I do not like the trickery with the # name....

You do make some good valid points, but if the real requirement is to make it all dynamic, then there is a chance that the data flow is not an...

Unfortunately...