SSIS - SQL SERVER Integration Services (since SQL SERVER 2005) previously named as DTS - Data Transformation Services
SSIS is an ETL application - Extraction Transformation Load
BIDS is the Development tool - Business Intelligence Development Studio
Package - Product that SSIS produces
Control flow - Workflow of a package
Data flow - Movement of data in a package
Task - Individual Unit of Work
Transform - Individual Unit of Work in a data flow
Event Handler - Handle errors, warnings or events.
Sharing knowledge does not lessen your store, often it gets you more.
Success doesn't happen overnight and patience is key to living your dream life.
Success is a journey not a destination
Thursday, May 20, 2010
Run Exe's in Windows 2008 Task Scheduler
I had a requirement where I needed to run a program as a scheduled task. I configured the program but it wasn't firing the exe at all. At last I figured out that I cannot execute an EXE via Task Scheduler and used a batch script to wrap the EXE call and scheduled it in Task Scheduler.
@echo off
echo %date% %time% Start of task > c:\temp\test.log
echo User=%UserName%, Path=%path% >> c:\temp\test.log
c:\Tools\Task.exe 1>>c:\temp\test.log 2> c:\temp\test.err
echo ErrorLevel of c:\Tools\YourTask.exe=%ErrorLevel% >> c:\temp\test.log
echo %date% %time% End of task >> c:\temp\test.log
@echo off
echo %date% %time% Start of task > c:\temp\test.log
echo User=%UserName%, Path=%path% >> c:\temp\test.log
c:\Tools\Task.exe 1>>c:\temp\test.log 2> c:\temp\test.err
echo ErrorLevel of c:\Tools\YourTask.exe=%ErrorLevel% >> c:\temp\test.log
echo %date% %time% End of task >> c:\temp\test.log
How to get a range of rows in SQL SERVER and Oracle?
I had a request where I need to get a specific set of rows with a start row number and end row number and I needed to have the Query for both SQL Server and ORACLE.
Solution
SQL SERVER
ORACLE
Solution
SQL SERVER
ORACLE
AjaxControlToolkit requires ASP.NET Ajax 4.0 scripts
If you are using Dynamic data controls and if you get the following error?
Microsoft JScript runtime error: AjaxControlToolkit requires ASP.NET Ajax 4.0 scripts. Ensure the correct version of the scripts are referenced. If you are using an ASP.NET ScriptManager, switch to the AjaxScriptManager in System.Web.Ajax.dll, or use the ToolkitScriptManager in AjaxControlToolkit.dll.
Solution
Are you using ScriptManager or ToolkitScript manager? You need to use the ToolkitScriptManager in order for the new AJAX Toolkit to work.
Change
<asp:ScriptManager ID="ScriptManager1" runat="server" />
to
<asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server"></asp:ToolkitScriptManager>
Microsoft JScript runtime error: AjaxControlToolkit requires ASP.NET Ajax 4.0 scripts. Ensure the correct version of the scripts are referenced. If you are using an ASP.NET ScriptManager, switch to the AjaxScriptManager in System.Web.Ajax.dll, or use the ToolkitScriptManager in AjaxControlToolkit.dll.
Solution
Are you using ScriptManager or ToolkitScript manager? You need to use the ToolkitScriptManager in order for the new AJAX Toolkit to work.
Change
<asp:ScriptManager ID="ScriptManager1" runat="server" />
to
<asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server"></asp:ToolkitScriptManager>
SSIS: Connect to Oracle database
I've been trying to access data in Oracle from SSIS via OLE DB and was getting the following warning:
"Cannot retrieve the column code page info from the OLE DB Provider. If the component supports the "DefaultCodePage" property, the code page from that property will be used. Change the value of the property if the current string code page values are incorrect. If the component does not support the property, the code page from the component's locale ID will be used."
Solution
Set AlwaysUseDefaultCodePage=TRUE on the OLE DB Source component that shows the warning and it will work fine
"Cannot retrieve the column code page info from the OLE DB Provider. If the component supports the "DefaultCodePage" property, the code page from that property will be used. Change the value of the property if the current string code page values are incorrect. If the component does not support the property, the code page from the component's locale ID will be used."
Solution
Set AlwaysUseDefaultCodePage=TRUE on the OLE DB Source component that shows the warning and it will work fine