Reputation
1,214
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
4 22 43
Impact
~248k people reached

  • 0 posts edited
  • 0 helpful flags
  • 125 votes cast
Dec
10
comment Login failure when running a SSIS package from a SQL Server job
Yes, it is done in ODBC connection, and the test connection can be established successfully there, but I know know how force SQL Server job use that credential, e.g: userId = dba not the SQL server Agent user.
Dec
10
revised Login failure when running a SSIS package from a SQL Server job
added 303 characters in body
Dec
10
answered how often to run Tablediff
Dec
10
asked Login failure when running a SSIS package from a SQL Server job
Dec
10
accepted error in Execute SQL Task with parameter
Dec
5
comment error in Execute SQL Task with parameter
It is OLE DB connection, referring to a local database.
Dec
5
asked error in Execute SQL Task with parameter
Nov
23
revised Microsoft Visual Studio is Busy
edited tags
Nov
22
asked Microsoft Visual Studio is Busy
Nov
22
asked Simulating having multiple Control Flows in a SSIS package
Nov
4
revised How to Handle Database for Application which Starts from Scratch Annually
edited body
Nov
4
revised How to Handle Database for Application which Starts from Scratch Annually
deleted 16 characters in body; added 5 characters in body
Nov
4
answered How to Handle Database for Application which Starts from Scratch Annually
Nov
3
answered Storing date increments in tables
Nov
2
accepted How to grant a user UNSAFE ASSEMBLY permission
Nov
2
asked How to grant a user UNSAFE ASSEMBLY permission
Nov
1
accepted SQL Server database generate script how to avoid adding PRINT statements
Oct
31
asked SQL Server database generate script how to avoid adding PRINT statements
Oct
31
answered Installing 32bit SSRS on 64bit Windows/IIS
Oct
30
accepted Calling a .NET method in a SQL Server script