Viewing 15 posts - 1 through 15 (of 36 total)
There is - it's called the Import/Export Wizard...
Todd McDermid - SQL Server MVP, MCSD.Net, MCTS (SQL08BI)
Find great SSIS extensions - most are open source - at SSIS Community Tasks and Components[/url]
Are you doing Data Warehouse ETL with SSIS? Don't use the slow SCD Wizard, use the Kimball Method SCD component instead.
July 14, 2010 at 10:22 am
Use the Import/Export Wizard to get your package started, then edit it in BIDS.
You won't necessarily have 1000 Data Flows, but you probably should. (You can put more than...
Todd McDermid - SQL Server MVP, MCSD.Net, MCTS (SQL08BI)
Find great SSIS extensions - most are open source - at SSIS Community Tasks and Components[/url]
Are you doing Data Warehouse ETL with SSIS? Don't use the slow SCD Wizard, use the Kimball Method SCD component instead.
July 13, 2010 at 8:26 am
The piece you're missing is to place a property expression on the File Connection Manager.
Select the File Connection Manager, then open the Properties pane (F4). You'll see a "ConnectionString"...
Todd McDermid - SQL Server MVP, MCSD.Net, MCTS (SQL08BI)
Find great SSIS extensions - most are open source - at SSIS Community Tasks and Components[/url]
Are you doing Data Warehouse ETL with SSIS? Don't use the slow SCD Wizard, use the Kimball Method SCD component instead.
July 8, 2010 at 9:34 am
If I understand what you've described, you're a little confused on how to set up the task.
If you have your file paths already specified in SSIS variables (specifically, in "sourcepath"...
Todd McDermid - SQL Server MVP, MCSD.Net, MCTS (SQL08BI)
Find great SSIS extensions - most are open source - at SSIS Community Tasks and Components[/url]
Are you doing Data Warehouse ETL with SSIS? Don't use the slow SCD Wizard, use the Kimball Method SCD component instead.
July 2, 2010 at 1:12 pm
Yes, you can do this through the "back door" of property expressions. In this case (inside the Data Flow) it isn't particularly pretty, but it works.
Open your Data Flow,...
Todd McDermid - SQL Server MVP, MCSD.Net, MCTS (SQL08BI)
Find great SSIS extensions - most are open source - at SSIS Community Tasks and Components[/url]
Are you doing Data Warehouse ETL with SSIS? Don't use the slow SCD Wizard, use the Kimball Method SCD component instead.
June 22, 2010 at 4:30 pm
Jason Lees-299789 (6/14/2010)
Todd McDermid - SQL Server MVP, MCSD.Net, MCTS (SQL08BI)
Find great SSIS extensions - most are open source - at SSIS Community Tasks and Components[/url]
Are you doing Data Warehouse ETL with SSIS? Don't use the slow SCD Wizard, use the Kimball Method SCD component instead.
June 14, 2010 at 3:22 pm
Do a simple text search on the DTSXs. There really is no other way for the SSIS packages. DTS and other objects, dunno.
Todd McDermid - SQL Server MVP, MCSD.Net, MCTS (SQL08BI)
Find great SSIS extensions - most are open source - at SSIS Community Tasks and Components[/url]
Are you doing Data Warehouse ETL with SSIS? Don't use the slow SCD Wizard, use the Kimball Method SCD component instead.
June 10, 2010 at 5:38 pm
You need to investigate the SCD Component.
Todd McDermid - SQL Server MVP, MCSD.Net, MCTS (SQL08BI)
Find great SSIS extensions - most are open source - at SSIS Community Tasks and Components[/url]
Are you doing Data Warehouse ETL with SSIS? Don't use the slow SCD Wizard, use the Kimball Method SCD component instead.
June 9, 2010 at 1:12 am
Great article, Brett. I have a half completed one in my pipe similar to this - but directed solely at how to use a hash to speed up my...
Todd McDermid - SQL Server MVP, MCSD.Net, MCTS (SQL08BI)
Find great SSIS extensions - most are open source - at SSIS Community Tasks and Components[/url]
Are you doing Data Warehouse ETL with SSIS? Don't use the slow SCD Wizard, use the Kimball Method SCD component instead.
June 8, 2010 at 10:37 am
So to be clear - you have this working in 32-bit mode through BIDS? If so, what's your connection string look like there? It doesn't have the "12"...
Todd McDermid - SQL Server MVP, MCSD.Net, MCTS (SQL08BI)
Find great SSIS extensions - most are open source - at SSIS Community Tasks and Components[/url]
Are you doing Data Warehouse ETL with SSIS? Don't use the slow SCD Wizard, use the Kimball Method SCD component instead.
June 3, 2010 at 11:43 am
Despite the fact that you thought you were using the 2010 driver - you weren't. Check your error message and you'll see it naming the 2007 driver... unless you've...
Todd McDermid - SQL Server MVP, MCSD.Net, MCTS (SQL08BI)
Find great SSIS extensions - most are open source - at SSIS Community Tasks and Components[/url]
Are you doing Data Warehouse ETL with SSIS? Don't use the slow SCD Wizard, use the Kimball Method SCD component instead.
June 2, 2010 at 5:55 pm
Contrary to your experience, I haven't had any "backwards compatibility" problems using Excel with SSIS in an x64 environment - be it 2003 server, 2008 server, Vista, or Windows 7.
To...
Todd McDermid - SQL Server MVP, MCSD.Net, MCTS (SQL08BI)
Find great SSIS extensions - most are open source - at SSIS Community Tasks and Components[/url]
Are you doing Data Warehouse ETL with SSIS? Don't use the slow SCD Wizard, use the Kimball Method SCD component instead.
May 4, 2010 at 3:26 pm
It's the code page to use for interpreting the internal binary representations of the characters. Since you're speaking English, it's a sure bet that 1252 (the default) is fine...
Todd McDermid - SQL Server MVP, MCSD.Net, MCTS (SQL08BI)
Find great SSIS extensions - most are open source - at SSIS Community Tasks and Components[/url]
Are you doing Data Warehouse ETL with SSIS? Don't use the slow SCD Wizard, use the Kimball Method SCD component instead.
April 20, 2010 at 12:27 pm
The easier and more efficient way to accomplish what you want isn't by using a separate Data Conversion component. Just change the expression a little in the Derived Column...
Todd McDermid - SQL Server MVP, MCSD.Net, MCTS (SQL08BI)
Find great SSIS extensions - most are open source - at SSIS Community Tasks and Components[/url]
Are you doing Data Warehouse ETL with SSIS? Don't use the slow SCD Wizard, use the Kimball Method SCD component instead.
April 20, 2010 at 10:26 am
When you post a question, especially one where you can't get something to work the way you expect, please post complete information. In this case, post the expression you...
Todd McDermid - SQL Server MVP, MCSD.Net, MCTS (SQL08BI)
Find great SSIS extensions - most are open source - at SSIS Community Tasks and Components[/url]
Are you doing Data Warehouse ETL with SSIS? Don't use the slow SCD Wizard, use the Kimball Method SCD component instead.
March 25, 2010 at 10:14 am
Viewing 15 posts - 1 through 15 (of 36 total)