I'm working on a SSIS project that will automate every process. I still want to give it a try...

When you download the zip files, you'll notice that I have two...

i know this sounds silly but will it be helpful if i upload my zip folder so you can understand it better?

Yes, I currently have two breakpoints (onpostexecute and onvariablevaluechanged) and all the spreadsheets exist. i think it's one of my variables that didn't change dynamically.

Phil Parkin (3/28/2013)

---

Without actually setting this...

I got it fixed by replacing the data flow and I was doing the same thing. It now accepts a variable in ExcelFilePath and it runs fine except it doesn't...

Hi again,

Oops I posted the topic in wrong forum. I'm currently using SSIS 2008 but my database team plans to upgrade to 2012. Anyways, I set up a variable in...

which variable do you think will be useful for Excel Connection Manager? The OutputFileName variable?

I have placed the script task inside the FEL. I have 3 package variables named Directory, FilePrefix, and OutputFileName and they all are strings. In script task editor, the...

I appreciate your response but do you think you could give me an example in your package? Do you think that ExcelFilePath will change dynamically for every iteration?

hi, do you think you could show me your work? what i'm doing is pretty similar to your work - i have text files (a_points.txt, b_points.txt) and i want to...