Archive for the ‘SSIS’ Category
Access system date in SSIS without a Script Task
In: SSIS
28 Sep 2011Set variables to contain the package start datetime with the time truncated, making it easier to compare dates directly.
- No Comments
- Tags: SSIS, T-SQL
Connecting to Oracle with SSIS 2008
In: SSIS
7 Sep 2011Quickly configure a connection from SSIS to Oracle, optionally without TNSNAMES.ora, using the free Attunity Connector provided by Microsoft.
- No Comments
- Tags: Oracle, SSIS
Accessing Custom .NET Assemblies in SSIS 2008 Script Tasks
In: SSIS
14 Oct 2009If you need to access a custom .NET Assembly from an SSIS Script Task, Microsoft doesn’t make things very easy – but it’s still possible with a little setup.
- (2) Comments
- Tags: .NET, C#, SQL Server, SSIS, VB.NET
HOWTO: Connect to MySQL in SSIS
4 Jun 2009Using the MySQL ADO.NET provider, SQL Server Integration Services can natively query MySQL databases, providing an easy method to transfer data between systems.
- (8) Comments
- Tags: MySQL, SQL Server, SSIS
Handling Embedded Text Qualifiers in SSIS 2005
In: SQL Server|SSIS
3 Feb 2009Just a quick note advising that I’ve updated my Handling Embedded Text Qualifiers post to also include a Visual Basic example, making the information also relevant to SQL Server 2005.
- No Comments
- Tags: HOWTO, SQL Server, SSIS, VB.NET
- HOWTO: Sync Google Calendar on iPhone OS 3.0
- HOWTO: Setup SQL Server Linked Server to MySQL
- Connecting to Oracle from SQL Server
- Windows 7 in VirtualBox: Shared Folders workaround
- Fixing "passwd: Authentication token manipulation error" when changing passwords
- Installing Windows 7 Beta 1 in VirtualBox 2.1.0
- HOWTO: Synchronize Dropbox and ZumoDrive on Windows
- Updating SSH known hosts fingerprints (WARNING: REMOTE HOST IDENTIFICATION HAS CHANGED!)
- HOWTO: Connect to MySQL in SSIS
- Efficiently query the DATE in DATETIME
- Stop SOPA
- Access system date in SSIS without a Script Task
- Connecting to Oracle with SSIS 2008
- Set Permissions Across SQL Server Database Instances
- SQL Server Principals & Roles Permission Audit
- New Office Outlook 2010 Data File Menu Item
- Why RAM Matters Less with OS X Lion
- Cache multiple values in a Map Container for fast in-memory lookup
- Ubuntu VirtualBox Server Redux Addendum
- Default column value to identity of different column
- KALImaR:Im having the same 11.10 problem with this irritating disaster...Solutions please [...]
- Balkan:Hi All, I have similar problem as Dwarakesh, I set the automatic login on, and after that my passwo [...]
- Creating an automated database backup by means of SQL Server Agent Job « Placko's SQL KB:[...] Configuring SQL Server Agent Operators by Taylor Gerring [...] [...]
- Dwarakesh:yeah even I'm getting the same error on my sony e series laptop!!!! I am currently running ubuntu 1 [...]
- Phil:Thanks - this article was a great help. [...]
