Viewing 15 posts - 1,351 through 1,365 (of 3,666 total)
Whisper9999 (10/26/2010)
I want my refund.Just kidding...
Got a Paypal account? 😛
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 26, 2010 at 12:33 pm
mazzz (10/26/2010)
Alvin Ramard (10/26/2010)
I can't confirm, but I believe you're correct.
Another option is to recreate the DSNs on your computer. That means you have to install those drivers used...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 26, 2010 at 12:18 pm
Whisper9999 (10/26/2010)
I need to be able to control batch and commti size as these are massive tables. ...
Looks like you'll have to use a data flow for each tables. ...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 26, 2010 at 12:15 pm
In the control flow, there's a task for copying database objects. That might be a better option for you.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 26, 2010 at 11:40 am
mazzz (10/26/2010)
What I need to...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 26, 2010 at 10:31 am
Do you have Integration Services running on your computer? You need it to run SSIS packages on your computer.
Also, try running DTExecUI. You can use it to build...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 26, 2010 at 10:22 am
bruce.b.allen (10/26/2010)
Alvin Ramard (10/25/2010)
If you have to use Excel, and you have a row number for every row...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 26, 2010 at 8:58 am
Phil Parkin (10/26/2010)
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 26, 2010 at 8:51 am
I think you should start by reading this book:
The Data Warehouse Lifecycle Toolkit
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0470149779.html
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 26, 2010 at 8:08 am
If you inject a row number into you data flow, then by using the condition split transform you can control which rows go to your destination and which don't.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 26, 2010 at 7:58 am
I often use On Error Event Handlers to append error messages to my own user defined ErrorMessages variable. At the end of the execution, if the length of that...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 26, 2010 at 7:51 am
pete_bristol (10/25/2010)
Thank you for your prompt reply.
I am familiar with the "ON" clause but cant see how it relates to three tables
i.e. Using my example
select * from tableA
left outer join...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 25, 2010 at 3:54 pm
The more ETL work I do, the more I hate Excel.
Excel is a great product. Just keep it away from ETL.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 25, 2010 at 3:40 pm
I agree with Derrick that flat files would be much easier.
If you have to use Excel, and you have a row number for every row of data going...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 25, 2010 at 3:33 pm
If the stored procedure does not connect to another server then it's very unlikely network problems would affect the performance.
Assume the stored procedure only accesses databases on this server, what...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 25, 2010 at 3:13 pm
Viewing 15 posts - 1,351 through 1,365 (of 3,666 total)