Yes, if the web server you deploy the asp.Net application on is your SSIS Server or a server you can license SSIS on. You could also just do this...

An aggregate component in your data flow may be able to do what you are looking for - depending on your other columns.

This is not a great question.

The two options may not give you the same result.

It is typically better to not use a function within a join or where clause in...

You should be a bit worried by that.

Make sure your statistics are up-to-date. From what I have seen, the query you are running is not complicated enough that SQL...

Do you understand that the package will run from the machine that it is instantiated on? Do you also understand that this machine will have to be an SSIS...

If you specify a local join hint (LOOP / HASH / MERGE) on one of your joins, the optimizer can be forced into enforcing the join order you have specified...

What do you use this "functional id" and password to authenticate with? Is this something that can use windows authentication?

Are you able to store an encrypted or encoded password...

You have not really given a great descrioption of what you are trying to do. If you are more specific, you may get better results.

Given you are using SQL...

There is a deployment folder in the project properties. This is also where you set the server it is being deployed to.

You are not going to be able to change the number of columns returned based on conditional logic like this, but you could easily NULL out the values or change...

You are using a "SQL Server Destination" component. This is a bulk operator component that has two requirements. First, the server must be local to the server executing...

So you are getting a file with pipe delimiters between fields and a CRLF for row delimiters.

If you are getting an extra pipe at the end of the line, make...

Your situation sounds a bit fishy, but the driver does need to comply with the way the database engine accepts queries and parameters and it also must comply with the...

Yes, it can be done.

If you post some sample data in a way in which I don't have to key it in myself, I would be happy to help write...

If you are going to go with linked servers, you should use synonyms rather than views in most cases.

I am not a big fan of using linked servers extensively. ...