Forum

Syndicate content
This is a newsgroup for discussing COZYROC family of products. Enjoy.
Updated: 1 year 5 weeks ago

Re: Table difference xml output differs

Thu, 06/20/2013 - 04:00
Hi
Sorry for the late reaction, but if you still need it.
It was like Ivan said in de cummalative updates.
But you must use the correct one
for sp1 : use CU1 for SQL 2012 SP1
Or first install de CU3 before SP1
Op woensdag 27 februari 2013 13:41:18 UTC+1 schreef jrr...@gmail.com het
volgende:
Categories: News

Re: SFTP Password variable

Thu, 06/20/2013 - 04:00
You don't need to write script to setup the *ConnectionString* property.
Just create configuration which setups the connection manager property from
outside.
Categories: News

Re: SFTP Password variable

Thu, 06/20/2013 - 04:00
It would be great if I could write a script task like this
[link]
Does anyone know what properties I would load for a SFTP task?
Categories: News

Re: SFTP Password variable

Thu, 06/20/2013 - 04:00
Hi,
You can load the complete ConnectionString property for the connection
manager dynamically from a configuration file and you can specify the
updated password there.
Categories: News

SFTP Password variable

Thu, 06/20/2013 - 04:00
Hello,
I am new to SSIS and I have created a project to download some files from
an sftp server periodically. An issue I have come across is the password
for the SFTP changes monthly. Is there a way I can load the password as a
variable and change it from another source?
Categories: News

Getting Error from Data Flow Task + When Dynamically Loading Flat Files to Dynamic Destination

Thu, 06/20/2013 - 04:00
I'm loading a series of files dynamically to corresponding tables. When I
run, I get the following error.
Error: System.Runtime.InteropServices .COMException (0xC0010014): Exception
from HRESULT: 0xC0010014
at
Microsoft.SqlServer.Dts.Runtim e.Wrapper.IDTSConnectionManage rFlatFileColumns100.Remove(Obj ect
Categories: News

Setting up a Data Flow Source

Thu, 06/20/2013 - 04:00
Trying to setup a Data Flow Source so I can use a function in database B
against a recordset from database A. Am I on the right track?
I'm getting an error about my connection manager the no such interface is
supported.
I've created a Data Flow Destination with my recordset from database A but
am not able to setup the Data Flow Source. I'm thinking the Data Flow
Categories: News

Re: Data Flow Task Plus 2012

Thu, 06/20/2013 - 04:00
[Flat File Source [123]] Error: An error occurred while skipping data rows.
[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The
PrimeOutput method on Flat File Source returned error code 0xC0202091. The
component returned a failure code when the pipeline engine called
PrimeOutput(). The meaning of the failure code is defined by the component,
Categories: News

Data Flow Task Plus 2012

Thu, 06/20/2013 - 04:00
Are there any known issues with using the Data Flow Task Plus component on
2012? I'm receiving the following error when I try to map to a destination
column with various column formats:
[Flat File Source [1]] Error: Data conversion failed. The data conversion
for column "ACCOUNT_ID" returned status value 2 and status text "The value
Categories: News

Re: Exchange Connection Manager issues - Receive Mail Task

Thu, 06/20/2013 - 04:00
Ebere,
Another update. You will need to have minimum Exchange 2010 to use the
Exchange connection manager.
If not possible, I would recommend you enable the IMAP protocol on your
Exchange server and use the IMAP Connection Manager<[link]>instead.
Categories: News

Re: Exchange Connection Manager issues - Receive Mail Task

Thu, 06/20/2013 - 04:00
Hi Ebere,
You have to have Exchange 2007 SP1. Please check.
Categories: News

Exchange Connection Manager issues - Receive Mail Task

Thu, 06/20/2013 - 04:00
Hi
I have been tasked with developing a mail system to download email
attachments from Exchange email address.
I downloaded
COZYROC SSIS+ 1.6 SR-1 Library
I am using Receive Mail Task in my BIDS. Under MailConnection, I have
supplied
Host
User name
Password
It fails with
TITLE: COZYROC SSIS+
Categories: News

Re: Using CozyRoc Excel Destination Plus

Thu, 06/20/2013 - 04:00
Yea I got this to work by clicking the option "Save at End". Seems pretty
straight forward but I had unchecked it. On the website the explanation
states "Indicate that the workbook is to be saved at the end." I was
reading it as make a "copy" saved off at the end. Not sure why you would
ever want to use Excel as a destination and not save but regardless the
Categories: News

Re: Using CozyRoc Excel Destination Plus

Thu, 06/20/2013 - 04:00
In the CozyRoc Excel Destination Editor, the Save-at-End must be checked.
If you write to multiple tabs, only the last one need be checked.
Otherwise nothing is saved.
-MB
Categories: News

Re: Using CozyRoc Excel Destination Plus

Thu, 06/20/2013 - 04:00
I have also downloaded and installed the latest release of the components
and that made no difference.
Categories: News

Using CozyRoc Excel Destination Plus

Tue, 05/14/2013 - 04:00
I have a DataFlow with a basic OLE DB Source and pumping it into excel
using the CozyRoc Excel Destination Plus. The package is successful, all
messages say that my 20 rows are being written to the file but when I go
out and open the file it is empty.
Does anyone have any experience with this?
Categories: News

help with dynamic ax (2009) connector

Fri, 05/03/2013 - 04:00
Hi there !
I was asked to try to connect Dynamics AX2009 through a ssis package.
So I installed the ax .net buisness connector on my ssis server. then I
installed your package then I created a dataflow and added a connection to
ax (that is running on another server) and when I hit the 'try connetion"
Categories: News

Microsoft GP Dynamics Connection Error

Fri, 05/03/2013 - 04:00
I'm new to CozyRock and GP Dynamics Development, but not to SSIS dev.
Anyways, I'm evaluating this to do some custom data imports/exports, but i
can't even connect to the GP server.
I am trying to create a new Dynamics-GP Connection. When I enter the
information for the server, I get an error:
The Web service works from Jitterbit, but fails from CozyRoc component. I
Categories: News

Error while setting SFTP connection

Thu, 05/02/2013 - 04:00
Hi
I am getting error while setting SFTP Connection through FTPS connection
manager. I am setting connection type as Explicit SSL.Please Check the
attachment.
Error - Secure connection was closed by the remote connection end.
(Rebex.Ftp)
Secure connection was closed by the remote connection end.
Categories: News

Re: How does CozyRoc for CRM work with the 5000 record paging limit ?

Thu, 05/02/2013 - 04:00
Hi Matt,
Yes, it will page automatically.
Categories: News