Hi,

If you are using a web site, then it would be a better idea to use the HTTP_REFERER to read the user id and display it on the page. You...

Hi,

It would be a better idea to partition the database table to accommodate future growth in terms of columns. That means column partitioning so that the data rows are stored...

Hi,

Check this ([$action] in your Merge code. That should help you fix this error.

🙂

Hi,

I would solve this issue by using a database table to store parameters to be passed to the stored procedures. You can also store many params for your database application....

Satish,

Verify if you configured the text file source properly. And also check for the source to target mappings as well. SSIS pretty much does everything if you configure the source...

Hi

The best way to solve this issue is to create a view or stored proc in database one by referencing (joining) to the table in the second database. This...