Help please - New user

Hot Topic

Is it possible to restrict the Users to Export Report Results only to Excel ?
Reporting Services 2000 - Printing Hangs
Top 20 totals and aggregates
System Variables in a SSIS package
I ran a update quey by mistake
Can i connect to SQLExpress instance using (local)
Can't connect to sql express 2005
Conditional Send Mail Task
how to writethis
Purchasing SQL Server 2005

SQL Server

Old FSO snippet of code
SQL 2K5 SSIS DTS.Pipeline errors
Changing data type from Char to Datetime
toDatetime.
Null Values in Destination
CE support from ASP.Net 2.0
Adding multiple fields together
OLEDB Command stage error in SLOWLY CHANGING DIMENSION
SQL Server dumping continuously after running SSIS package
Rebuild Index grew database .mdf files

Help please - New user

Hi all

My project is a bit like eating an elephant, and I am about to take the first bite!

I have built a number of Access databases over the last 4 years which support our local Production reporting, these work well and are within the scale supported by Access. However, my boss does not want to move forward with the Access platform. He wants me to redevelop the applications into one SQL database, which will have a new, and yet to be identified back end (something like clickview). Once developed we want to roll out the application to the rest of our group.

The tables in my database will mainly be populated from our ERP system. The tables will either be master files, or transactions for a given range of dates. The master files I will want to append and update records (just in case we ever do any file maintenance). The transaction data I will be deleting the date range from the SQL table then appending the selected data. We will probably want to execute the loading of the data from a form (written in Visual Basic) which the user will supply a range of dates.

My problem is that I am an Accountant by training, and am self taught in Access, VBA and some other programming languages; I have no training in SQL Sever, other than loading the Developer Edition on my PC and following the basic tutorials. So I am hoping that you good people on this forum can point me in the right direction from time to time.

Firstly, is SISS the right place to start to design the loading of my data The current Access databases that I have use ODBC links to our ERP system to collect data, which then I have to transform, normally with User defined functions written in VBA. Can I write user defined functions to use in SISS I could replace some functions with look up tables, but I don’t really want to do this. I am starting with the basic master file load, I have created the connection to the first table that I want to use, but I am now a little bit stuck. Any advice ( other than don’t do it ) would be very welcome.

Regards

ADG

Answer this question

Help please - New user

  • R3dD0g

    Yes, SSIS is the right tool for your ETL work. SSIS is extensible, you could write your own functions using Script task/components. As far as the proper drivers are installed; SSIS should be able to connect to the source systems toget the data.

  • Renan Souza

    And since you are new, I'd like to help you reserve judgment on things like lookup tables before you actually try to work with them. They can be very fast if done correctly. Surely this whole SSIS concept that you'll be working on would be much faster than anything you can do in Access.


  • EWANAME

    Many thanks

    The script component was just what I needed, I was not aware of VSA. Using the script component I was able to sort out my problem with the tutorial where there was a date problem. I think VSA will solve the majority of my data import issues.
  • Help please - New user
Answer this question