A small question:

isn't the variable @InputStr stored somewhere? As the loop goes on forever, at some point in time that variable will become too large to reside in memory/physical location....

What are you exactly trying to find out, because as far as I know, there aren't any execution plans for SSIS.

There is the concept of execution trees though, is that...

One disadvantage of the File System is that you have to handle security (authorization) yourself. Meaning, if your developer creates a job on the SQL Server but SQL Server Agent...

A whole lot of text, but I believe your question is how to get the result set from the T-SQL into the Excel, right?

You can map the resultset from the...

Well then, we can conclude that the upgrade to sp3 messed everything up 🙂

Can you try the solutions given in the following URLs?

link1[/url]

and

link2[/url]

Does it happen with all the new script components that you add?

Can you write some code, or does the error happen right away? Meaning, you are not able to write...

So,...

I assume there is some Visual Basic code inside the Script Component? You know, the code that you want to edit?

Or does the error happen when you drag a new...

First you'll have to figure out what piece of code generates the error. Maybe it uses some depricated functions?

Then, you can edit the code in the XML file in the...

To answer Jason's question, here's a script that searches for all files that match a specified filename with wildcards.

The filename with the wildcards is stored in a variable. Another variable...

I believe that SSIS works with unique IDs for its components 'under the hood'. Like LineageIDs for the columns.

I've had the same problem when copy pasting items with connections, and...

Are you added as one of the operators?

If you are, are all your credentials set up correctly in SQL Server?

This is more of a DBA issue than a SSIS issue,...

If you are using a job in SQL Agent, you can use the Notifications tab in the properties window of the job. Click E-mail, choose an operator (this must be...

Elliott W (4/7/2010)

---

da-zero (4/7/2010)

---

Well, it is kind of tricky in maintenance 🙂

I don't like the idea of mapping variables to ordinal positions, and perhaps mapping the same variable to multiple...

Elliott W (4/7/2010)

---

I'm a little fuzzy why we are making this so tricky..

Why don't you just use parameter mapping in the Exec SQL Task

UPDATE dbo.TableName

SET Field1 = ?, Field2 =...