Thank you very much!

I am at the point of adding the FTP Task to the Fro Each Loop.

What my end goal is to pull the FTP...

Hi,

I have created a successful FTP Task.

When you say, "you can query the contents of that table in SSIS and store those in an object variable. You can...

Thank you John! Using SSIS seems like the way to go! Can I do sftp using SSIS as well?

Thank you I will get the book! =)

To create a fact table, do I literally copy the ID's from demension tables? Also, if I do not have a primary key for a demension table to I...

Thank you!

thank you for for your time and help!!!

Thank you all, the problem has been solved. What I am using is:

SELECT * FROM #ContactList

UNION ALL

SELECT DISTINCT UPPER(LEFT(vchLastName,1)),NULL,NULL,NULL,NULL FROM #ContactList

ORDER BY vchLastName, vchFirstName

Hi Alvin,

It is close to the first query. What is different is my first query will show all letters regardless if there is a lastname.

For example, my current query...

Hi, Thank you doing the union with distinct is working. What I would like to display is the letter as a header with names following. If there...

Thank you Luis! This sample is very much appreciated.

And no, the code would not go directly in a Production environment, my intent was to explain how my process theoretically...

My apologies, and thank you for your patience.

Unfortunately, I do not have a SPROC to share.

What I am trying to do is:

1. Take a data file that contains...

Thank you for all replies.

In hopes to simplify, here is my Pseudo code:

IF (vchDept='IT') THEN iDeptID=1

ELSE

IF (vchEmail like '%@abc.com' AND vchDept<>1) THEN iDeptID=2

ELSE

IF (vchEmail like '%@123.com' AND vchDept<>1) THEN iDeptID=3

ELSE

iDeptID=5

END

END

END

Hi,

Thank you for your reply.

I just double checked and no I do not have anything accidently hard coded. I use two parameters and when I run and...

Hi, I have confirmed my settings under:

1. Processing Options

2. Always run this report with the most recent data

3. Do not cache temporary copies of this report (is...