Just another thing here. For some reason, if you need to use a query to do something, please use Execute SQL task rather than the OLE-DB command in the dataflow....

I had a similar problem in which one of the developer helped me using .NET to solve this kind of problem. Am not able to find the script. If you...

vimalap (3/6/2008)

---

Hi All,

Can anyone help me how to reuse the dataflow task in SQL server SSIS across the solutions and projects(like we have mapplets and worklets...

Dipak (3/6/2008)

---

Here I have question, I am using SQL server as remotely, and I am trying to create Excel file using SSIS, so on local machine its works fine, but...

Porkchops? Why anyone else? I will take it.....:D

Well, I know.....it is not easy without doing those things by yourself. I am a Business Intellingence developer myself and I have always...

First of all, I don't know what has happen to our page here. Its allocation is upside down. Well, lets get to the point. Did you just migrate to 2005?...

This is a great chunk of answer. You answered almost all of my questions neatly. Thanks! (Yeah, I know, nobody uses an index card nowadays, do they?)

Well, then, how do...

How would you explain about Profiler? Many think that this tool tends to slow down performance at the time it runs? How would you go about that if asked?

When you did the package, you said that you don't have problems with it in your local machine. So, can I assume that you have followed each step of package...

By simply using the "transfer login task" that can be located in Control Flow in SSIS:D

Did you try excel destination?

Also, you would probably need to save the login/password by doing so in the property window.

That's kindda tricky right there! But I believe if you know some .NET you will get what you want. My friends are saying . Net would be able to do...

I would go with Michael's method too. But you said you have tried it. Well, what and why are you deleting from an excel file? Also, where is the excel...

If you want to MAKE SURE that you want the new data to be entered everytime,(in another way overwriting) You should drag a File System Task and put it on...

Microsoft books are okay, but they are not to the extend of telling what magic things can be done like other books do. Microsoft books tend to tell you more...