Viewing 15 posts - 16 through 30 (of 36 total)
If you're trying to use a Script - UR doing it wrong 🙂
It even sounds like you're using the script to do the lookup - and you shouldn't.
Use the Lookup...
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 5, 2010 at 10:48 am
The File Properties Task doesn't use any T-SQL at all - it uses the System.IO namespace which is .Net code. And no - it's not SQLCLR either. It's...
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 3, 2010 at 12:10 pm
You can add your "conditional checks" right into your SSIS package, so the SQL Agent job is just a simple "run this package" step.
You can use a Script Task with...
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 2, 2010 at 11:18 am
You wouldn't necessarily need to pass that recordset down to the Data Flow Task - I wouldn't think of doing that as my first choice. What I would do...
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.
February 5, 2010 at 3:18 pm
It's not an issue that VS or SSIS 2008 can solve. It's an Office issue. However, there are definitely very usable workarounds, and some good news about Office...
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.
January 20, 2010 at 3:49 pm
Office itself (in its entirety) doesn't need to be installed, but you'll need to (at least) install the providers. Go here for the download: 2007 Office System Driver: Data...
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.
January 20, 2010 at 3:01 pm
Quick answer for you - no.
Don't think you'll like that answer though. Your only solution is to install 2005 - which you can (apparently) do safely. Personally, I...
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.
January 11, 2010 at 11:38 am
Here's the docs for DTExec, including command line parameters: http://msdn.microsoft.com/en-us/library/ms162810.aspx
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.
January 11, 2010 at 11:14 am
I read from your post that you were using SSIS 2005. Agent jobs in 2005 don't have that handy checkbox, so you have to use an OS Step. ...
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.
January 8, 2010 at 5:23 pm
There are (of course) a lot of ways to accomplish what you want, and your posited method should work.
Keep in mind that for #1, you're going to have to use...
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.
January 8, 2010 at 3:50 pm
You should read up on the issues that are common with the Excel Provider in Douglas Laudenschlager's blog - posts tagged with Excel.
The problem you're having is that Excel is...
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.
January 8, 2010 at 11:41 am
You can also use the one-step method of installing a custom zip task - there are several out there, the first two of them are free (source included) - no...
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.
January 7, 2010 at 11:27 pm
Not exactly sure - but you can debug your component by starting up a session of Visual Studio and connecting to the DTExec process. Set a breakpoint in your...
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.
December 3, 2009 at 5:34 pm
Or just search the SSIS Community Tasks and Components[/url] directory for the word "zip".
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.
December 2, 2009 at 2:13 pm
There are a few ZIP tasks out there - some free. Check out the SSIS Community Tasks and Components[/url] directory, I list them there.
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.
December 2, 2009 at 2:11 pm
Viewing 15 posts - 16 through 30 (of 36 total)