BobMcC (3/2/2011)

---

I receive our data extracts in .zip format. They are then un-compressed to a clean \working directory.

The file names correspond with the SQL tables they need to be loaded...

That's what I would do.

SQL Dude-467553 (2/22/2011)

---

I tried that way but it didn't like the temp tables in the stored procedure. I tried to copy the text of the procedure and use it...

SQL Dude-467553 (2/22/2011)

---

Hi All,

I've created a SSIS package that

1. Calls A stored procedure in the ExecuteSQLTask

2. That ExecuteSQLTask has the Result Set Type = "RowSet"

3. I...

I probably would use a flat file source to read the data as one column. I would then feed that one column to a script component where I would...

gladiatore85 (2/21/2011)

---

Thanks Alvin, but i cannot use the SPLIT 'cause the Categories are undefined...

Anyway i've found solution using a temp recordset, i select every distinct categories, then i loop...

The original post says:...

The "base" is what most things "sit" on, so be careful what you touch! 😀

I'm really surprised that SSIS packages are not more self aware at runtime. Hopefully there will be some improvement in 2011.

Have you tried replacing MyVariable with the variable names?

Also, take a look at DTExecUI. It can be a real savior sometimes for generating the command string for you.

They exchange camels too??

What does all of this have to do with Integration Services?

In the Control Flow, you could add a ForEach file container to hold your dataflow. Have the ForEach container pass the file name to a variable. Use that...

gladiatore85 (2/17/2011)

---

Hi everyone I need your precious help! I'm a newbie on SSIS 🙂

I'm working on SSIS 2008.

I have a parametric stored that results a multiple recordset.

Now i want...

Please avoid posting the same question in multiple forum sections.

Please answer my question in your other post.