Category : sql-server

Hi I have a SSIS Package which has a simple dataflow with Excel to Excel data transfer.I am using Microsoft.ACE.OLEDB 12.0 driver for connection.Now in my development machine it is running fine through packages.BUt when I deploy and ran it via SQl agent job it is giving me the error ‘The step did not generate ..

Read more

SQL Server 2014 Standard edition shows Windows 10 as compatible OS. SQL Server allows unlimited concurrent connections, but Windows 10 OS has a limit on concurrent connections for file & printer and the limit appears to be 20. Does that mean if SQL server 2014 Standard if installed in Windows 10 would allow only 20 concurrent connections instead of ..

Read more

My SSIS package creates folder on the C:, copies files from network path into this folder and creates new files into this folder. To deploy this, I have connected to the SQL sever as sysadmin. Under security, configured a credential with username as domainnameuser1 and the correct password. Under SQL server agentproxies I have then ..

Read more

My SSIS package creates folder on the C:, copies files from network path into this folder and creates new files into this folder. Package is deployed to the sql server ssis catalog. To configure the package to run via sql agent job, I have connected to the SQL sever as sysadmin and: Under security, configured ..

Read more

I am unable to make a connection between kafka and SQL Server In windows. I tried with documentation (https://debezium.io/documentation/reference/1.4/connectors/sqlserver.html#sqlserver-deploying-a-connector) Already installed Zookeeper, Kafka, and Kafka Connect. Downloaded the plugins(Jar Files). I want to know where I put my plugins files(In kafka server files or …) and connection Strings. enter image description here please suggest any ..

Read more

I connect to the database on VPS but it goes to the case ‘SQL_ERROR’, I don’t know what am I missing or where is wrong, hope everyone helps. here is my code #include <iostream> #include <windows.h> #include <sqlext.h> #include <sqltypes.h> #include <sql.h> int Connect_SQL() { #define SQL_RESULT_LEN 240 #define SQL_RETURN_CODE_LEN 1000 #define MAX_STRING_LEN 255 //define ..

Read more