Search Results | SQL Server Performance Forums

UNABLE TO DELETE FTP FILES AFTER DOWNLOAD

Post by: tthomasol, Jun 10, 2008 in forum: SQL Server 2005 Integration Services

Well, I took a different approach here and it is much cleaner and also seems to be quicker. I am using a script task instead of the ftp task. The...

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

Post by: tthomasol, Apr 11, 2008 in forum: SQL Server 2005 Integration Services

Thanks for the response, I'm not sure I follow you. My question is, how do I assign a value to a variable using the contents from a table that I...

Save a Variable From contents loaded from a table

Post by: tthomasol, Apr 11, 2008 in forum: SQL Server 2005 Integration Services

<P mce_keep="true">Should this be placed inside an OLE DB Source ?</P><P mce_keep="true">That's where I'm trying to put it and I'm getting a parsing...

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.

Post by: tthomasol, Apr 10, 2008 in forum: SQL Server 2005 T-SQL Performance Tuning

Thanks for your help Ranjit Jain,[:D] Using your advice, I got it to work the way I wanted to. Here is my final code.LEFT...

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

Post by: tthomasol, Apr 3, 2008 in forum: SQL Server 2005 Integration Services

OK, I'm feeling kind of sheepish. I'm very new to SSIS. I wrapped my tasks up in a For Loop container. I would still appreciate any other...

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?

Post by: tthomasol, Apr 2, 2008 in forum: SQL Server 2005 Integration Services

Thanks Dineshasanka! I used your guidelines and got it to work exactly as I had hopped and it's all in the SSIS package. I used a Merge Join using...

How do I compare a flat file to a SQL table to find records that are in the table but not the file?

Post by: tthomasol, Apr 2, 2008 in forum: SQL Server 2005 Integration Services

Thanks for the advice Martins, I had a similar problem in another SSIS package I put together a few months back and I solved it as you suggested but...

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...