Search results for query: *

Hi All: I have varchar values like '01234560' that I need to convert to decimals like 123.456. The length of the varchar values change, so I'd like to be able to do something like: DECLARE @var1 varchar(8) , @var2 int SET @var1 = SUBSTRING('0123456', 1, 4) + '.' + SUBSTRING('0123456', 5, 3)...

Hi All - Probably easy question: How do you modify the value of an input param in a function? I am passing in an Int and I want to conditionally increment the value. TIA - Sven

Thanks for the pointer Dagon. SantaMufasa has helped me many times!

Hi All: I want to write a query to conditionally set the values passed to an IN operator. Using the code below, I want to pass ('A', 'B') when someVariable = 'someVal'. Else I pass ('C', 'D', 'E'). Whatever I pass should filter the cur_data table on the key_letter column. Any thoughts how to...

Why can't I use a foreach container with a file system task in it? My thinking is the foreach would read the destinations into a variable and the file system task would use the variable to copy the file to the destiantions. I tried this but it doesn't seem to work...

Thanks. I was having serious brain freeze...

Hi All: I need to query the table below to get the Part_Nos that have the earliest Create_Dt, grouped by UPC. In cases where there is more than one matching result, I want the one with first value returned based on an alpha sort of the Part_nos. Based on the table below, I want to return...

Can you provide some detail how you did that?

Hi All - I would like to use SSIS to: 1) Read the names of multiple subdirectories 2) Copy a single file to each subdirectory (Same file to different destinations). Can anyone suggest how to approach this? TIA, Sven

Hi All: Can someone tell me if it is possible to use SSIS to run an executable on a remote machine, and if so how? For example, if I am running SSIS on MachineA, how can I run an executable on MachineB? Thanks, Sven

We do use source control, but I was curious about other places for comments...

Hi All: I am new to SSIS, but thave a lot of Oracle SP experience. In Oracle I would put a block of comments in the head of my packages to track change history. What is the best/suggested to do this in SSIS? TIA, Sven

Simple answer to my own question: copy-item H:\PS H:\PS_target -Recurse -Filter "*xyz*

Hi All - I want to write a PS routine to recursively search a directory. If that search finds files with a certain string of characters ("xyz") in the name, the file should be copied to a target with the directory structure on the source replicated (if it does not already exist) on the target...

Hi All: I am new to PS. The line below almost does what I need... I want to recusively look in $Path and return every file that has the string "(1)" - open paren, digit one, close paren, in that sequence - in its name. With the command below, my results include files that have all three...

Hi All - I would like to have a report where I can join data from a cube with data from a relational store. Can this be done in SSRS? TIA - Sven

Hi all: I have a query that returns strings. However, I would like to conditionally format the data as a string or int. The following renders "# Error" in my report when it encounters data I want to format as string. =Switch( Fields!SORT_FLAG.Value=0,Fields!C1.Value...

What I want to do is expose data from a cube and a relational store, together. For instance, I have sales data in a cube and planning data in a relational store. Both have SKUs. I have full control over the relational store, but am only a consumer of data from the cube. I want to show the sales...

All: I have access to some cubes that I want to join to relational data. Can anyone suggest how I could/should go about that? TIA, Sven

Thanks all for the great info!