Tag Archives: SSIS

Send Text notifications

I have most of my jobs set up to email me either when they fail or when they complete, depending on how sensitive the job is. If I need to know it is taking too long, I set it up … Continue reading

Posted in Uncategorized | Tagged , , , , , | Leave a comment

Data Transformation Quirk

In SSIS when creating a Data Flow Task, you’ll usually want to have a destination for your data. From everything I’ve read, if your package is running on the same server as your destination, you’ll want to use SQL Server … Continue reading

Posted in 2008, SQL Server, SSIS | Tagged , , | Leave a comment

File System Task

I’ve used the File System task before, but it was to do a daily copy of files in a directory. I used copy directory so I didn’t have to specify or loop through any files. It was the same process … Continue reading

Posted in 2008, SQL Server, SSIS | Tagged , , | Leave a comment