How to combine variables
Hi, Can you give us some more information please. What software/database/programming language are you using for this? Regards, Martin Gilbert. My apologies…I am working with SPSS 17.0 and the GSS data set. I am trying to figure out how to merge the info from the variables mostimp1, mostimp2, mostimp3, and mostimp4 to use as one [...]
View Answer
| March 12, 2009 10:56 AM
Data analysis, Datasets, Variables
Hi, Can you give us some more information please. What software/database/programming language are you using for this? Regards, Martin Gilbert. My apologies…I am working with SPSS 17.0 and the GSS data set. I am trying to figure out how to merge the info from the variables mostimp1, mostimp2, mostimp3, and mostimp4 to use as one [...]
View Answer
| March 12, 2009 10:56 AM
Data analysis, Datasets, Variables
What is clipper and how would a bank use it?
“Clipper is a computer programming language that is used to create software programs that originally operated primarily under DOS. Although it is a powerful general-purpose programming language, <b>it was primarily used to create database/business programs</b>.” Read more at <a href=”http://en.wikipedia.org/wiki/Clipper_programming_language”>the Clipper Wikipedia page</a>… This is a very “mature” product but seems to have some legs [...]
View Answer
| March 11, 2009 7:52 PM
Clipper, Data analysis, IT careers
“Clipper is a computer programming language that is used to create software programs that originally operated primarily under DOS. Although it is a powerful general-purpose programming language, <b>it was primarily used to create database/business programs</b>.” Read more at <a href=”http://en.wikipedia.org/wiki/Clipper_programming_language”>the Clipper Wikipedia page</a>… This is a very “mature” product but seems to have some legs [...]
View Answer
| March 11, 2009 7:52 PM
Clipper, Data analysis, IT careers
Transform Data task properties not opening.
I believe I am having the SAME problem. At first I thought it was related to installing Internet Explorer 7 or SQL Server 2005 tools. However, I think I’ve disproved that theory. Now I’m fairly confident – but unable to prove that this is related to installation of Windows XP SP3…! I’d be curious if [...]
View Answer
| March 10, 2009 10:59 PM
Analysis Manager, Data Transformation Services, DTS, SQL Server 2000, SQL Server Analysis Services, SSAS, Transform Data task
I believe I am having the SAME problem. At first I thought it was related to installing Internet Explorer 7 or SQL Server 2005 tools. However, I think I’ve disproved that theory. Now I’m fairly confident – but unable to prove that this is related to installation of Windows XP SP3…! I’d be curious if [...]
View Answer
| March 10, 2009 10:59 PM
Analysis Manager, Data Transformation Services, DTS, SQL Server 2000, SQL Server Analysis Services, SSAS, Transform Data task
iSeries to SQL Server via SSIS 2005
You can use a script task with SSIS to change the connection string values as well as the values of other objects within the package.
View Answer
| March 6, 2009 1:18 AM
iSeries Data Source, SQL Server, SSIS, SSIS 2005, SSIS Package 2005
You can use a script task with SSIS to change the connection string values as well as the values of other objects within the package.
View Answer
| March 6, 2009 1:18 AM
iSeries Data Source, SQL Server, SSIS, SSIS 2005, SSIS Package 2005
SSIS and Microsoft Excel
I haven’t extracted data using SSIS before, but it is easy enough to use Excel and VBA as the controlling program, and pull the data from the database, and then save it to where ever you need. You can then schedule the excel workbook to open and run every night.
View Answer
| February 24, 2009 10:58 AM
Microsoft Excel, Microsoft.Office.Interop.Excel, SQL Server 2005, SQL Server 2005 import/export, SQL Server 2005 interoperability, SQL Server Integration Services, SSIS
I haven’t extracted data using SSIS before, but it is easy enough to use Excel and VBA as the controlling program, and pull the data from the database, and then save it to where ever you need. You can then schedule the excel workbook to open and run every night.
View Answer
| February 24, 2009 10:58 AM
Microsoft Excel, Microsoft.Office.Interop.Excel, SQL Server 2005, SQL Server 2005 import/export, SQL Server 2005 interoperability, SQL Server Integration Services, SSIS
New Contest: ASK, Answer and win some Amazon.com gift cards
Good luck everyone. If you have questions email me at sbrooks at techtarget.com
View Answer
| February 12, 2009 4:04 PM
AS/400, CIO, CRM, Data management, Database, DataCenter, Exchange, Linux, Lotus Domino, Mobile, Networking, Oracle, SAP, Security, SQL, SQL Server, Storage, VMware, VoIP, Windows
Good luck everyone. If you have questions email me at sbrooks at techtarget.com
View Answer
| February 12, 2009 4:04 PM
AS/400, CIO, CRM, Data management, Database, DataCenter, Exchange, Linux, Lotus Domino, Mobile, Networking, Oracle, SAP, Security, SQL, SQL Server, Storage, VMware, VoIP, Windows
Data Migration Testing
When you talk about Data migration. First you need to know the type of Data, like DB, CIFS non structured data, etc, what kind of file system you migrate, from what technology to what technology. Is the File systems (FS) are SAN, NAS, directe attached, Virtual Luns, After you need to know who is accesing [...]
View Answer
| February 2, 2009 4:25 PM
Data migration, Data quality, Data verification, Testing
When you talk about Data migration. First you need to know the type of Data, like DB, CIFS non structured data, etc, what kind of file system you migrate, from what technology to what technology. Is the File systems (FS) are SAN, NAS, directe attached, Virtual Luns, After you need to know who is accesing [...]
View Answer
| February 2, 2009 4:25 PM
Data migration, Data quality, Data verification, Testing
What are the most overused tech buzzwords for 2008?
My list of overused IT buzzwords/acronyms: - Smart Phone - Mobile Broadband - Virtualisation - REST - AJAX Nandu:-) _________________________________________________________________ Might I ADD: Value – Add! …and Is there a better way to say Solutions? Please, no more Cloud Computing? GREEN anything … Bailouts and Financial Crisis… Bush Bashing ! Bob VL _______________________________________ Not really [...]
View Answer
| January 30, 2009 10:39 PM
AS/400, Buzzwords, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Technology, Virtualization, VoIP
My list of overused IT buzzwords/acronyms: - Smart Phone - Mobile Broadband - Virtualisation - REST - AJAX Nandu:-) _________________________________________________________________ Might I ADD: Value – Add! …and Is there a better way to say Solutions? Please, no more Cloud Computing? GREEN anything … Bailouts and Financial Crisis… Bush Bashing ! Bob VL _______________________________________ Not really [...]
View Answer
| January 30, 2009 10:39 PM
AS/400, Buzzwords, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Technology, Virtualization, VoIP
Arcsight Question
Hello! I had worked in the past on ArcSight Installation/Configuration/Management, and Yes, you can configure the Manager to Pull the logs from the Snort, you will need to have physical access and password and snort.conf details as well , also, you need to configure the SmartAgents, and select the “Snort Database” and finally you will [...]
View Answer
| January 22, 2009 11:02 PM
ArcSight, Data analysis, Snort
Hello! I had worked in the past on ArcSight Installation/Configuration/Management, and Yes, you can configure the Manager to Pull the logs from the Snort, you will need to have physical access and password and snort.conf details as well , also, you need to configure the SmartAgents, and select the “Snort Database” and finally you will [...]
View Answer
| January 22, 2009 11:02 PM
ArcSight, Data analysis, Snort
SQL Server 2008 SISS error row handling
Create a second destination. Click on the source, and grab the red arrow and connect it to the second destination. When the window opens change the columns that you want to trigger a redirection to redirect row.
View Answer
| January 5, 2009 2:28 AM
SQL Server 2008, SQL Server 2008 Integration Services, SQL Server Integration Services, SSIS
Create a second destination. Click on the source, and grab the red arrow and connect it to the second destination. When the window opens change the columns that you want to trigger a redirection to redirect row.
View Answer
| January 5, 2009 2:28 AM
SQL Server 2008, SQL Server 2008 Integration Services, SQL Server Integration Services, SSIS
Moving data from one DB to another DB in SQL Server 2005
Max_Var_Size is the length of the data in the variable length columns. If you are calculating the size of data then you will want to account for the size of the index.
View Answer
| December 20, 2008 7:29 PM
Data migration, Max_Var_Size, SQL Server 2005, SQL Server 2005 migration, SQL Server migration
Max_Var_Size is the length of the data in the variable length columns. If you are calculating the size of data then you will want to account for the size of the index.
View Answer
| December 20, 2008 7:29 PM
Data migration, Max_Var_Size, SQL Server 2005, SQL Server 2005 migration, SQL Server migration
Finding which columns contain data in a table
The following query will give you that information for a specific table: <pre> select column_name,data_type,data_length,data_precision,nullable,column_id from all_tab_columns atc, all_tables at where atc.table_name = at.table_name and atc.owner = at.owner and at.owner = ‘&owner’ and at.table_name = ‘&table’ and atc.num_nulls < at.num_rows order by atc.column_id;</pre> (I tested it on Oracle 8i, thereby I could not use the [...]
View Answer
| December 10, 2008 11:34 PM
columns, Data migration, Database migration, Oracle Database, Oracle Database to SQL Database Migration, SQL Database
The following query will give you that information for a specific table: <pre> select column_name,data_type,data_length,data_precision,nullable,column_id from all_tab_columns atc, all_tables at where atc.table_name = at.table_name and atc.owner = at.owner and at.owner = ‘&owner’ and at.table_name = ‘&table’ and atc.num_nulls < at.num_rows order by atc.column_id;</pre> (I tested it on Oracle 8i, thereby I could not use the [...]
View Answer
| December 10, 2008 11:34 PM
columns, Data migration, Database migration, Oracle Database, Oracle Database to SQL Database Migration, SQL Database
Converting SQL data to Microsoft Access through coding in VB.NET
You don’t give a reason why you want to use code rather than just import the tables. You can just import the tables from SQL Server into MS Access directly and save yourself a lot of work. Is there a reason why you want to use code to perform this function? ***** Yes, I fully [...]
View Answer
| November 26, 2008 4:38 PM
Data migration, Database, Microsoft Access, SQL, Visual Basic .NET
You don’t give a reason why you want to use code rather than just import the tables. You can just import the tables from SQL Server into MS Access directly and save yourself a lot of work. Is there a reason why you want to use code to perform this function? ***** Yes, I fully [...]
View Answer
| November 26, 2008 4:38 PM
Data migration, Database, Microsoft Access, SQL, Visual Basic .NET
How to order a list?
How do you want to do this ? Are you going to write a program ? If so, what programming language are you going to use ?
View Answer
| November 13, 2008 6:09 PM
Data management, Data sorting, Sort Order
How do you want to do this ? Are you going to write a program ? If so, what programming language are you going to use ?
View Answer
| November 13, 2008 6:09 PM
Data management, Data sorting, Sort Order
Data Migration using LSMW
LSMW STEP 1 :- T-CODE LSMW STEP 2 :- press create (project) STEP 3 :- Put project name & description Press enter Put subproject and description Press enter Put object name & description Press enter STEP 4 :-Now u will get screen where your project , subproject &object will display Press execute button U will [...]
View Answer
| November 12, 2008 4:27 AM
Data migration, GL, Legacy software, LSMW, SAP
LSMW STEP 1 :- T-CODE LSMW STEP 2 :- press create (project) STEP 3 :- Put project name & description Press enter Put subproject and description Press enter Put object name & description Press enter STEP 4 :-Now u will get screen where your project , subproject &object will display Press execute button U will [...]
View Answer
| November 12, 2008 4:27 AM
Data migration, GL, Legacy software, LSMW, SAP
Monitoring the Network
This sounds like a job for SevOne, which has turned out to be the premiere networking monitoring software that is currently available. SevOne will give you very accurate utilization information, including Cisco Netflow analysis tools. Their appliance model is very appealing, it scales from 10,000 to over 1 Million monitoring elements without effort. Everything is [...]
View Answer
| October 24, 2008 2:52 AM
3Com, Availability, Bandwidth, Benchmarking, Cisco, Data analysis, Fault isolation, Firewalls, Forensics, Foundry, Incident response, Intrusion management, Network applications management, Network management software, Network monitoring, Network security, Network testing, Networking, Performance management, Protocol analysis, Remote management, Security, VPN, Wireless
This sounds like a job for SevOne, which has turned out to be the premiere networking monitoring software that is currently available. SevOne will give you very accurate utilization information, including Cisco Netflow analysis tools. Their appliance model is very appealing, it scales from 10,000 to over 1 Million monitoring elements without effort. Everything is [...]
View Answer
| October 24, 2008 2:52 AM
3Com, Availability, Bandwidth, Benchmarking, Cisco, Data analysis, Fault isolation, Firewalls, Forensics, Foundry, Incident response, Intrusion management, Network applications management, Network management software, Network monitoring, Network security, Network testing, Networking, Performance management, Protocol analysis, Remote management, Security, VPN, Wireless
Database refresh
The correct solution to refresh your database is a backup and restore solution. Why do you not want to use this solution? The Copy Database Wizard and the SSIS Database Transfer task are the same thing. The wizard simply runs the Database Transfer task. These options are only good for fairly simple databases. Once the [...]
View Answer
| October 23, 2008 11:24 PM
DBA, SSIS, SSIS database
The correct solution to refresh your database is a backup and restore solution. Why do you not want to use this solution? The Copy Database Wizard and the SSIS Database Transfer task are the same thing. The wizard simply runs the Database Transfer task. These options are only good for fairly simple databases. Once the [...]
View Answer
| October 23, 2008 11:24 PM
DBA, SSIS, SSIS database
SSIS – Bulk Inserts dynamically into various tables depending on the input file name.
You can use a .NET script via the Script Task to prompt the user for input by using an inputbox and storing that value into a .NET variable or an SSIS variable. You can use a Foreach Loop Container to loop through the files in a folder and process them. Within the loop you will [...]
View Answer
| October 21, 2008 1:32 AM
SQL Server 2005, SSIS
You can use a .NET script via the Script Task to prompt the user for input by using an inputbox and storing that value into a .NET variable or an SSIS variable. You can use a Foreach Loop Container to loop through the files in a folder and process them. Within the loop you will [...]
View Answer
| October 21, 2008 1:32 AM
SQL Server 2005, SSIS
How to create a temporary table in sql 2005 via SSIS
You won’t be able to use temporary tables with SSIS. Temporary tables are only good for the length of the session. Once the session ends (IE, you disconnect) the table is dropped. Each widget you add to the SSIS package is it’s own connection to the SQL Server. You will want to create a normal [...]
View Answer
| October 1, 2008 9:15 PM
Flat files, SQL 2005, SQL tables, SSIS
You won’t be able to use temporary tables with SSIS. Temporary tables are only good for the length of the session. Once the session ends (IE, you disconnect) the table is dropped. Each widget you add to the SSIS package is it’s own connection to the SQL Server. You will want to create a normal [...]
View Answer
| October 1, 2008 9:15 PM
Flat files, SQL 2005, SQL tables, SSIS
Why do IT projects fail?-3
First of all, I absolutely agree with Bob’s points. I had a few additional thoughts: + A very basic reason for project failure is that it does not follow any formal project methodology, which, sadly, is true in too many organizations. Not folling project metholdogies will allow just about anyting to derail any project. It [...]
View Answer
| September 30, 2008 8:11 PM
390, Cabling, Career development, Data analysis, Data mining/analysis, Data warehousing applications, Database, DataCenter, DB2, Desktops, Development, Hardware, Hubs, Linux, Mainframe, Management, Manufacturing applications, Microsoft Windows, Networking, Oracle, OS, Patch management, Project management, Routers, Security, Servers, Software Quality Assurance, Software testing, SQL Server, Switches, Tech support
First of all, I absolutely agree with Bob’s points. I had a few additional thoughts: + A very basic reason for project failure is that it does not follow any formal project methodology, which, sadly, is true in too many organizations. Not folling project metholdogies will allow just about anyting to derail any project. It [...]
View Answer
| September 30, 2008 8:11 PM
390, Cabling, Career development, Data analysis, Data mining/analysis, Data warehousing applications, Database, DataCenter, DB2, Desktops, Development, Hardware, Hubs, Linux, Mainframe, Management, Manufacturing applications, Microsoft Windows, Networking, Oracle, OS, Patch management, Project management, Routers, Security, Servers, Software Quality Assurance, Software testing, SQL Server, Switches, Tech support
