Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tybaltzeke
Starting Member
28 Posts |
 Posted - 2009-03-26 : 05:03:46
|
| I am starting an SSIS application and have a few 'beginner' questions1. the specs require reading which dimension and fact tables need to be processed from a SQL Server database. what is the simplest way in SSIS to retrieve what files need to be processed. will i ultimately using a for or foreach loop? 2. the dimension tables i need to populate are fairly simple and quite small (rowcounts in hundreds), but do require a join to pickup values from other tables. it seems simpler to create the TSQL that do updates based on joins and use that TSQL in an execute SQL step in a control flow than to have to do lookup transformations from data flows. am i wrong about that? Does it affect the answer to this question above if the source data is read only on a production server and the destination tables are on a development server? |
|
|
|
|
|
New to SSIS, a couple of beginners questions