You're going to have a difficult time with that in SSIS. SSIS is extremely metadata sensitive and must be mapped directly to both the source and target objects. ...

It's not really dynamic since you know which columns each provider needs to populate. This can easily be done via SSIS. You just need to create a separate...

I agree with Brandie here. All of this can be done in SSIS with the native components. The biggest challenge is file formats. You'll need a dataflow/loop/package...

REPLACE does not allow for wildcards. What you'll need to do is identify the starting position for where you want to replace and either use LEFT or SUBSTRING to...

No worries, it's all part of learning. Just a suggestion, keep in mind that variables are also set quite often via expressions. I know this one was a...

I'm not sure I follow you 100%, but I'll give it a try. For starters, you cannot override an existing toolbox component as far as I'm aware. You...

OK, I'll step it out for you.

1. Add a Send Mail Task to your Control Flow, connect it after success of the previous task we set up (Execute...

You won't need the Row Count Transformation for this. Do the following:

1. Create a Variable of type int to hold your count value in.

2. Add an Execute SQL task...

I prefer the middle example using COALESCE. The problem is that your COALESCE is mal-formed. You don't need the first argument. Change it to this and it...

Hey Meatloaf...sorry for the delay, I was tied up Friday and out yesterday. So you've got two things that could be wrong here. Either you placed your expression...

It is the FTP Connection Manager that needs configured, not the FTP task. My last post discussed this. If you look at the expressions on the connection manager,...

The import/export wizard uses SSIS and allows you to save the package off. You could use that to do your first run, then save it off and use it...

You'll need a variable for each of the column names in your select list. So your initial query will load your object variable with the dataset results from the...

Right click the FTP task and go to Properties. This brings up the Properties window. Look under Misc for Expressions...click on the ellipse in the Expression value box....

Here's a walkthrough that shows exactly what I'm talking about.

https://www.simple-talk.com/sql/ssis/implementing-foreach-looping-logic-in-ssis-/

This would require that you've stored all of your FTP connection info in a table.