Archive for November, 2008

Set FTP password in SSIS

In: SQL Server| SSIS

24 Nov 2008

SSIS does not allow an FTP password to be set through Expressions. Fortunately, we can manually set the value stored in a variable through a Script Component.

Handling Embedded Text Qualifiers

In: SQL Server| SSIS

12 Nov 2008

SSIS breaks when processing embedded text qualifiers in flat file sources. Tutorial on how to configure a script component to manually split on delimiters.

Query Active Directory from SQL Server (again)

In: SQL Server

4 Nov 2008

Unlike my last post on the issue, instead of simply pointing to another blog for instructions on how to query Active Directory from SQL Server, I’ll provide some useful tips on getting things all working.


Categories

Archives

  • ERNST: HOW TO SYNC MULTIPLE GOOGLE CALENDARS IN IPHONE: To show Multiple Google calendars in iPhone, ope [...]
  • linuxfueled: WINDOWS 7 users read..... If your main OS is Windows 7 (the host machine) and you just cannot get [...]
  • Kurt Hitchen: A friend has let me "see" there calendar in Google Calendar, but because their calendar is set to pr [...]
  • bugoy8: https://www.google.com/calendar/dav/nba_13_%4cos+%41ngeles+%4cakers#sports@group.v.calendar.google.c [...]
  • Speaker: Wasn't able to understand how to access the shared folder in the quest OS from this tutorial. Hmmm [...]


This work is licensed under a Creative Commons Attribution-ShareAlike 3.0 United States.
This work is licensed under a Creative Commons Attribution-ShareAlike 3.0 United States.