This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Trying to do ETL to move source data to target db. I don’t want to create a pipeline for every single table. There are hundreds of tables.
To start I want it to do this simply and assume a truncate and reload of all the tables. I will worry about ...
Can anyone point me to a comprehensive video or explanation re: Error Pipelines?
The documentation leaves out a lot of details.If an error occurs, I want to pass in the value of $ProcessId (as one example) to the error pipeline so that I can flag the...
I am grabbing an object in Salesforce using the Salesforce Read Snap.
I am using SQL Bulk Load and it is flagged to create table if it doesn’t exist.
My numeric types are not being created in SQL. Almost everything is coming over as varchar(8000).
I...
Everytime I pull data from SQL Server / Salesforce etc, if the data type is bit, it returns a string of ‘true’ or ‘false’ that I am then having to convert back to a 0 or 1.
How do I get this to behave differently?
I have data I need to move from Oracle to SQL Server. In Oracle the data type is just “NUMBER”. No precision or scale specified.
I know from analysis that these values are in some of the rows for one of the columns.
.2010259556758395029265468931284...
I am having the same issue. I think the connection Authorizes when I set it up.
But when I go execute, I get the same error.
Error occurred while querying the daily job limits with url
I am extracting data for the purposes of loading a data warehouse using the bulk api as stated in my original post.
The match data type documentation is not clear. It only applies in certain circumstances. I have checked and unchecked and run the p...
I have turned this on and off several times. The documentation is confusing. That property only seems to apply in certain cases but the UI isn’t disabling it when it doesn’t apply.
It chokes because the source is bit and the destination is bit. It is converting bit to string and then when it tries to insert into the target, it fails.
I have it working with a mapper but it seems like they should stop converting bit to string.
Thank you for the suggestions.
I am doing the mapper solution now.
Why should I have to cast a field as int when it is already a bit and therefore not string?
I don’t really want to do either of these options but it seems I have no choice.
I just wan...
