1,174 reputation
41943
bio website
location Sydney, Australia
age
visits member for 2 years, 7 months
seen Mar 3 at 5:09

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
Oct
30
comment Calling a .NET method in a SQL Server script
As I had mentioned above the CSharp code provides a method that gets a string, manipulates it based on a complex logic and returns the converted string. This new string will be loaded in the target table. So I get a string (column value) from a source table, run the CSharp method (somehow) and writes the converted value to the target table. The number of source records are to be converted and loaded would be around 20,000.
Oct
30
comment Execute job every time database changes - execute job on each change-event
Could you explain more about the "every time database changes"? Are you referring to data changes in the source tables?
Oct
30
asked Calling a .NET method in a SQL Server script