connection-manager

Accessing Excel data source running SSIS package on 64 bit server

Hello, I have an SSIS package that exports data to a couple of Excel files for transfer to a third party. To get this to run as a scheduled job on a 64 bit server I understand that I need to set the step up as a CmdExec type and call the 32 bit version of DTExec. But I don't seem be able to get the command right to pass in the connectio...

How do I get SQL Server Integration Services to use a different database connection for Package Configuration

Hello, I have an SSIS Package that sets some variable data from a SQL Server Package Configuration Table. (Selecting the "Specify configuration setings directly" option) This works well when I'm using the Database connection that I specified when developing the package. However when I run it on a server (64 bit) in the testing environm...

Windows Mobile 6 intermitent connection problem NOPATHTODESTINATION

On a Windows Mobile 6 device we are trying to open an internet connection. This usually works but sometimes we get a return code of 0x80004005 with a status of CONNMGR_STATUS_NOPATHTODESTINATION. When this happens it will keep happening but if you launch IE on the device, it will connect and then our call to ConnMgrEstablishConnectionS...

How to create dynamic number of output files with SSIS?

I will be creating flatfiles and based on the data in the batch, it might be necessary to split the data into an undetermined number of files. I can make the connection string dynamic with an expression, but that is only evaluated when the package starts. I'd like to change that expression to include a '-a' or '-b' in the filename. Al...

Windows Mobile: "My network card connects to" registry settings

Can anybody please tell me the registry setting(s) that are affected in Windows Mobile 6.1 when a user selects Start -> Settings -> Connections -> Wi-Fi and then changes the value of the "My network card connects to" drop down list on the "Network Adapters" tab? I have a device that seems to default this to "The Internet" when in fact t...

Fail to resolve a name when calling ConnMgrEstablishConnectionSync()

Hi Guys, I'm trying to setup a GPRS connection with ConnMgrEstablishConnectionSync(), so far so good, the connection is established and if I try to connect to an IP address, everything works fine. Alas, when I try to resolve a name: ConnMgrEstablishConnectionSync(); ... gethostbyname("www.google.com"); The result is always an error: ...

Configuring punjab to send xmpp requests to Openfire

Hi, I am trying to use the punjab connection manager with Openfire. I have an already running Openfire server. I have also installed punjab and the server starts properly, allowing me to navigate to the port 5280 on localhost. (Although http://localhost:5280/http-bind gives a "resource not found message".) I am not sure how to proceed ...