Scheduling SQL Server Tasks on Linux

In this tip we look at how to schedule SQL Server tasks on Linux servers using Cron.

Downloading multiple files from internet with SSIS and C#

This is a tutorial to download multiple files from internet using the SSIS Script Task.

Data Mining Part 37: The Data Mining query transformation task

This new chapter will show you how to work with the SSIS Data Mining Query Transformation Task

SSIS

RE: Bad Data error in Cryptography

Sorry nothing setup to test here. However hav you run in debug and verified which line is failing and stepped thru the process in full?

Cannot import Paradox file from the Server ???

keep getting on Error messages on my package: (running on Windows Server 2000 SP4 & MS-SQL 2000 SP3)Context:Error calling open rowset on the provider... Error Source: Microsoft OLE DB Provider for ODBC Drivers funny... but it works fine from my Workstation (XP pro SP-1)any suggestion guys ?? thx for the attention

Cannot add domain group

Hi folks.   I have not seen the following before: I cannot add the security group ‘domainname\LADM SLEEC DEV’ as a login to SQL Server which complains that the group does not exist.  If I use Enterprise Manager and attempt to add the user, I can see that the group does indeed exist in the domain… Now, […]

RE: DTS Packages on 64 Bit

We were hit with the same rude surprise when we migrated.  Short version - keep DTS on 32-bit.  It might run, but you are on your own if you do - untried, unsupported, etc.We kept our old 32-bit boxes as the DTS clients, then quickly made some of our packages dynamic so logging and connections […]