kim.talley (2/3/2009)

---

I have an SSIS package that needs to run periodically to pull all rows from a table in MySQL. This table is updated frequently on MySQL and I am...

sql-oholic (2/3/2009)

---

Sorry to bother u again... but i didn't get it clearly.

Can you explain it a bit more ...

I assume it has to start with creating user variable...using it in...

sql-oholic (2/3/2009)

---

Hi there,

I have lots of SSIS pacakges where connection manager points to OLE DB connection. Now, I have new password for SQL server login.

Do I need to manually change...

latingntlman (2/2/2009)

---

I need to add a "Cache Transform" transformation to the data flow but I don't think BI studio 2005 has it b/c I've looked everywhere I could think of...

Pit,

You have to setup...

latingntlman (1/30/2009)

---

Thanks for the info. Unfortunately I need to know how to get to step 1. Do I connect to integration svcs from sql mgmt studio, or do I...

latingntlman (1/30/2009)

---

Hello all, I've gotta import daily counts from an Excel file that someone manually maintains into a table that will be called by a sproc that an RS report...

bkirk (1/29/2009)

---

I'm trying to export SQL Products table containing both ntext & nvarchar fields out to a flat file destination using SSIS package.

All data fields for the products table...

martinchavezf (1/29/2009)

---

It didn't work. I wrote my code below. I tried clearing the attachments files but it keeps my file in use.

I tried with these lines too:

myHtmlMessage.Attachments.Clear()

myHtmlMessage = Nothing

mySmtpClient =...

bhadrinath.medi (1/29/2009)

---

Hi,

How to rectify the following error?

An error has occurred while establishing a connection to the server. When

connecting to SQL Server 2005, this failure may be caused by...

dhanasekar.palani (1/28/2009)

---

I have a main table which has 55 million rows..I am populating a staging table from the main table with the conditions as from date to date...I wrote...

martinchavezf (1/28/2009)

---

Hi Forum,

I have a SSIS package with the following:

1. A XLS (excel) file is created on "C:\MyFile.xls" from a Query (This is OK)

2. I send these File by...

stricknyn (1/28/2009)

---

Interesting,

Unfortunately I can't invest in any third party products. I'll try the raw file source/destination part and see how that works out.

On a side note, do you know...

matt (1/28/2009)

---

Hi

I have a SSIS package that exports data to excel, it creates all the sheets ok, but because the source file cannot have no sheets, i am left with...

jlduncan935 (1/28/2009)

---

We have an SSIS package data flow task currently using default buffer size settings that delivers data to a raw file after a series of lookups, transformations, and a...