I'm not positive what security/accounts asp .net or IIS are running under on our server, as I don't have any permission to see that at my company. I am at...

Since I wasn't able to find a free SSIS documenter with unlimited use, I decided to build my own. It's not perfect yet, there still needs some additional testing and...

Choose ColA and ColB as Input Columns

Heres a Script Component code example:

Public Class ScriptMain

Inherits UserComponent

Dim Counter As Integer = 1

...

Use a Sort Transformation to first make sure your rows are sorted properly (ie, sorted by ColA).

Then use a Script Component to "reassign" ColB.

In the script component you can...

That is something that always bothered me as well. I asked the same question and could not find a solution to it. Hopefully someone knows of a way around this....

Michael Earl (6/3/2008)

---

What type of data source (Connection Manager) are you using? All of the connection managers allow you to set their properties with expressions, but unless you need...