SQL Server Performance

Log in or Sign up

Search Results

UNABLE TO DELETE FTP FILES AFTER DOWNLOAD

Thread by: tthomasol, Jun 6, 2008, 1 replies, in forum: SQL Server 2005 Integration Services

I have an SSIS package setup to check for XML files from a specific folder on an FTP server. The first Task is an FTP download and copies everything...
Save a Variable From contents loaded from a table

Thread by: tthomasol, Apr 11, 2008, 5 replies, in forum: SQL Server 2005 Integration Services

I'm new to SSIS and I'm trying to load a variable from a table. Can anyone tell me how to dot that? I want to SELECT TOP 1 VAL FROM TBL WHERE...
Attempting to Query Data from 2 different servers based on contents of first query

Thread by: tthomasol, Apr 10, 2008, 1 replies, in forum: SQL Server 2005 Integration Services

I am so frustrated, what I'm trying to do seems like it should be so easy but I can't figure out how to pull it off. I have Server1 with an Old...
Using CHARINDEX to extract when exists but not when it does not.

Thread by: tthomasol, Apr 8, 2008, 2 replies, in forum: SQL Server 2005 T-SQL Performance Tuning

I am attempting to pull some data from an old invoice system where the Address Information is stored in the same field with a char13 and char10 to...
Monitor a folder for a file creation event using WMI Event Watcher

Thread by: tthomasol, Apr 3, 2008, 1 replies, in forum: SQL Server 2005 Integration Services

I want to monitor a folder for the creation of a file using SSIS. I then want to move and process the file and when I'm finished continue monitoring...
How do I compare a flat file to a SQL table to find records that are in the table but not the file?

Thread by: tthomasol, Apr 1, 2008, 4 replies, in forum: SQL Server 2005 Integration Services

I'm Fairly new to using SSIS and I'm trying to figure out how to approach the following situation. I have a flat file with variables that come from...

Showing results 1 to 6 of 6