Numerous windows open during debugging

Hello all

Im sure this is something minor that I am overlooking but for some reason when I go to debug my ssis package all these windows keep opening( callstack, watch1, watch2,watch3,breakpoints, etc) . I cant seem to find out how to disable these -- any suggestions? I dont remember actually setting these to run

thanks

kam

When in debug mode you can close the windows with the 'X' in the upper right hand corner of the window...|||

thanks

but last week I could run the ssis package and only have output, solution explorer, tools be the only visible windows now I get about 15 windows popping up

|||Sorry. Try closing them. While in debug mode you can go through the debug menu to chose windows.

Numerous SSIS and SSAS problems

First, in SSIS I cannot delete the data viewer from a connection between two tasks in the data flow without crashing BIDS. Even if I delete the connector or the tasks, BIDS crashes.

Second, in SSAS I accidentally deleted an attribute and the undo does not work in SSAS/BIDS. I put the attribute back and the dim won't deploy. It just runs forever.

Finally, in ProClarity my drill to detail is not displaying the fact rows I want. Plus the column headers are not easy to read. How can I make SSAS reference the correct data and corresponding column headers.

TJ

> Second, in SSAS I accidentally deleted an attribute and the undo does not work in SSAS/BIDS.

> I put the attribute back and the dim won't deploy. It just runs forever.

Indeed, undo is not yet implemented. After putting back the attribute, when you deploy, do you get an error or the deployment takes a long time ? If the deployment takes a long time, it's probably because the data is re-processed (although you put back the attribute, I believe its ID changed and will trigger a re-processing of the dimension). To stop re-processing on each deployment, right click on the project node -> Properties -> Deployment tab -> Processing Option.

Things to check/recover when putting back the attribute: was the attribute involved in hierarchies (was it source of levels in hierarchies ?) or attribute relationships or was used as granularity in measure groups ? (by default, the key attribute is the granularity)

Adrian Dumitrascu

Numeric[DT_NUMERIC] - comma or dot

Hi,

I have this problem:

In one SSIS project that I have, I convert (by using Data Conversion) my numeric column into Numeric[DT_NUMERIC] and get:

1.000000

Then, in another project I convert the same column again into Numeric[DT_NUMERIC] and get:

2,000000

Does anybody know how I can control if I′m using a dot or a comma?

Thank you.

Cannot say I have seen this. Are the packages run on the same machine? If not, are the regional settings the same?|||

Yes, they are running on the same machine.

|||

Arg! My fault, the regional settings of the Flat File was different.

Thanks for the help!!

Null value handling in SSIS package

Hi All

I am facing this problem while loading data from text file into Table.

Scenario is -

There are chances of having spaces for null values in text file.

when i m trying to rum my SSIS package this is getting failed.

How can i avoid this problem? i want null values to be inserted if ther is spaces for that field in text file.

Thanks,

Anshu

Hi,

You can use a derived column transformation and check to see if your input column value has all spaces... trim and followed by len and if len == 0, set the column value to null.

Hope this helps...