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 |
|
Claymationator
Starting Member
6 Posts |
 Posted - 2011-04-27 : 01:42:27
|
| I am new to SQL, and not sure exactly where to start looking for exactly what it is that I need to do. So, I will explain here, and hopefully can get an answer, or at least get pointed in the right direction.I have a database that consists of all of our point of sale data, and is updated each morning (early) for the prior days transactions. I need to automate a procedure that will take the data each day and send out a flat file to a vendor that handles our BI reporting. From there they will take the new data and load it into their systems so that we can view it in our dashboards, reports, etc.So, my question is, generally what is the best method to handle this process? Is that something that a stored procedure could handle, or is DTS a better option? Or, is it something completely different from both of those?Any help is greatly appreciated. |
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2011-04-27 : 03:10:24
|
| SSIS Package is the best solution. If you don't know how to work wit SSIS, follow this linkhttp://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/72492/--------------------------http://connectsql.blogspot.com/ |
 |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2011-04-27 : 04:01:13
|
You have not stated the version of your sql server.If sql server 2000 then DTS.If sql server 2005 or above then SSIS like lionofdezert already told you.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
Claymationator
Starting Member
6 Posts |
Posted - 2011-04-27 : 10:41:50
|
| Sorry I forgot to mention, but we are using SQL Server 2008. I'll check those links. Thank you both for your help. |
|
|
|
|
|
|
|
|
Automate Export of Flat File