Description or other relevent information. This is just a sample template for a component.
Suggestion - very nice site gents, very useful once I've designed my information model. But I haven't.
So, could I request as a first FAQ a little advice on management in Integration Services - for instance at the moment I am just messing around and creating data sources to fulfill specific tasks, for instance I have my financials on an SQL server and my manufacturing on an Oracle server - I need to get the costs of production. Now, I have two different types of raw materials I need to combine with manufacturing data - paper and ink (yes we're printers). At the moment I have two packages defined - one for each raw material. These are fed from views specified on the source servers.
Now, my problem is twofold. On one hand there is performance and on the other is management of packages. I could take a view that I forget creating views on the source servers and just create a package which takes all the information I could ever possibly require and transform it inside a package, ie using SSIS as my entire development environment, or I could carry on as I am. If I carry on as I am then I guess I'll be heading for a management nightmare as the number of packages and views involved in the equation increase. I suppose my questions revolve around how easy it is to reverse engineer the packages (certainly with Crystal and Oracle Discoverer I took the views route because it is virtually impossible to reverse engineer "in report" SQL) and also any performance implications of a large package.
Any suggestions?
Thanks
Rich
Wishes for types of sources you'd like to see.
.