havejeet (3/23/2009)

---

Hi all,

I want to import all the records from Active Directory into my SQL Server 2005 Table(s),is it possible with Integration services of SQL Server?

can it be parameterised ?...

John Bates (3/20/2009)

---

hi experts,

As I understand, you cannot store the FTP password in the FTP Connection Manager - so I need a way of assigning that value to be able...

A Little Help Please (3/20/2009)

---

Example

If I have 10 SSIS packages and they all use SendMail (SMTP) and one day the SMTP server changes.... I have to go into each SSIS...

volkorna (3/20/2009)

---

Hi,

I have a flat file, it size is more that 2.5 Gb. The file is not formatted appropriately and I have to read in one column [text stream] for...

Matthew Cushing (3/20/2009)

---

The issue is in the datareader, so going out to the progress db is an issue. When using For Loops, is there a certain number of connections...

Matthew Cushing (3/20/2009)

---

I am having an issue that you might be able to help me with - I've got it all set, but I would like to have it so...

ammit.it2006 (3/19/2009)

---

I am using one varible in the script task and put it in the varible list in REadwriteVaribale list.

Now I used the same varible in the another Script task...

Matthew Cushing (3/17/2009)

---

Sorry about that. I felt stopped by not being able to set up the connection right.

Thanks for your help.

[update 11am]

I think I understand now. I need...

peterk1961 (3/16/2009)

---

Hi,

We are in the process of upgrading to sql 2005 from sql 2000. I have read lot of posts which talk about SSIS processing done on memory for the...

rcr69er (3/16/2009)

---

Hi Guys

I have a folder that has a number of pdf files within it. This folder is regularly updated and may not always have the same amount of files...

You...

Matthew Cushing (3/16/2009)

---

CozyRoc (3/16/2009)

---

You can put your connection information anywhere you want. The idea is that it should be a list you can iterate over. I would advise a SQL...

Unfortunately it is impossible with the standard framework. There might be a possible solution, which involves using CozyRoc commercial library. Let me know if interested.

pcapazzi (3/16/2009)

---

You can ditch the dbconnection object I suggested. It was just to get the general idea across of changing a source. My goal is to programatically swap one of...

Matthew Cushing (3/16/2009)

---

CozyRoc (3/16/2009)

You need only one variable and you use this variable in the expression. You have to have a list with databases and each database iteration will be...