GoofyKC (1/21/2009)

---

Are you saying to put the formula I put in the Expression on the connection manager, into the ConnectionString parameter of the configuration? I tried that and the results...

rfugikawa (1/20/2009)

---

Hi guys,

I need to open and to read a mdb file that is in a Windows 2003 Server 64-bit. But an error message shows when I try to do...

shabazz5th (1/19/2009)

---

Hey Guys,

I am having a problem casting an object variable.

Code:

Dim UploadRouteInformationClass as ClassLibrary.UploadRouteInformation = new ClassLibrary.UploadRouteInformation

UploadRouteInformationClass.CustomerInvoiceSums = CType(Dts.Variables("Variable").value, ClassLibrary.CustomerInvoiceSums())

Intellicense sees nothing wrong with it, but I get an...

GoofyKC (1/19/2009)

---

I have a connection manager that is the destination of a flat file. I had to set up the usage type as CREATE FILE. I put in a generic...

snowshan (1/20/2009)

---

I got a production system where SSIS package is deployed.

I see a job which runs the package (.dtsx) file on a directory.

when i open the file i see...

mgalgey (1/20/2009)

---

I have a requirement to load excel,csv or text files directly into a temp db for processing in to the live db. I have had a look at openrowset...

Matthew Cushing (1/19/2009)

---

Can I use for loops to iterate through db connections? I have a series of odbc connections that I want to cycle through and run the same...

melvin.prasath (1/19/2009)

---

hi,

When i add a new conection for a ssis package i m getting a reeor like "could enumerate the registered (microsoft.datatransformationservices.design).....

This error comes for all connection managers.....Can anyone...

mamsay (1/20/2009)

---

hi cozyroc,

my friend proposed this idea.. wil it work..

In run type

dcomcnfg.exe >>> on the left pane.. ther will be component services.. click on the '+'>>> my computer>>>COM+ Applications>>>Microsoft.SqlServer.MSMQTask…...

mamsay (1/19/2009)

---

hi wen i opend my package the following pop up appears.

do i need to install COM object. wat is that?

unable to cast COM object of type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.PackageNeutralClass' to...

mamsay (1/19/2009)

---

hi cozy roc,

as per your guidence last week i created proxy account and it ran successfully. but now its not working. i'm getting mad. wat is the reason for...

mamsay (1/18/2009)

---

hi cozyroc,

writting data into excel sheet doesn't work.. so now i changed my proceedings.. it is throwing many errors.. i think writing the excel sheet through scheduling is not...

ALIF (1/18/2009)

---

yes,, i was able to install sql server sp2 for x86 processor as the sql server version was for x86,

the only error i was getting with that was client...

ALIF (1/14/2009)

---

Hi Guys,,

I am having problem installing service pack 2 for Integration Services on a 64 bit processor,

Fist i installed the sql server and Integration services for 2005, then service...

shailesh (1/16/2009)

---

Hi,

I am trying to export all tables from a database to the text file. I am passing the table names to data flow through a variable in the for...