Nice back to basics question. Very thorough reference though, took me hours to wield through 😀

cvyc06 (3/6/2012)

---

You are right. Not just here but in almost every forum I see an increasing number of questions on very basic concepts. Perhaps RTFM should be the...

I heard some good feedback about CBT Nuggets:

http://www.cbtnuggets.com/it-training-videos/series/microsoft-sql-server-2008-business-development

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.

Microsoft® SQL Server®...

Usually there's also a log for the set-up. Was that already created?

Nice question, thanks.

Mmmmm, onion soup. Now I'm hungry 🙁

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),...

This reminds me of Indiana Jones' Temple of Doom.

Yummie.

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...

You can find an example here:

http://consultingblogs.emc.com/jamiethomson/archive/2005/12/09/2480.aspx

No, the JET OLE DB provider cannot read Excel files decently.

Big difference.

Whatever the problem is, it can be solved...

You can also use Regulare Expressions in the script component:

Data Cleansing with Regular Expressions in SSIS[/url]

Here you go:

http://www.red-gate.com/products/sql-development/data-cleanser/

Can you post the error messages?