Thanks . I first copied the files to the destination folder with timestamp attached to them using a file system task and then deleted the files with another FTP task.

Thanks...

I have the data from an excel sheet . FileId is not a part of the data . I use the filename and store it into another files table with...

Not sure how to populate the FileID in the staging table from CMD_Files table .

Please help.

Was able to grab the required info from an execute sql task into the dbo.CMD_Files table with expressions SqlStatementSource --> "INSERT INTO dbo.CMD_Files (CMD_File_Name,CMD_File_Date_Loaded)

SELECT '"+ (DT_WSTR, 200) @[User::FileName] +"'...

I got it .

((Contract_Type == "DS" ) && ( [Group/Name] != "") ? "DS" : (Contract_Type == "DC" ) && ( [Group/Name] != "")...

If Cola = "DS" and ColB Is not null then colc ="DS"

If Cola = "DC" and ColB Is not null then colc ="E"

If Cola = "DC" and ColB Is null...

What is "MP_CCRET" ? IS this added to the File System task ? Please elaborate.

Yes, to the name of the file while moving to the archive folder

I get the error when I add a data flow task inside the for each loop container . Inside the Data flow task, i added a execl source .

In the...

I changed the original sheet names in the package to the ones shown below for testing.

01 --> Sheet1

02 --> Sheet2

03 --> Sheet3

I changed the original sheet names in the package to the ones shown below for testing.

01 --> Sheet1

02 --> Sheet2

03 --> Sheet3

I am trying to use the sheets Sheet1,Sheet2 and Sheet3 from the package instead of 01,02 and 03 sheet.

By default when I open an execl sheet , the worksheet names that is seen is sheet1,sheet2 and sheet3 .

Excel Version 2003 . 32 bit .

Below is the error message :

Error at DFT Extract Data From Excel [EX_SRC Get Each WorkSheet Data [1]]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error...