Hi, I have a simple Data Flow with an Excel Source and an OLE DB Destination to upload data from an Excel file to an SQL table. The Excel file has 8155 rows. Once the package is finished running, the SQL table only shows 255 rows. The data access mode is Table or view - fast load. Any suggestions?...

Hi, I am getting the following error while using the @command([SendInstantMessage];user name). "user not found the the instant messaging community's directory" I am getting the error in some of the systems. In some systems its work fine. Please help me to solve this issue. Thanks

Hi! I need a fresher..I want a VB.net code to search record from SQL database table by using two fields of table as a condition i.e client name and client code before saving any new record and if record already exist in table it give me message for that. I'm sending you the code. Please help...

I currently have a large number of SQLite databases (that all have the same schema). Is there a way I can merge them altogether so I can perform a query on all the databases? I thought I could use "ATTACH" but I found out it has a limit of 32 / 64 databases (depending on the memory system). Can...

Hi, There is a huge trade related file which needs to be purged based on certain criteria in archive library. The question here is on main screen where we enter trade ID as key field and after entering it, PGM1 shows data related to this trade id and what the requirement is, if suppose after...

Problem: SQL SERVER is up and the instance connect is running. All required ports on Firewall is open/ also try to disable Firewall but no success. TCP/IP protocol is ENABLE. SQL SERVER port is by Default 1433. Also try this: The problem is the Instance name from the client is not resolved, to do...

On a system that has MYOB installed every time a Office file is opened a message box appears saying that macros are disabled. I understand that the problem is due to the location that MYOB has used to store their macros. Can I move them and avoid this issue ?

How can I convert an 8 digit numeric (format ccyymmdd) into a real datefield to be used in date arithmetics? I need to calculate the number of months between the month (current date) and a date represented in my DB as an 8 digit numeric with format "ccyymmdd". Therefor (I assume) I need to convert...

A BA colleague said that if requirements have been wriiten in sufficient detail that requirements acceptance criteria is not required? As a Tester I find that writing acceptance criteria for each requirement adds value as it makes the user re-examine there requirements and help clarify them.

I have 2 large Excel files, one containing yesterday's data, and another containing yesterday's data + today's updates/changes. For registration purposes, I need to find all the differences (ie new rows/entries, a value changed within the row in the new file vs the old file, etc). These excel files...

In my database, I've added a table that I thought that I was going to need but I don't need to use it anymore. Is there a way to remove that table? I've run several migrations already so the table is in my database. I thought this would handle it but I'm not sure: rails generate migration...

I'm trying to get several of my SQL Server databases under version control. Would anybody have some advice on how I should do this? Basically, I'll want a large collection of generated test data for performance management. Thanks so much!

How do I automate forwarding my weekly schedule of specific items to another user / line manager in Lotus Notes calendar? EG I want to automate my calendar entries being sent to my line manager every Friday but only for appointments.

I need to know how do I create a star schema for the data warehouse to accommodate the information below: A data warehouse is required to accumulate information on the rental market in London. It will hold information on landlords and tenants (names), houses (no of rooms, type of housing (e.g....

To follow this tag...

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy