Hi SMEs,Good day, hope all is well. Currently having some issue when running the bcp client in linux snaplex I was wondering on how can I pass the -u argument in the bcp client or any workaround or configuration that needs to be done in the snaplex?I...
Hello, To perform truncate/load data strategy for around 20 million records from SQL Server Source to SQL Server Target, I am trying to use SQL Server Bulk Load Snap. I understand that the BCP utility has to be installed and i have installed BCP ut...
I am trying to add a SQL Server Stored Procedure snap, but it will not connect to the existing snaps in the pipeline? What am I missing?
Hi Community, Is there a way to export information on every pipeline or specific pipelines? I want to create an external system to search for certain configurations or text within snaps of a pipeline (i.e. a query used in a SQL Server snap). Is this ...
{"Region": "Asia Pacific","Office": "Australia","Location": [{"name": "Brisbane","Latitude": "-27.4690555","Longitude": "153.0286812","OfficeAddress": "Suite 4, L20 10 Eagle Street,Brisbane, Queensland, 4000,Australia"},{"name": "Canberra","Latitude"...
Hi, I want to parse my dataset which is coming out as a string. Here is the example of the dataset [“field_name1,field_name2,field_name3,field_name4,field_name5,field_name6,field_name7\nValue1,Value2,Value3,Value4,Value5,Value6,{Val7.1:val,Val7.2:val...
Hi @RogerSramkoski i'm trying to get today's date and time in PST timezone, but it gives me null. Can you plz let me know how i can fix it?Thank you so much
Hi,I've added mapper expression to add system datetime when I insert data to Redshift table.It ran ok, but the problem is, it inserted different time for each rows.How can I get date and time that only shows only one same date and time (either pipeli...
