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 |
|
fred simons
Starting Member
9 Posts |
 Posted - 2012-03-16 : 09:32:16
|
| Hi, I'm quite a complete newbie in SQL and SSIS. Is this somewere one or two very good tutorials I could follow ?and, is this a list of the must-have tools/packages one should add to ssis ?thank you in advancefred |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
fred simons
Starting Member
9 Posts |
Posted - 2012-03-19 : 04:17:18
|
| thank you for these two links.I need to learn it all because it became part of my job :-DI had a 3days training for the SSAS part of the BI. Then, my boss though it could be interresting for me to have a look on ssis too.And few days later I was promoted to ssis guy, and I'm receiving several txt and xls files from our italian retailers (each one with a different structure). Files I have to put in a cube.The different books I found are in my opinion too much based on the description of what's in SSIS, and not enough on "how to do it".On a youtube video I found how to build my first basic data flow but I need to know more about that .So once more, thank you for your comments.fred |
 |
|
|
NarenSQLTeam
Starting Member
2 Posts |
Posted - 2012-03-19 : 06:21:23
|
| We are here to offer any support with T-SQL and SSIS. Please post us any issue and we will get back to you. |
|
|
|
fred simons
Starting Member
9 Posts |
Posted - 2012-03-19 : 10:05:08
|
thanx a lotI will :)quote:
Originally posted by NarenSQLTeam
We are here to offer any support with T-SQL and SSIS. Please post us any issue and we will get back to you.
|
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2012-03-19 : 10:52:56
|
quote:
Originally posted by NarenSQLTeam
We are here to offer any support with T-SQL and SSIS. Please post us any issue and we will get back to you.
We are.How many files and how many different formats?Do you have any control over the format of what they give you?The goal would be for all of them to share the smae format (or have the same format from period to period) and automate the load to staging tables, audit the data (you should have them give you some form of header/trailer or audit file), pewrfomr data integrity checks..THEN load the junk into a ..cough..cough...cubeBrett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxWant to help yourself?http://msdn.microsoft.com/en-us/library/ms130214.aspxhttp://weblogs.sqlteam.com/brettk/http://brettkaiser.blogspot.com/ |
|
|
|
fred simons
Starting Member
9 Posts |
Posted - 2012-04-02 : 09:10:07
|
| hello again !there are about 16files per weeks. I have very few control over the format (txt, xls or xlsx)it would be perfect to get them use the same structure, thus we sent them a "model". We'll see in the next days if we have been heard. |
|
|
|
|
|
|
ssis for dummies wanted