SQL Server and MS BI With a Geek Touch

It is very simple to schedule the SSIS packages using windows Task Scheduler. Just follow the steps below.

Step 1: create a batch file (.bat or .cmd) file with the command to execute the SSIS packages using “dtexec” it may be as simple as the command below.

“C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\dtexec.exe” /FILE “C:\FY11PackagesAndReports \DataPullv2.dtsx” /MAXCONCURRENT ” -1 ” /CHECKPOINTING OFF /REPORTING EWCDI >C:\ FY11PackagesAndReports \logsIP.txt

Step 2: Save this batch file (.bat) in a folder.
Step 3: Select Task scheduler from the programs ( start Menu)

Read more…

In 64 bit operating systems, SSIS transformations ( especially excel) and tasks throws errors that could be annoying. You will often come across errors as shown below.

SSIS package “Package.dtsx” starting.

Information: 0x4004300A at Data Flow Task, SSIS.Pipeline: Validation phase is beginning.

Error: 0xC00F9304 at Package, Connection manager “Excel Connection Manager“: SSIS Error Code DTS_E_OLEDB_EXCEL_NOT_SUPPORTED: The Excel Connection Manager is not supported in the 64-bit version of SSIS, as no OLE DB provider is available. Read more…

Basic SQL Server Questions

What is RDBMS (Relational database management system)?

RDBMS is a database management system (DBMS) that is based on the relational model. Relationships may be created and maintained across and among the data and tables. In a relational database, relationships between data items are expressed by means of tables. Interdependencies among these tables are expressed by data values

What is the Difference between DBMS and RDBMS?

A DBMS has to be persistent, that is it should be accessible when the program created the data ceases to exist or even the application that created the data restarted. A DBMS also has to provide some uniform methods independent of a specific application for accessing the information that is stored. Read more…