Viewing 15 posts - 1 through 15 (of 118 total)
I think we need some more information.
From the little understanding I could gather, here is my suggestion:
Create a project parameter and call it Status. This is what...
October 31, 2014 at 1:46 pm
I haven't used much PowerShell, but I appreciate the input. I'll check this out.
November 12, 2013 at 2:39 pm
guy.stephens (10/27/2013)
October 29, 2013 at 2:50 pm
I would choose dimension because it is a attribute and not a measure.
April 25, 2013 at 11:00 am
Personal strategy would be to build an ODS database and use a combination of SSIS and merge statements to extract data off of your source systems and load it into...
April 5, 2013 at 12:12 pm
Koen Verbeeck (3/28/2013)
tmitchelar (3/28/2013)
Cindy Conway-312336 (3/28/2013)
If VS is running as 32-bit, why do I need to set Run64BitRuntime to False? If I don't I get the following...
April 2, 2013 at 12:40 pm
Above is the preferred method, but you could also use a PowerShell script to archive if you have more familiarity using that.
April 2, 2013 at 12:39 pm
You need the iSeries Access for Windows installed. This will provide you with the data provider to connect to AS400 through SSIS. It will give you the option...
April 2, 2013 at 12:36 pm
EdVassie (4/2/2013)
When processing a database of this...
April 2, 2013 at 11:21 am
BIDS is all you need! Install it and go to town.
March 28, 2013 at 12:44 pm
Anthony,
You are correct in your thinking - I don't see any reason to implement any performance strategies to your data warehouse. It would be a waste of your time...
March 28, 2013 at 12:41 pm
Cindy Conway-312336 (3/28/2013)
If VS is running as 32-bit, why do I need to set Run64BitRuntime to False? If I don't I get the following error:
The requested OLE...
March 28, 2013 at 12:29 pm
Dave.Valentine (3/20/2013)
You can do this a couple different ways. You can use and XML PATH query with a DB Source, or you can get creative with a script...
March 22, 2013 at 11:32 am
It may be coincidence, but I've never worked for a company that uses text files for logging or auditing - always table driven. Personally, I'd never use text files...
March 22, 2013 at 11:25 am
Make sure the proxy account has db_ssisoperator role in the msdb.
March 13, 2013 at 4:31 pm
Viewing 15 posts - 1 through 15 (of 118 total)