I'm afraid that your logic is not quite sound 🙂

You are setting Bin1, Bin2, ..., Bin9 to the same value for each letter in the binary string - so they...

Wow, that's what I call dedication - get that man a beer!

tobe_ha (6/9/2009)

---

Hi,

I tried to understand the structure of the xml in the package. When I format the xml, afterwards the package cannot be loaded. "Error loading ..."

How can that be?...

You have multiple sources and 1 destination - so surely it is your source data which should be dynamic and the destination which should be fixed?

Why not use a SQL...

This thread might be of interest:

http://www.sqlservercentral.com/Forums/Topic463182-148-1.aspx

Nice solution. What happens if the expression evaluates to FALSE? I'm assuming that control flow doesn't just stop because there is no onward path?

Yeah, I know I should know the...

Well done for persisting with this one.

In case you're still interested, here's a function I sometimes use for reading variables:

Private Function GetVariable(ByVal varName As String) As String

...

Rather than listing your variables in the Read Only section of the component, you will almost certainly have more success by using VariableDispenser to read them.

I can post an example...

I suggest that you import your data as two columns: Name, TheRest and add a derived column transformation, ClockNum, which is defined as Left(TheRest, 5).

Phil

Declare @month int, @year int

Declare @dt Datetime

Set @dt = getdate()

set @month = month(@dt) - 1

set @year = year(@dt)

if @month = 0 --january

begin

Set @month = 12

Set...

Thank you Guenter - there's always something to learn with this product!

You could try making a view (in Access) of MSysObjects and attempt to access that?

--edit: (cough) Oops! I think they're just called 'queries' in Access 🙂

kevin.lanners (6/2/2009)

---

Thanks!

The update statement worked... I was right, it was pretty simple as soon as started thinking "outside the table"

Instead of referencing the newly created table I added an Execute...

Did you try my suggestion of changing the derived column's datatype to DT_STR?

Then we should be keeping DT_STR from one end of the pipeline to the other and your destination...

You just need to avoid mixing and matching your datatypes if you can. Working with DT_STR is just fine. Try using the Advanced Editor on your datasource and looking at...