Thank you clarifying I appreciate it.

My code sample I wrote quickly and I should have provided a better example.

Thank again. 🙂

Hi Jeff, thank you for the tip! However, this did not solve the problem. Looking at my CSV file in notepad, the last row looks like this:

7,1412,1

Instead of:

7,1412,1,,

Of...

Hi,

Is it possible to enter this string into a temp table?

SELECT @PivotQuery = 'SELECT ' + @Columns + @ColumnsMinMax + 'FROM Fill_Rate_Summary_Total;'

EXEC sp_executesql @PivotQuery

this is so helpful, thank you very much!

Hi,

I have been working on this for a bit and have a new challenge. Using the sample data and code below, the result will show InvMax, and A through...

great thank you very much!

Thank you John! Amending my original code, I would actually like to do something like this if possible:

DECLARE @cmd varchar(500)

SELECT filename,

CASE

WHEN Processed_Flag = 'E'

THEN

SET @cmd='MOVE /Y C:\temp\myfiles\'...

I am currently using a For Each loop to pull down files from an FTP site. Is it possible to also have the same For Each loop to insert...

So my new challenge is when I have multiple records returned for my For Each Loop, I now get the "The password was not allowed." error message again.

To solve this...

I have solve the no password issue by changing the Package Protection Level from EncryptSensitiveWithUserKey to EncryptAllWithPassword then creating a new password in the PackagePassword field.

Thank you John!

Thank you John!

Within my foreach loop I have the FTP Task only, to confirm is this what you mean by data task? All I have in the for loop...

Hi,

I am hoping someone may be able to help me with this issue.

When creating the FTP Connection Manager, I add the following fields to my ConnectionString expression:

@[User::FTPServer] + ":21." +...

Hi, When creating the FTP Connection Manager, I add the following fields to my ConnectionString expression:

@[User::FTPServer] + (DT_WSTR,10)@[User::FTPPort] + "." + @[User::FTPUser] + "." + @[User::FTPPwd]

When I...

Thanks again for all your help this far! My apologies as I know this one is like pulling teeth.

I have attempted to configure the expression with the FTP Task Editor...

Hi, So in my case I believe I will need multiple variables is this correct? I believe I will need variables for each FTP Server, FTP User, FTPPwd,...