You need to sign in to do that
Don't have an account?
Roberto Luengo
SQLs with @ in Data Loader giving error
Hello community,
I am still stuck using the Data Loader with SQL Server. It is working great to move data from SQL Server to Salesforce, with one exception.
Everytime I use an @ in the SQL it returns an error and I believe it is because of the parameters you could pass to the SQL. However, these @s are legitimate. An example is doing an @DECLARE in the SQL to define a SQL Server variable.
Any idea?
. How do I escape the @ so Data Loader does not return an error?
. How do I use a different syntax in SQL Server so it understands @DECLARE without Data Loader breaking (e.g. ascii code)
. How do I pass a value to a Data Loader parameter by the command line (thinking that I could pass the @DECLARE string and thus bypass this problem)
I am still stuck using the Data Loader with SQL Server. It is working great to move data from SQL Server to Salesforce, with one exception.
Everytime I use an @ in the SQL it returns an error and I believe it is because of the parameters you could pass to the SQL. However, these @s are legitimate. An example is doing an @DECLARE in the SQL to define a SQL Server variable.
Any idea?
. How do I escape the @ so Data Loader does not return an error?
. How do I use a different syntax in SQL Server so it understands @DECLARE without Data Loader breaking (e.g. ascii code)
. How do I pass a value to a Data Loader parameter by the command line (thinking that I could pass the @DECLARE string and thus bypass this problem)