What errors do you get? Did you have SQL 2005 installed in advance?

srinivasable (4/15/2010)

---

Thanks for the Reply.

I am doing in windows Server 2008 box with SQL 2008. I upgraded all the packages but I am getting error for the Checksum and Trash...

Which machine is doing the actual execution? When you say "executing package...

srinivasable (4/12/2010)

---

Hi,

I have 200 to 240 SSIS packages for SQL 2005. Now we are in the process of upgrading from SQL 2005 to SQL 2008. We are using konesans (Checksum...

You cannot set the variable from there. You can set it only in the PostExecute method.

You can accomplish this without a need to write a...

Why not use the standard Send Mail...

LOOKUP_BI-756009 (4/6/2010)

---

I was able to grab data from Oracle using the [Oledb Source] Connection Manager without any problems.

But I would like to use script task instead to connect, perform validation...

seeteshh (4/1/2010)

---

Hello,

Has anyone coded a script task that will upload 2 or more files to an FTP folder?

I have done the same using a ForLoop and an FTP task but...

Hi,

This is CozyRoc. The...

daustinash (3/26/2010)

---

I'm going to be creating some custom transforms over the next few months and did a bit of poking around looking for a place to contribute them to and...

Why do you use script component to read from ODBC ? You can use the standard DataReader Source component to get your data.

Exercise in perseverance. Congratulations on your patience!

M Shah (3/18/2010)

---

Using linked server with select into will lock the table right until the insert is done? The server that the data is finally moved to is used...

M Shah (3/18/2010)

---

Good question. It is a third separate machine. So is the data brought into a buffer on this third separate machine? Please let me know?

Thank...