Hi Brandie,

Im the one who sent you the link for the FTP Upload Function in your previous post.Was waiting for your response since you mentioned of getting someones help.Anyways looking...

A Little Help Please (12/17/2008)

---

Column 4 is the correct column, I just changed it for this example.

Are you just doing a regular file dump, Flat File > Ole db Destination...

Are you just doing a regular file dump, Flat File > Ole db Destination ?

Are there any other transformation taking place in between?

I have copied your 1 row of data...

I checked the site I sent you earlier,and the examples are using ip address As Const ftpURI As String = "ftp://127.0.0.1/"

http://www.windowsdevcenter.com/pub/a/windows/2006/12/12/building-ftp-services-using-net-20.html

Can you connet to the ftp site using...

Im using the ftp address [no ip or port specified]

Example ftp3-uk.sqlcentral.com.

Not sure if it works with ip address.Give it a try and let me know.

This is the Upload Function that I am using to upload any Binary Files [.zip/.txt/ and etc...]

Imports System

Imports System.IO

Imports System.Net

Imports System.Text

Public Shared Sub FTPUpload(ByVal filePath As String, ByVal fileName As...

Steve,

The method that I could think of is directly using a Script Task that performs the below.

- Read the single column from the sql table and create an array of...

A Little Help Please (12/8/2008)

---

thats incorrect I dont need 10 columns,

I can state how many columns i want to use and map them to the relative DB columns.

I have justed...

Since the column delimeter is "," you should have total 10 columns coming in from your flat file and mapping to a table with 10 columns as well.

You should add...

Go into your Flat File Connection Mng and ensure the following:-

Advanced Tab > There should be 10 columns and the data type and length of each are correct.

Also these are...

You loop over all .txt files below and only want to pick file's that have matching end characters as in your table column below,regardless of the first "xxx_yyyymmdd" characters. Is...

vj,

Not sure what you mean by 'last week every friday'.

I have several report being subscribed with start and end month/date parameters.Example,Start Month is [first day of last month,Nov 1] and...

Try this.

Set Option Strict Off [/b]at the top of Script Task

If Dts.Variables("JobSiteCode").Value <> "" Then [NOT NULL]

Dts.Variables("sJobSiteCode").Value = Dts.Variables("JobSiteCode")Else

Dts.Variables("sJobSiteCode").Value = ""

End...

Hi,

Not sure if you had read the following post.Looks similar to yours

http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=2660355&SiteID=1

Hi there,could you explain more on what you are trying to accomplish ?

All files come into a single dir and have diff names, you would like to store file names...