I have used PowerDesigner by Sybase for a couple of years now

for DW modeling and find it to be wonderful. It is also a lot

less expensive than...

If you have a multi-select parameter and

want the users to see what they picked (very

useful in troubleshooting) then check out the JOIN

syntax in the expression editor...it will parse the

selected...

In my experience with DW, there are 2 kinds of errors:

1. SSIS fails

2. bad data

for #1 of course I use the built in logging to a SQL table (just

my...

I use Source Safe and like it just fine.

I have also used Vault by SourceGear which isnt bad either.

All dimensions should have surrogate integer keys as the primary

key. The business key is also left in and usually named like

"CustomerNumberBKey" so users can see it easier.

As the previous...

I ended up opening a MS incident via my MSDN subscription

as I just could not get this straight.

In the ini file I added 2 xml blocks for my 2 named

instances...however...

Nevermind.

I'm a fool.

I've not had any luck with that technique either.

I've had parameters values like "INDUSTRIAL SALES REGION - SOUTHEAST DIVISION" and still only like 1/2 of the phrase is immediately

visible. ...

I use procs all the time with OLEDB commands and I

always pass values to all parms. I don't think there's a

way out of it. The only...

I personally have never found a way to increase

the width of the parm boxes. Ever.

I really wish more parm properties were exposed.

I really really do. Maybe becasue I...

Ah ha! I knew there had to be a way!

So have the SQL job set the varibale value for the pkgs to use and

simply have a script component read...

yes, it appears I will have to manually change that ini file for deployment to each instance

on the SQLDEV box.

However, I am not sure that will solve my problem....once...

Anyone? I'm getting desperate.

I have looked all over the internet and can't find an answer.

Is any of this do-able? Or am I stuck copying all my SSIS pkgs...

got it fixed....

the wacky error was really not telling me the actual issue, which was that

I had a column in my input twice. dont ask, because I dont know 🙂

so...

I have a new 2008 pkg, added script component , wrote some

vb code and voila there was the error message when i tried to

run the pkg. I tried...