Viewing 15 posts - 7,741 through 7,755 (of 11,676 total)
Nice back to basics question. Very thorough reference though, took me hours to wield through 😀
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 6, 2012 at 11:26 pm
cvyc06 (3/6/2012)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 6, 2012 at 1:46 pm
I heard some good feedback about CBT Nuggets:
http://www.cbtnuggets.com/it-training-videos/series/microsoft-sql-server-2008-business-development
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 6, 2012 at 3:27 am
Check out the MS SQL Server 2008R2 Feature Pack:
it contains some connectors that allow SSIS to connect to SAP. However, you need the Enterprise version of SQL Server.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 6, 2012 at 1:09 am
Usually there's also a log for the set-up. Was that already created?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 5, 2012 at 11:21 pm
Nice question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 5, 2012 at 11:17 pm
Mmmmm, onion soup. Now I'm hungry 🙁
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 5, 2012 at 11:03 pm
I just read the training kits available for the exams, read a lot of blogs/articles and MSDN pages.
There's a certification forum here at SSC (near the bottom of the list),...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 5, 2012 at 11:02 pm
This reminds me of Indiana Jones' Temple of Doom.
Yummie.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 5, 2012 at 12:33 pm
1. FTP the .CSV file to a local directory.
2. Create a dynamic connectionstring to the flat file:
SSIS - Dynamically set Flat File Connection Manager
3. Read the flat file and write...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 5, 2012 at 5:13 am
You can find an example here:
http://consultingblogs.emc.com/jamiethomson/archive/2005/12/09/2480.aspx
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 5, 2012 at 5:09 am
Mike-1076638 (2/29/2012)
You are wasting your timeSSIS does not work correctly with EXCEL.
No, the JET OLE DB provider cannot read Excel files decently.
Big difference.
Whatever the problem is, it can be solved...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 5, 2012 at 1:04 am
You can also use Regulare Expressions in the script component:
Data Cleansing with Regular Expressions in SSIS[/url]
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 5, 2012 at 12:59 am
Here you go:
http://www.red-gate.com/products/sql-development/data-cleanser/
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 5, 2012 at 12:56 am
Can you post the error messages?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 5, 2012 at 12:54 am
Viewing 15 posts - 7,741 through 7,755 (of 11,676 total)