Importing data into SQL server from Intersystem Cache Database
I have been trying to import data to SQL Server 2012 R2 from Cache database (Inter system Cache). How could I do it? I have tried by using SSIS through which I can export data to Cache? Am I going in the right way? Please help me? Thanks in advance
Answer Question
| November 15, 2012 6:18 AM
SQL Server 2012, SSIS
I have been trying to import data to SQL Server 2012 R2 from Cache database (Inter system Cache). How could I do it? I have tried by using SSIS through which I can export data to Cache? Am I going in the right way? Please help me? Thanks in advance
Answer Question
| November 15, 2012 6:18 AM
SQL Server 2012, SSIS
Setup SSIS for a group of developers.
I newbie and I need help here. We are doing a new MS SQL and BI setup for our developers here. We have a team of 12 developers here doing different projects. We have one server with MS SQL being installed. This single MS SQL will be setup with each individual database for the projects that [...]
Answer Question
| March 31, 2012 3:16 AM
SQL 2008, SQL Server, SQL Server 2008, SSIS
I newbie and I need help here. We are doing a new MS SQL and BI setup for our developers here. We have a team of 12 developers here doing different projects. We have one server with MS SQL being installed. This single MS SQL will be setup with each individual database for the projects that [...]
Answer Question
| March 31, 2012 3:16 AM
SQL 2008, SQL Server, SQL Server 2008, SSIS
The SSIS 2008 R2 job does not complete execution
I have an SSIS package created in 2005 SP2. I have compiled this and is sheculed to run under SQL Server 2008 R2, which connects to a SQL Server 2005 database. What the package does. 1.The package FTP’s some files to the local folder. I verified to confirm the files are downloaded correctly. 2. Truncate [...]
Answer Question
| June 13, 2011 5:10 PM
SQL Server 2008, SQL Server 2008 R2, SQL Server Integration Services, SQL Server tables, SSIS, SSIS 2008, SSIS Job
I have an SSIS package created in 2005 SP2. I have compiled this and is sheculed to run under SQL Server 2008 R2, which connects to a SQL Server 2005 database. What the package does. 1.The package FTP’s some files to the local folder. I verified to confirm the files are downloaded correctly. 2. Truncate [...]
Answer Question
| June 13, 2011 5:10 PM
SQL Server 2008, SQL Server 2008 R2, SQL Server Integration Services, SQL Server tables, SSIS, SSIS 2008, SSIS Job
SSIS 2008 R2 performance and Windows Server 2008 R2 with a clustered SQL instance is slower than when connecting to a non-clustered instance?
I am testing different configurations for loading data from a remote SQL server using SSIS. In a clustered situation SSIS seems slower to speak to the local clustered SQL instance when compared to a non clustered local SQL instance. It looks like any scenario where SSIS speaks to a clustered SQL instance; the communication occurs [...]
Answer Question
| May 22, 2011 9:22 AM
Business Information Warehouse, SQL Server, SQL Server 2008 R2, SQL Server 2008 R2 Performance Monitoring, SQL Server Performance Monitoring, SSIS, Windows Server 2008 R2
I am testing different configurations for loading data from a remote SQL server using SSIS. In a clustered situation SSIS seems slower to speak to the local clustered SQL instance when compared to a non clustered local SQL instance. It looks like any scenario where SSIS speaks to a clustered SQL instance; the communication occurs [...]
Answer Question
| May 22, 2011 9:22 AM
Business Information Warehouse, SQL Server, SQL Server 2008 R2, SQL Server 2008 R2 Performance Monitoring, SQL Server Performance Monitoring, SSIS, Windows Server 2008 R2
SQL server 2008 provide access to SSIS
Client needs access to SSIS sql server 2008 Thanks, Evgenia
Answer Question
| February 23, 2011 2:36 AM
SQL Server, SQL Server 2008, SSIS, SSIS database
Client needs access to SSIS sql server 2008 Thanks, Evgenia
Answer Question
| February 23, 2011 2:36 AM
SQL Server, SQL Server 2008, SSIS, SSIS database
Refresh Excel file on a different server with SSIS package
I am trying to refresh an excel file that is on different server. is there any script that can be creatted with SSIS pacage that can do this. any help will be appriciated. Thank you in advance.
Answer Question
| November 30, 2010 8:25 PM
excel, Excel Scripts, SSIS, SSIS Package
I am trying to refresh an excel file that is on different server. is there any script that can be creatted with SSIS pacage that can do this. any help will be appriciated. Thank you in advance.
Answer Question
| November 30, 2010 8:25 PM
excel, Excel Scripts, SSIS, SSIS Package
Write Record to table as XML from RecordSet destination
Is it possible to write out each record from a recordset destination in SSIS as an XML field into SQL Server? How can this be done in either case?
Answer Question
| October 27, 2010 3:19 PM
Recordset Destination, SQL Server, SQL Server Dataset, SSIS, XML
Is it possible to write out each record from a recordset destination in SSIS as an XML field into SQL Server? How can this be done in either case?
Answer Question
| October 27, 2010 3:19 PM
Recordset Destination, SQL Server, SQL Server Dataset, SSIS, XML
Without Using Script in SSIS
HI!!! how do I alter data in SQL Server table [select, insert and delete] using SSIS Visual Studio without using a T-SQL Script… please help me T_T…. Thx so much…
Answer Question
| September 27, 2010 2:05 AM
Scripting, SQL Server tables, SQL tables, SSIS, Visual Studio 2005
HI!!! how do I alter data in SQL Server table [select, insert and delete] using SSIS Visual Studio without using a T-SQL Script… please help me T_T…. Thx so much…
Answer Question
| September 27, 2010 2:05 AM
Scripting, SQL Server tables, SQL tables, SSIS, Visual Studio 2005
SQL Server 2008 SSIS Update Command Performance Issue
Hello, In SQL Server 2008 R2, I have created an SSIS package to pull from an ODS and feed a Data Mart. To build the OLAP cube, I am using identity keys as the primary keys to the tables. TableA has 4,000,000 rows and I am updating each row with a foreign key from TableB [...]
Answer Question
| August 13, 2010 9:37 PM
SQL Query Analyzer, SQL Server, SQL Server 2008, SQL Server 2008 R2, SSIS
Hello, In SQL Server 2008 R2, I have created an SSIS package to pull from an ODS and feed a Data Mart. To build the OLAP cube, I am using identity keys as the primary keys to the tables. TableA has 4,000,000 rows and I am updating each row with a foreign key from TableB [...]
Answer Question
| August 13, 2010 9:37 PM
SQL Query Analyzer, SQL Server, SQL Server 2008, SQL Server 2008 R2, SSIS
Tool for ETL/SSIS packages testing
Which is the Best Tools for ETL/SSIS packages testing
Answer Question
| August 11, 2010 8:43 AM
ETL, SSIS, SSIS Package, SSIS Testing
Which is the Best Tools for ETL/SSIS packages testing
Answer Question
| August 11, 2010 8:43 AM
ETL, SSIS, SSIS Package, SSIS Testing
Migrating DTS packages that use mainframes source to SSIS
I am trying to migrate DTS 2005 packages to SSIS. The packages that has SQL data source is migrating around 60% but the packages having mainframes (AS400/DB2) data source is migrating only 10% what is the reason? and How to get this problem resolved?
Answer Question
| April 12, 2010 6:26 AM
AS400/DB2 source, DTS Migration, DTS package, DTS packages, SQL Server Integration Services, SSIS, SSIS 2005
I am trying to migrate DTS 2005 packages to SSIS. The packages that has SQL data source is migrating around 60% but the packages having mainframes (AS400/DB2) data source is migrating only 10% what is the reason? and How to get this problem resolved?
Answer Question
| April 12, 2010 6:26 AM
AS400/DB2 source, DTS Migration, DTS package, DTS packages, SQL Server Integration Services, SSIS, SSIS 2005
Exporting data from SSIS to Excel
I am trying to export data into Excel from SSIS. For the purpose of this question, the table is called “products” and has two columns. I would like to extract each row of data into a separate Excel file and save it with the product name so I can email it accordingly. How do I [...]
Answer Question
| April 8, 2010 3:18 PM
Excel functions, Microsoft Excel, SSIS
I am trying to export data into Excel from SSIS. For the purpose of this question, the table is called “products” and has two columns. I would like to extract each row of data into a separate Excel file and save it with the product name so I can email it accordingly. How do I [...]
Answer Question
| April 8, 2010 3:18 PM
Excel functions, Microsoft Excel, SSIS
Loading a new database from an Old one
I am new to SSIS. We are running SQL Server 2008, and I have to load a new database from an old one which had a different structure. I’m not sure how to cope with PK’s that are identities. For example, I have three tables: 1) Main table eg. A list of applications 2) Joiner [...]
Answer Question
| March 2, 2010 4:16 PM
Database structure, SQL Server 2008, SSIS
I am new to SSIS. We are running SQL Server 2008, and I have to load a new database from an old one which had a different structure. I’m not sure how to cope with PK’s that are identities. For example, I have three tables: 1) Main table eg. A list of applications 2) Joiner [...]
Answer Question
| March 2, 2010 4:16 PM
Database structure, SQL Server 2008, SSIS
where clause condtion as a variable (SSIS 2005)
Let’s say we have this query select * from customer where customerid = ’1′ My question is can we create this “customerid = ’1′” condition as a variable in SSIS and once it becomes a varible then I will extract the conditions for a column in table,
Answer Question
| February 17, 2010 9:51 PM
SSIS, SSIS 2005, WHERE condition
Let’s say we have this query select * from customer where customerid = ’1′ My question is can we create this “customerid = ’1′” condition as a variable in SSIS and once it becomes a varible then I will extract the conditions for a column in table,
Answer Question
| February 17, 2010 9:51 PM
SSIS, SSIS 2005, WHERE condition
SQL Server – SSIS
what is SSIs in Sql Server?
Answer Question
| February 18, 2010 6:03 AM
SQL Server 2005, SSIS
what is SSIs in Sql Server?
Answer Question
| February 18, 2010 6:03 AM
SQL Server 2005, SSIS
passing data between two SQL Server databases
I am having an issue to passing data between two SQL Server databases. I can not simply use Import/Export functions or Data Transfer Functions from SSIS because I was asked to transfer “20%” data with more than 15 criteria among 200 related tables. Also we are not allowed to use the linked server, which means I can not access [...]
Answer Question
| January 12, 2010 6:29 PM
SQL 2005, SSIS, Stored Procedures, T-SQL
I am having an issue to passing data between two SQL Server databases. I can not simply use Import/Export functions or Data Transfer Functions from SSIS because I was asked to transfer “20%” data with more than 15 criteria among 200 related tables. Also we are not allowed to use the linked server, which means I can not access [...]
Answer Question
| January 12, 2010 6:29 PM
SQL 2005, SSIS, Stored Procedures, T-SQL
Passing data between two SQL Server databases
I am having an issue to passing data between two SQL Server databases. I can not simply use Import/Export functions or Data Transfer Functions from SSIS because I was asked to transfer “20%” data with more than 15 criteria among 400 tables. Also we are not allowed to use the linked server, which means I [...]
Answer Question
| November 19, 2009 9:07 PM
Linked Server, Passing Data, SQL, SSIS, Stored Procedures
I am having an issue to passing data between two SQL Server databases. I can not simply use Import/Export functions or Data Transfer Functions from SSIS because I was asked to transfer “20%” data with more than 15 criteria among 400 tables. Also we are not allowed to use the linked server, which means I [...]
Answer Question
| November 19, 2009 9:07 PM
Linked Server, Passing Data, SQL, SSIS, Stored Procedures
SQL Express used for SSIS?
Can sqlexpress be used for SSIS
Answer Question
| August 20, 2009 12:18 PM
Dell PowerEdge, Dell PowerEdge 750, SQL Express, SSIS
Can sqlexpress be used for SSIS
Answer Question
| August 20, 2009 12:18 PM
Dell PowerEdge, Dell PowerEdge 750, SQL Express, SSIS
Why is SSIS xml variable in escaped format?
In SSIS 2005 I use Execute SQL task to execute a proc that returns an xml resultset using these clauses (For XML Auto, Type within a For XML Path, Type). I return that resultset into string variable User::vSelectedClients. When I look at that variable within a breakpoint, I see all the doublequote marks are escaped [...]
Answer Question
| July 1, 2009 7:44 PM
SQL, SQL Tasks, SSIS, SSIS 2005, XML
In SSIS 2005 I use Execute SQL task to execute a proc that returns an xml resultset using these clauses (For XML Auto, Type within a For XML Path, Type). I return that resultset into string variable User::vSelectedClients. When I look at that variable within a breakpoint, I see all the doublequote marks are escaped [...]
Answer Question
| July 1, 2009 7:44 PM
SQL, SQL Tasks, SSIS, SSIS 2005, XML
remove password from SSIS package
How can I remove the password from a password protected SSIS package? I need to access its source code, but as soon as I try to open it I get the window: Enter Password. I don’t know the password. This package was created by an employee who left the company a couple of years ago.
Answer Question
| June 2, 2009 4:05 PM
SSIS, SSIS Package, SSIS Passwords
How can I remove the password from a password protected SSIS package? I need to access its source code, but as soon as I try to open it I get the window: Enter Password. I don’t know the password. This package was created by an employee who left the company a couple of years ago.
Answer Question
| June 2, 2009 4:05 PM
SSIS, SSIS Package, SSIS Passwords
