May 26, 2011 at 1:09 pm
I have a task to create an SSIS package that imports three data files into DataMart database. What would be the best approach for this? I am relatively new to SSIS.
thanks
Al
May 26, 2011 at 2:02 pm
Your question is very general for a forum setting...Google/Bing for "ssis tutorial" and "import text file" and start experimenting. If you get stuck on a technical detail trying to get your SSIS package working that you cannot find from using tutorials or other Google/Bing results then come back and post a new topic to get some assistance.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 27, 2011 at 12:17 am
I think the most important thing to realize for your requirement is that if those 3 flat files have different structures, you must use 3 different data flows.
If they all have the same structure (same columns and datatypes), you can use one dataflow inside a for each loop container.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply