SQL server scheduler.

Hot Topic

Unexpected function sequence error when using SQL_CO_FFO on stored procedure
Extranet access to Report Manager
Any examples of a invoice report?
Unable to Deploy Solution
BUG - SSMS 9.00.1399.00 (final release)
run a dos command?
Oracle Translate function equivalent in SQL Server
SQL SERVER 2005 REPLICATION (SNAPSHOT GENERATION FAILING)
Tell subscription to append date & time to output report file from called subscription in VB.NET
Same header in different reports

SQL Server

Can't use Virtual PC for VS 2005 Pro with SQL Server Express
Data Transformation: copying a table to a table... How does it work?
Detecting an Analysis Service and Uploading a cube during Install
Security in report model
Couldn't use and aggregate funtion on an another aggregate function
How to suppress the subreport when there is no data in it?
SSIS Changing Column Order during Transformation
deploying cube w/o database dependencies
Problem with DTSX
Reporting on Exchange Emails

SQL server scheduler.

Hi,

I just want to know if a file can be uploaded in SQL server database in some table using some sort of schduler(No Frontend) and than data to be analysed and put in some specific tables.

I am new to SQl server. if some one can guide me to a link where I can understand how SQl server works. I know about oracle this is possible but now sure about SQL server.

 

Cheers,

Rakesh




Answer this question

SQL server scheduler.

  • Perro

    Information may be loaded into SQL Server table by using BCP utility (such as SQL* Loader in Oracle suite iirc) or - if you need complex analysis, lookups, distributing data in different tables etc. - by creating Integration Services package defining these tasks and executing it by schedule or manually. You may find info about SSIS here:

    http://msdn.microsoft.com/sql/bi/integration/

    WBR, Evergray
    --
    Words mean nothing...
  • SQL server scheduler.
Answer this question